LinkedIn
Twitter
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>'/data/ELAERPCloud-Dev-809448033/Evaluaciones_Files/EV-1.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, 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 'ELAERPCloud-Dev-809448033', 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 'Evaluaciones_Files', 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 'EV-1.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>
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.
Solved
1 ACCEPTED SOLUTION
