Open Google Drive folder/directory from URL

AppSheet AppSheet Q&A
,
1

Hello all!
Here what I’m trying to do:

  1. once a new object is created for the table “Project”
  2. the app creates a subfolder inside the directory of the app
    In particular I have something like: /appsheet…/project/123/dir**
  3. I would like to store the Google Drive URL to open this → /appsheet…/project/123/

Do you think it is possible?

I mean, copying the URL and pasting manually inside the form as field yes..
But I would like to recover the URL automatically :sweat_smile:

2

You could do it by calling an Apps Script to automatically create sub folders.

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

If you create directories based on say, the project name, then a VC can easily create the appropriate URL.

2 Likes
3

If the user is uploading any files into a form, appsheet can make the subfolders itself, by specifying an appropriate file/folder path expression.

However to obtain a URL to open the gdrive folder, that requires the folder id, which appsheet does not expose, but can be gotten from an app script as TeeSee mentioned.

2 Likes