I want every record in one of my tables to li...

[Marc_Dillon]

I want every record in one of my tables to link to a PDF file in a shared Google Drive folder (different PDF for each record). Right now I’m having to copy the URL of that PDF manually and paste it into the URL column.

Is there any sort of file selector pop-up, for a column of type File,URL, or something else entirely, that will easily allow a user to select a file somewhere on Google Drive?

[tony1]

@Marc_Dillon If you use a file type column, you can use paths relative to the table’s sheet.

If your sheet is in /path/to/data/MySheet and you have a file in /path/to/data/files/File1.pdf

THEN

you can put “files/File1.pdf” as the value in your file column.

See this example app: https://www.appsheet.com/samples/An-app-for-a-teacher-to-distribute-and-collect-class-assignments-?a...

[Marc_Dillon]

I tried that as well. Still needed to manually enter the exact filename. I’m assuming that is a “no” to the file browser popup? I suppose I will post a feature request.

[tony1]

@Marc_Dillon That’s a no. However, if your filename is determined by some other column in your data, you could write a formula:

“myFolder/” & [Some column] & “.pdf”