Not able to open generated report from appsheet - Page 2

diyorapiyush · 12-17-2023 09:25 PM

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>&#39;appsheet/Customer/A-0201-Ravi Ghelani.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</div>
               <details>
<ul>
<li><div>
                  <div>Path: Root</div>
                  <div>Result: FAILURE</div>
                  <div>Message: N/A, Searching for &#39;appsheet&#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;Customer&#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;A-0201-Ravi Ghelani.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>

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