Open Google Drive folder/directory from URL

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 😅

0 2 256
2 REPLIES 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.

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.

Top Labels in this Space