PDF Generated In Appsheet not found

AppSheet AppSheet Q&A
1

I am trying to create a feature in my app where after a form is filled out, it can be exported as a PDF stored in my Google Drive, and then open again in the app. I am able to generate the pdf successfully and find it in the folder I chose for it, but when I try to open a file using the file path, it will have the exact same name as the pdf I’m looking for but it is showing this:

Screen Shot 2022-08-16 at 9.42.15 AM.png
Screen Shot 2022-08-16 at 9.42.15 AM.png1560×858 43.3 KB

My default app folder is: /appsheet/data

When creating the PDF, it is stored in: “/Files/”

The file name prefix is: [Key ID] (timestamps are disabled)

The file path is being changed to: CONCATENATE(“/appsheet/data/Files/”,[Key ID],“.pdf”) and then that is the file that is opened when my second button is clicked.

I am also waiting each time or re-syncing the app until the PDF shows up in my Google Drive before opening the pdf. I have two buttons: One called “generate PDF” that creates the PDF and adds it to my Google Drive, and Open PDF, which opens the file that was created.

2

You don’t need an absolute path like this one ^

You need a relative path from your spreadsheet POV. This have been explained a lot of times

2 Likes
3

What is a relative path? Only the key ID and the pdf then?

4

Do you know what a path is? Basically all of the stuff before a filename and extension.
Relative path means that it’s a path that describes how to go to the file from the spreadsheet location

1 Like
5

HTML File Paths

1 Like