GDrive File Management Workflow

AppSheet AppSheet Q&A
, , , ,
1

Hi, I just want to ask if the current appsheet version has this functionality for an app.
Sorry, I’m still an Appsheet beginner.

Suppose I have 2 tables:

a) Projects (parent records)

b) Files (child records of Projects)

Workflow:

  1. Make a new project in app.
  2. Automate to make a GDrive folder for file attachments under this new project.
  3. The Gdrive folder url is recorded in the Projects table.
  4. If a user opens the url link to the Gdrive folder and upload files to it, a sync in appsheet will populate the “Files” table with records of the uploaded files in the folder (related to the parent record).
  5. Once the “Files” were populated, the user can access and select a file in Appsheet and open it.

Reason for such feature:
Sometimes the user want to upload multiple files directly to GDrive, instead of single file uploads in Appsheet.

Just want to ask if the above is possible.

The above feature requires multiple folders for actual folder management in GDrive (a parent record will have its own folder to contain its child record file attachments).

I saw that importing Gdrive as a source is possible, however, the target folder is fixed, and I can’t use formula to refer to a generated folder for a parent record id in “Projects”?

2

  1. Easy

  2. Difficult. You’d need an automation to create the folder.

  3. Difficult. Another automation to get the Drive URL.

  4. Difficult. Another automation to gather the list of files and their URLs, and to update the app. And a sync would be insufficient; it’d have to be a repeating scheduled update.

  5. Easy

1 Like
3

Thanks for the feedback. Will check into Appscript and automations.

I hope they expand GDrive functionality for file storage and queries in Appsheet.

2 Likes