Reading an auto generated file

[jchuman]

Hi, I have set up an automation to generate a pdf file and tried to add a relative path on a file column to open that pdf but got an error message “File entry not found”.

The pdf is generated successfully under the file path: Workflow, with the file name, let say “test”, and the default app folder is set to be /appsheet/data,

I put the file column with a formula
concatenate("/Workflow/", “test”, “.pdf”)

Would like to know if I have made any mistakes while setting up the path, thanks a lot.

[Aurelien]

Hi @jchuman

Here is an example:

How to call the PDF Link that i created Questions

Hi @John_Paul_Armisa What you want to achieve is pretty similar to what is described in this post: You have to keep in mind that the link you want to provide is a relative path from your default folder path. With Automation, I reproduced it this way (other similar options exist, this is ONE option). The purpose here is to create a quote, store it in a team drive and giving access to user then. To do so, I make an action, visible to users, to write “filename” in quoteFile column. Then, the…