Can't open pdf files

[byrons612]

Hi Everyone,
New to Appsheets, pretty exited about the low code platorm but I am stuck with the following issue:

SCENARIO: I have an application with a Work Oders table and Work Order view.
Also have created a boot that automatically creates and updates a PDF file every for ever new row added to the table.

Also have a virtual colum(Preview Work Order / Type = File) with the link to the corresponding pdf created by the boot.

ISSUE: File won’t open. due to the link. Tried many thing and can’t get to work. Debugging found out that the problem is the link type.

File is hosted on google drive.

1. Direct link wont work: https:myapp.com/pdfs/filename.pdf
2. Relative link wont work: pdfs/filename.pdf
3. Shareble link Works!!! https://drive.google.com/file/d/sampleid/view?usp=sharing

What can I do to make relative url to work?
Otherwise how can I retrieve the sharable link for the corresponding file?

Any solutions highly appreciated .

[Aurelien]

HI @byrons612

Actually the most common workaround is to store a filename first with relative path, then use this filename to create your file.
Please have a look to this post, I tried to describe step by step and explain the purpose of each step:

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…