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>
Solved! Go to Solution.
How have you written the formula that writes the path and file name?
Does your path start from the folder where your spreadsheet is?
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.
You're welcome!
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,
Javier
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!
User | Count |
---|---|
17 | |
14 | |
8 | |
7 | |
4 |