Second , File Created in my google drive > location is
“My Drive/appsheet/data/TestDeliveryRack-2295790/SavefilePDF/Schedule_20210101AAA20210102_1038.pdf”
Third , I want appsheet preview my PDF > I create virtual column type “File” > I’m formula =
“My Drive/appsheet/data/TestDeliveryRack-2295790/SavefilePDF/Schedule_20210101AAA20210102_1038.pdf”
1:50 2/3/2021 i find a way to run file in google drive
the problem is google spreadsheet
i create new google spreadsheet and make table Report
it’s work OMG T^T .
i dont know why my main google spreadsheet cannot run report ( 404 file not found )
Path to file must be relative to the sheet location in drive.
My usual paths are something like “data/attachments/file.pdf” , not “my drive/appsheet/data/…”
I found problem now
info > properties > app properties > default app folder is = /appsheet/data/myapp-1234/
but
my googlespreadsheet is = /Somefolder/googlespreadsheet
then
I change default app folder = /Somefolder and OMG it’s work T^T .