Hello everyone,
I have 2 apps with the same Default app folder : "Test". I have a pdf File in relative path : Files/M0022.pdf
So I tried to open the file using the relative path (Files/M0022.pdf). The first app displays the pdf, but the other shows this message :
<body style="margin:20px">
<div>'Files/M0022.pdf' not found</div>
<div>Probable cause: N/A</div>
<div>Path: Root</div>
<div>Result: FAILURE</div>
<div>Message: N/A, Searching for 'Files', File entry not found</div>
These 2 apps have the same options. So I really don't know what happens. Do you have any advice ? Thanks
Solved! Go to Solution.
When using Google Sheet with the file column (or images, etc), the default app folder doesn't have any affect. Only the Bot uses it.
Do these two apps have the same spreadsheet as a data source?
No. The one which opens the pdf has a BigQuery as datasource. The other app which fails has a Google sheet as datasource. Why the datasource could be the reason ?
When using Google Sheets, the path needs to start from the folder where the spreadsheet is. It sounds your spreadsheet is not there.
Thank you AleksiAlkio. So the Default app folder is not the root folder when using a GSheet ? Ok I try...
When using Google Sheet with the file column (or images, etc), the default app folder doesn't have any affect. Only the Bot uses it.
Thank you so much AleksiAlkio. It works !
You're welcome!
I have the same problem, but I haven't found where to change the path so when I click the document it opens correctly and not with this error
Have you created the file with the automation Bot or have you added your files directly to Google Drive?
I created with the automation bot, it saves in the folder files, but when I try it to display it on the app it shows me the error
Any solution on how to display de pdf on the app?
You need to have one file column where you either write the path + file name or you read it with the virtual column. And the path needs to start from the folder where the main data source is.
I already have the file column with the path + file but I still have the error when I try to open de document on the app.
What is the path from the Root where the pdf file is? Same question about your spreadsheet? And what is the saved path and file name in your spreadsheet?
PDF - concatenate("/appsheet/data/BIODIQRO2024-1330436/files/",[FOLIO]," ",[ID CLIENTE],".pdf")
PDF name - concatenate([FOLIO]," ",[ID CLIENTE])
spreadsheet - MI UNIDAD/ADMIN/BDD
spreadsheet name - Concentrado
column name - PDF
and for the PDF column - concatenate([FOLIO]," ",[ID CLIENTE],".pdf")
When using a file column, the app tries to find your pdf file starting from the folder where the spreadsheet is. Now your spreadsheet is in Root>MI UNIDAD>ADMIN>BDD and because the path in the file column is set as appsheet>data>BIODIQRO2024-1330436>files, the app tries to find the file from Root>MI UNIDAD>ADMIN>BDD>appsheet>data>BIODIQRO2024-1330436>files which doesn't exist.
How do you suggest to do it?
One workaround is to add a shortcut in Drive for your "files" folder. The "Files" folder should be in Root>MI UNIDAD>ADMIN>BDD>files and file column could have CONCATENATE("files/",[FOLIO]," ",[ID CLIENTE],".pdf")
Thank you so much!!! It works!! 🙂
Good yo hear!
User | Count |
---|---|
28 | |
14 | |
3 | |
3 | |
3 |