Open file action suddenly stop working

AppSheet AppSheet Q&A
1

I have a bot that creates a pdf file, then saves it in a folder, then an action creates the file path and assigns this address to a column, there is another action that opens this path from the table view, this was working fine, but couples days ago, every time I try to open the path, I get an error in html form, saying file not found, I’ve checked the path by typing it in the browser bar, and it works, so its something else.

the column where the path is store y type file:

concatenate(“G:/My Drive/appsheet/data/IMPGT-1701678/Envios/”,“IMP ENV-”,text([No Envio]),“.pdf”)

This is an example of the final path created and afterwards can be open by an action, but as I said is no longer working.

G:/My Drive/appsheet/data/IMPGT-1701678/Envios/IMP ENV-3,262.pdf

As I said, everything was working, but somethin changed and stop working,

I also turn of and turn on, Require Image and File URL Signing, and made no change.

Since it was working fine, Im lost to where to look.

Be advice I have no programing experience and that Im learning on the go, and by reading docs and watching videos.

Please help

here is the html text error

   <html>
        <body style="margin:20px">
          <div>'G:/My Drive/appsheet/data/IMPGT-1701678/Envios/IMP ENV-3,262.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</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, 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 'data', 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 'IMPGT-1701678', 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 'Envios', 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 'IMP ENV-3,262.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

This kind of path would never work. First, it’s a path only on your local machine. Second, it’s a path from the root of GDrive, apps can only access paths at or below the location of the main GSheet. You need to use a relative path to the file from the GSheet location. That would probably be this (but no guarantee, it’s just a guess):

Envios/IMP ENV-3,262.pdf

3

Hello Marc…

the funny thing is the path was working flawlessly for months, so perhaps, if you look the file is inside the app folder, I remember reading that appsheet would read files inside the app’s folder…thank you for your input, I will test it to see if works…