Problem with automation opening pdf

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>&#39;/Informes/BOLETO1245878.pdf&#39; 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 &#39;Informes&#39;, 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 &#39;BOLETO1245878.pdf&#39;, 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>

 

Solved Solved
0 7 140
5 ACCEPTED SOLUTIONS

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

View solution in original post

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

View solution in original post

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.

View solution in original post

It works !!!!.

Thank you very much, Alek for your help.

View solution in original post

7 REPLIES 7

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

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

Regards,

JavierCaptura de pantalla 2024-04-26 173932.jpg

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

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

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.

It works !!!!.

Thank you very much, Alek for your help.

You're welcome!

Top Labels in this Space