How do I get Shared Drive files?

[chansol]

Hi.

I am trying to open files from Google Shared Drive of my Google Workspace account.

I set a column named 'File' and set the column type as 'File'.

I have a Shared Drive named 'Shared Drive Test' and I wrote the file path "/[TeamDrive]Shared Drive Test/2.png" in the 'File' column.

But it's not working.

The error page says that:

  - '/[TeamDrive]Shared Drive Test/2.png' not found

  - N/A, Searching for '[TeamDrive]Shared Drive Test', File entry not found

  - N/A, Searching for '2.png', File entry not found

I referred to the below document, but I still don't know why this happens.

https://support.google.com/appsheet/answer/10104795?hl=en

Does the prefix "[TeamDrive]" should be changed in other regions?

For a workaround, I'm making shortcuts of Shared Drive folders in MyDrive to access the Shared Drive. But I believe there is a better way.

Can you please help me?

Thank you.

[Marc_Dillon · Accepted solution]

The linked article refers to the app's default folder. Which is different from a File or Image column's path. A File or Image column's path can only be relative (at same level or below) to where the spreadsheet is located.

[krisssaito]

I have the same error, and tried your method but cannot figure out what went wrong

My dafault app folder is: /[TeamDrive]1.6 情報システム部/Appsheet Data

The file is in: /[TeamDrive]1.6 情報システム部/Appsheet Data/販売管理-576608774-24-02-16-2/Invoices_export/

I added file path as: 
CONCATENATE("/Appsheet Data/販売管理-576608774-24-02-16-2/Invoices_export/",TEXT([作成日],"yymmdd"),"_",[請求書番号],"_",[請求書名称])

while this is the file name:
TEXT([作成日],"yymmdd")&"_"&[請求書番号]&"_"&[請求書名称]

Please someone help me out.