Cannot open a PDF from the app

[yosinuri]

Hi I am new to Appsheet and need help.

I build an invoice app and everything work great I can generate an invoice and save it on the drive but. when I'm trying to view the invoice from the app I'm getting an error that the patch cannot be found.

'/appsheet/data/FruitBySheliApp-5746430/Files/ab61023e.pdf' not found

Probable cause: N/A

Path: Root

Result: FAILURE

Message: N/A

[WillowMobileSys]

Did you try looking on your Google Drive to verify that the path is there, that the PDF file is indeed in that folder path and that you are able to open the PDF file?

[ea_9000]

Hi

What i did is create a column that hold the invoice number in the order table and used the value as file name when saving to drive.

once the file was save an action to open the file used same value. 

[Suvrutt_Gurjar]

If you are using Google drive as a storage for your invoices and your invoices are not stored in multiple sub folders, you could evaluate  folder as a table option. 

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Document-Processing-Folder-as-a-Table/m-p/28319...

The file view based on folder as table will look like something below

[ea_9000]

1- add column

2- add action to create pdf (concatenate("Files/",UNIQUEID(),".pdf"))

3- open file

I had one issue with file path as it get created in sub/sub folder to , I truncate the file at creation time , hope this could help.

cheers

Emad