Solved: Unable to access to a PDF file via virtual column ...

GeovannyCL · 02-13-2024 10:17 AM

Hi all,

I was wondering if this is an active forum. I have an Employee Performance Dashboard, with the following workflow:

1. Admin "Saves" a record to another table, lets call it "ResultsTable". This works fine.

2. A pdf is generated and stored on Google Drive (I created a custom folder path named "Evaluaciones_Files" under my Apps folder in the drive). The file name is CONCATENATE([numeroEvaluacion],".pdf"). This works completely fine.

3. The file created should be displayed in the ResultsTable respective row. (Problems)

For this step i did following:
- I created a virtual column named "PDF File", saved the column type to "file". Added the following formula CONCATENATE("/data/"MyAppName"/"Evaluaciones_Files/",[numeroEvaluacion],".pdf").

- Added the virtual column to the view. It displays correctly and it shows the "file icon"

OUTCOME:

The PDF File column is showing in the record and the pdf is generated. But when the user clicks on the file, it is showing an error message instead of the pdf.

        <html>
        <body style="margin:20px">
          <div>&#39;/data/ELAERPCloud-Dev-809448033/Evaluaciones_Files/EV-1.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</div>
                  <details>
<ul>
<li><div>
                     <div>Path: Root</div>
                     <div>Result: FAILURE</div>
                     <div>Message: N/A, Searching for &#39;data&#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;ELAERPCloud-Dev-809448033&#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;Evaluaciones_Files&#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;EV-1.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>

Is this something related?

Hope you can help me out. Im struggling, i saw tutorials regarding this approach and it worked completely fine. Not sure what im missing. @MultiTech or actually any other expert.

GeovannyCL

Hello @AleksiAlkio , I was doing some research and troubleshooting and notice that the Sheets DB im using was not under the apps Folder in google Drive. By moving my DB inside the App Folders Name "ELAERPCloud....." the below formula works fine:

- CONCATENATE("/data/MYAPPNAME/Evaluaciones_Files/",[numeroEvaluacion],".pdf")

Thank you for your response.

View solution in original post

AleksiAlkio

When you have a file column, the path needs to start from the folder where the gSheet is. In general your formula would work if it's in the Root > appsheet folder. Is it there?

GeovannyCL

Hello @AleksiAlkio , I was doing some research and troubleshooting and notice that the Sheets DB im using was not under the apps Folder in google Drive. By moving my DB inside the App Folders Name "ELAERPCloud....." the below formula works fine:

- CONCATENATE("/data/MYAPPNAME/Evaluaciones_Files/",[numeroEvaluacion],".pdf")

Thank you for your response.

AleksiAlkio

Excellent!

peterson

Well, the steps to achieve this are the following:

1. Make sure you enable this toggle below: It'll prevent appsheet from adding aditional characters in the file name.

2. Check the default app file path by going in the settings >> Information and checking it as below. Copy this path.

3. Create a virtual column with like this:

"/Default app folder/subfolders/" & "App name" & ".pdf"

If you still need help, check my post related to this issue.

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Learn-how-to-open-a-file-generated-in-Appsheet/m...

Unable to access to a PDF file via virtual column using CONCATENATE("FilePath",[fileName],".pdf")