info open pdf

[michele79]

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

[Aurelien]

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

[michele79]

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

[Aurelien]

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"

[michele79]

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?

[Aurelien]

---

@michele79 wrote:

should the pdf file folder be inside the appsheet folder?

---

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 🙂

[michele79]

yes indeed, but there are thousands of pdf files, thanks anyway

[Steve]

Display images and documents - AppSheet Help