Shared Drive file not accessible?? ?

AppSheet AppSheet Q&A
,
1

I’ve been struggling with getting a file column to open a file, when that file lives inside a shared drive.

  • The default app folder is set correctly (with the whole [TeamDrive] thing)
  • The file column’s value is exactly the same path for the file
  • File creation tasks work, creating the folders and files necessary in the shared drive

I keep saying there’s no way this was left not working; meaning the file column not being able to access files inside a shared drive.

  • There’s no way that the devs would have released this shared drive things with the file column NOT working… there’s no way.
  • So I have to have something off.

Yet look as close as I can… everything seems to be just so.

So I figured I’d ask before I start going down a hole:

  • Has anyone gotten a file column to successfully open a file that was shared inside a shared drive?

Here’s hoping! :crossed_fingers:

2

Yes! In my application, the file column is working correctly to open files inside a shared drive.
Does the value you entered in the file column start with Appsheet/Data/“APPNAME”/?

3

Well.. never one to be deterred…

Always another way (matrix) - reduced.gif

I made a work around using GAS, thought I would share if anyone’s interested.

The Basics: I included a secondary step to call a script to find the file that was just made and get the URL for it; then we record this into a URL column (separate from the File column) so we have both.

MultiTech_0-1742679436716.png
MultiTech_0-1742679436716.png1135×1527 34.6 KB

You can read more about it on my blog, and access the script if you need to work around this issue as well.

1 Like