Solved: Open pdf file not found error

Vincent_Martin · 07-18-2024 07:27 AM

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

AleksiAlkio

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.

View solution in original post

AleksiAlkio

Do these two apps have the same spreadsheet as a data source?

Vincent_Martin

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 ?

AleksiAlkio

When using Google Sheets, the path needs to start from the folder where the spreadsheet is. It sounds your spreadsheet is not there.

Vincent_Martin

Thank you AleksiAlkio. So the Default app folder is not the root folder when using a GSheet ? Ok I try...

AleksiAlkio

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.

Vincent_Martin

Thank you so much AleksiAlkio. It works !

AleksiAlkio

You're welcome!

KARLA_CR

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

AleksiAlkio

Have you created the file with the automation Bot or have you added your files directly to Google Drive?

KARLA_CR

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

KARLA_CR

Any solution on how to display de pdf on the app?

AleksiAlkio

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.

KARLA_CR

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.

AleksiAlkio

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?

KARLA_CR

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

KARLA_CR

and for the PDF column - concatenate([FOLIO]," ",[ID CLIENTE],".pdf")

AleksiAlkio

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.

KARLA_CR

How do you suggest to do it?

AleksiAlkio

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")

KARLA_CR

Thank you so much!!! It works!! 🙂

AleksiAlkio

Good yo hear!