LinkedIn
Twitter
Hi,
I have created an app where it creates reports of my format. The report created is saved in my google drive. I can open those reports from google drive. However, I am not able to open those reports from App sheet itself. Check screenshots below.
In Settings, my default app folder is
In action, I am using this formula to save this text in report column,
In Auomation,
File Folder path is ,
File Name Prefix is,
When I generate report and click on open button, new tab opens and gives me this error,
<html>
<body style="margin:20px">
<div>'appsheet/Customer/A-0201-Ravi Ghelani.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</div>
<details>
<ul>
<li><div>
<div>Path: Root</div>
<div>Result: FAILURE</div>
<div>Message: N/A, Searching for 'appsheet', 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 'Customer', 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 'A-0201-Ravi Ghelani.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>
I am not able to find the solution. Please help me out.
Let me know if you need anything else from my side to more about the app
@Steve @TeeSee1 @1minManager @Aurelien @Suvrutt_Gurjar @AleksiAlkio @Landan_QREW @Koichi_Tsuji
In general, the bot settings look good.
Hope you have ensured that you have disabled the following setting of "disable Timestamp" in the bot.
This is so because in the action name when you are defining the file name, the timestamp part is not included. I believe it is of course better to disable the timestamp from the bot and include one from the app record if necessary so that while constructing the file name you can use that timestamp column value from the record.
