Unable to point to a PDF

[Davidflash]

I have a data table with a virtual column named "PDF", filetype is File.  I am unable to figure out how to point to the PDF location in my appsheet/data/appname/Files/my.pdf.    The virtual column formula is:

CONCATENATE("appsheet/data/VISAVISA-2660420/data/Files/", "GiftCards", ".PDF").  When I click on the virtual column it tells me the file not found file.  I tried CONCATENATE("GiftCards", ".PDF").  Same results.

[Davidflash · Accepted solution]

Okay, it did not work.  My virtual column formula is 

My Bot File Name Prefix is

The PDF is created and resides in the /Files folder.

What should do?  Confused....

[Joseph_Seddik]

File path is relative to where your source sheet is. So if your source sheet is in: appsheet/data/VISAVISA-2660420/data, your path then should be: /Files/

[Davidflash · Accepted solution]

Okay, it did not work.  My virtual column formula is 

My Bot File Name Prefix is

The PDF is created and resides in the /Files folder.

What should do?  Confused....

[Davidflash · Accepted solution]

I gave up, and just moved the sheet to the /Files folder of the App. folder.  Did not want to do it but I needed to move on complete the app.  However, there must be a way to point to any file location with the Google Workspace using Appsheet.