Solved: BUG: pdf file link stop to works when it wants

C2 · 12-01-2023 08:25 AM

Hi!

some time ago I switched from a Google Sheets db to AppSheet Database, now I want to go back and I'm copying all again into Google Sheets.
Almost everything seems to work, but one thing I really don't understand why it doesn't work.
With a bot the app generates PDFs that are opened with columns with formulas.
for example: CONCATENATE("files/", "name of the file",[OtherColumn], ".pdf").
The files open with the icon that is automatically generated in the actions.
Without changing anything just by changing the database from appsheet to google sheets the link stops working.
The bot works and the pdf files are always generated correctly but when I try to open the same link (which I haven't changed) it doesn't find the path.

the error is the classic one:

 <html>
        <body style="margin:20px">
          <div>&#39;/data/OPEN/files/"name of the file",[OtherColumn].pdf&#39; not found</div>
          <div>Probable cause: N/A</div>
          <div><ul><div>
   <div>Path: Root</div>
   <div>Result: FAILURE</div>

if i just connect again the appsheet DB intead of google sheets DB everything work again!

Can anyone solve this mystery? Thank you!

C2

the problem was solved moving the Gsheet DB file in the principal app directory folder (was in a sub folder)

View solution in original post

AbdullaNsour

Hi, Have you reviewed the syntax of CONCATENATE() ?

I used this to open my file, check if there are a differences.

C2

Yes I use the same syntax. Works if I use AppSheet database, stops to work if use a google sheet database

C2

the problem was solved moving the Gsheet DB file in the principal app directory folder (was in a sub folder)