Problem with automation opening pdf

AppSheet AppSheet Q&A
1

Hi you all!!!

Hi have an automation that create a pdf document using a Google Docs template. When I try to open the file with the action: External: Open a file, I get this message. Can anybody give light about that? Thank you very much in advance.

       <html>
        <body style="margin:20px">
          <div>'/Informes/BOLETO1245878.pdf' not found</div>
          <div>Probable cause: N/A</div>
          <div><ul><div>
   <div>Path: Root</div>
   <div>Result: FAILURE</div>
   <div>Message: N/A</div>
   <details>
<ul>
<li><div>
      <div>Path: Root</div>
      <div>Result: FAILURE</div>
      <div>Message: N/A</div>
      <details>
<ul>
<li><div>
         <div>Path: Root</div>
         <div>Result: Success</div>
</div>
</li>
<li><div>
         <div>Path: Root</div>
         <div>Result: FAILURE</div>
         <div>Message: N/A</div>
         <details>
<ul>
<li><div>
            <div>Path: Root</div>
            <div>Result: FAILURE</div>
            <div>Message: N/A</div>
            <details>
<ul>
<li><div>
               <div>Path: Root</div>
               <div>Result: FAILURE</div>
               <div>Message: N/A, Searching for 'Informes', File entry not found</div>
               <details>
<ul>
</ul>
</details>
</div>
</li>
</ul>
</details>
</div>
</li>
<li><div>
            <div>Path: Root</div>
            <div>Result: FAILURE</div>
            <div>Message: N/A, Searching for 'BOLETO1245878.pdf', File entry not found</div>
            <details>
<ul>
</ul>
</details>
</div>
</li>
</ul>
</details>
</div>
</li>
</ul>
</details>
</div>
</li>
</ul>
</details>
</div>
</ul></div>
        </body>
        </html>
2

How have you written the formula that writes the path and file name?

1 Like
3

Hi Alek!!! Thank you for your answer. I attach a screenshot with the formula.

Regards,

Javier

Captura de pantalla 2024-04-26 173932.jpg
Captura de pantalla 2024-04-26 173932.jpg1456Ă—889 75.3 KB

4

Does your path start from the folder where your spreadsheet is?

1 Like
5

No. They are in different paths.

The default app folder is: /appsheet/data/ESCANDALLOA1-1286579/, and the pdf store in: “/Informes/”,“BOLETO”,[NUMBOLETO],“.pdf”). The spreadsheet is in Google Drive, in “My Drive” folder

6

When using image, file, thumbnail etc. columns, the default folder doesn’t have anything to do with them. The spreadsheet needs to be in the folder where the file path starts.

1 Like
7

It works !!!.

Thank you very much, Alek for your help.

8

You’re welcome!

1 Like