hello, I have a google sheet, containing columns, example: id; name; filename; the filename is 1234567.pdf. I have a folder on google drive containing about 1000 pdf files; how do i use appsheet to open files directly I tried entering the folder path but it doesn’t work; could i use an action? I use excel on my pc, and I can get it to work with =HYPERLINK(folderpath;foldername;filename), but I would like to use appsheet. Thank you
Hi @michele79
Did you consider using this?
Compile folder contents - AppSheet Help
Otherwise, you could try this:
How to call the PDF Link that i created - Google Cloud Community
2 Likes
unfortunately I can’t, it’s probably much easier than it seems but it doesn’t work. I should just enter the path but I can’t
Just thinking again over it:
Basically, a file is made accessible for the user because of the relative path of the document.
If your files are in the default app folder of your app, you could have it with a path made this way:
"/" & folderName & "/" & subfolderName &"/" & fileName & ".pdf"
1 Like
I tried like this, surely I’m doing something wrong and it doesn’t work. the folder where the files are contained is on google drive, as is the sheet used to develop the app. should the pdf file folder be inside the appsheet folder?
1 Like
In short, this is it 
Otherwise, you will have to provide a url for each file, but this is another thing to build and it may be tedious
2 Likes
yes indeed, but there are thousands of pdf files, thanks anyway