How do I get Shared Drive files?

AppSheet AppSheet Q&A
1

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.

1 Like
2

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.

5 Likes
3

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.