PDF files in google drive

Please can anyone help with this problem, I have exhausted all the community comments, read and reread app 101, tried dozens of different video tutorials,to no avail. The thing is the app had been working perfectly until about 3 weeks ago, when something seemed to happen with google drive, nothing has been the same since. I just can't seem to be able to get it right.

Any help would be greatly appreciated.

ERROR GENERATED WHEN TRYING TO VIEW FILE IN APP

https://www.appsheet.com/template/gettablefileurl?

Error retrieving file '1352.pdf': URL has an invalid signature.

Drive path

Appsheet/data/appname/files

Spreadhsheet here

Pdf auto generated files are stored here via bot

Appdefault folder path from info

/appsheet/data/TaxInvoicingAppcopy-123292425-23-08-29

Table Invoice_Log appformula for column=Pdf Link (Url)

CONCATENATE(

"https://www.appsheet.com/template/gettablefileurl",

"?appName=",ENCODEURL("TaxInvoicingAppcopy-123292425-23-08-29"),

"&tableName=",ENCODEURL("Invoice_Log"),

"&fileName=",ENCODEURL(Concatenate([Invoice Number],".pdf")))

Behaviour

Open Url (Pdf Link)

External: go to a website

Target=[Pdf Link]

Attach to column = Pdf link

Launch External

Bot configurtion

All changes

File prefix

Concatenate([Invoice Number],"-",[Version])

No folder path set (using default Files)

Bot works fine

Security Settings

Encrypt device data  (blue)

Require image and  file url signing (blue)

Everything else blank

Data in this app is public, app does not require signin

Form SAVE event action Open Url (Pdf Link) DOES NOT WORK should open detail view

Spreadsheet updates OK  slow to sync to drive

I check before trying to retrieve the file

And still get the error

Solved Solved
0 5 3,414
1 ACCEPTED SOLUTION

Thanks for your suggestions. Managed to do your suggestions. Did not want to work last night, but this morning I actually managed to open a file.  Have been reading up on the sync issue and trimmed down the tables where possible. All seems to be better at the moment.  Hope it continues. Once again thank you for your response.

View solution in original post

5 REPLIES 5