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! Go to 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.
User | Count |
---|---|
18 | |
14 | |
11 | |
7 | |
4 |