Fix File Upload Link in Google Sheet

[irongiant]

Is there a way to still be able to click the link in Google Sheet to get to the pdf I uploaded through AppSheet? I see the file location in the column but they aren't hyperlinks to the file. Is there a trick to fix this? I like using AppSheet on mobile but would prefer to just use the Google Sheet on the desktop.

[Marc_Dillon]

See the "External URL for Image Files" section in this article for starters:

https://help.appsheet.com/en/articles/961605-displaying-images-and-documents

Another option would be a Google Apps Script that uses the relative file path to find the actual file, then output a GDrive link into another column.

[irongiant]

Thanks. I might do the google script to make a new column.