What should be my relative path to this file?

[Manish_Jain11]

What should be the relative path to give in my column to this file XYZ.pdf

The location from the root folder of my google drive are as follows

App location

appsheet/data/myapp/files/XYZ.pdf

Data source (Google Sheet) Location

folder1/folder2/folder3/mydatasource

[Suvrutt_Gurjar]

Could you update how those files are created?

[Manish_Jain11]

These are pdf files are created using Automation

What I want is after its created , I want to open the files from my table where I have given one column for this file. That column shows the file icon which when clicked should open the file that was created. So I need to give the relative path of this file in the column.

[Suvrutt_Gurjar]

Please go through the following post wherein @Rich of AppSheet team has described the approach to attach such files to a record in file type column.

Get URL of workflow generated file Questions

So basically I have a simple workflow that creates a file from a template and saves it in a specific place in my Google Drive. This workflow happens every time a specific action is done. new files are constantly being created and saved in the google drive. How (when the file is created) can i fetch the URL of the SPECIFIC file that was created, to store in a database where users can then view each of these files?

[Manish_Jain11]

Thanks Mr.Gurjar,

This looks great.Let me try this but just in the same time , I think I have been able to solve the solution suggested by @Aleksi too. I got confused between Add shortcut to drive and Add to drive. I tried shift+Z earlier but dint seem to work , probablysome mistake but now it did. What its doing basically from my understanding is creating a replica of the folder, sort of shortcut but not exactly , it opens in the same location but any changes in the folder (addition or deletion of files) is reflected in both the folders.

[Suvrutt_Gurjar]

Good to know that. Since you know the finer details of your app, you will be the best judge to know which method suits you- both are from AppSheet experts @Aleksi and @Rich.

It will be good if you post the link to @Aleksi 's solution for any future readers of this post thread.

[Manish_Jain11]

I do not have any link to his detailed post - just a couple of comments above from @tsuji_koichi and @alexsi.

[Suvrutt_Gurjar]

Got it. Thank you.