+ Reply to Thread
Results 1 to 3 of 3

Google Sheet // Automatically linking to an document, based on filename

  1. #1
    Registered User
    Join Date
    02-26-2024
    Location
    Berlin, Germany
    MS-Off Ver
    Office for Mac
    Posts
    2

    Google Sheet // Automatically linking to an document, based on filename

    Hello everyone,

    I am putting together a short overview of costs for a friend of mine in a google spreadsheet. I also upload all receipts of those costs into google drive, so he can access them.
    Inside my spreadsheet, I am able to put the exact filename of each receipt next to the cost. So I was wondering how I could use this filename to link directly and automatically to this specific document inside of google drive. Is there any way of doing this? I do not want to link each entry to an individual document manually.

    Thanks for your help and ideas.

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Google Sheet // Automatically linking to an document, based on filename

    Hi,

    You would need to use apps scripts to locate the file by its name then link to the file using its file id.

    So, unless you are prepared to learn JavaScript you may want to just manually put the file links directly.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  3. #3
    Registered User
    Join Date
    02-26-2024
    Location
    Berlin, Germany
    MS-Off Ver
    Office for Mac
    Posts
    2

    Re: Google Sheet // Automatically linking to an document, based on filename

    Ah, I see. So when there is not easy non-scripting way, I might ask ChatGPT to write some code and I'll do some trial and error.
    But many thanks so far.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to move data automatically from row to other row in Google Sheet?
    By fermipan in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 02-12-2024, 04:13 AM
  2. convert .xlsm file to google sheet document using vba
    By kriskris12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2022, 10:53 AM
  3. Google sheet: Help to attachment file from Google Drive and send email fill in Google Form
    By sbv1986 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-01-2021, 10:47 PM
  4. Google Sheet - Export to Excel Automatically
    By jerryr0125 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 12-16-2019, 04:35 AM
  5. Replies: 7
    Last Post: 05-22-2018, 08:58 AM
  6. [SOLVED] How to email word document as an attachment with filename taken from text in document
    By laxminarayana in forum Word Programming / VBA / Macros
    Replies: 7
    Last Post: 03-08-2018, 04:46 PM
  7. Automatically rename worksheet based on filename
    By cyee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-04-2017, 01:56 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1