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:
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.
@appsheetmaria wrote:CONCATENATE("/appsheet/data/Files/",[Key ID],".pdf")
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
What is a relative path? Only the key ID and the pdf then?
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
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
17 |