Creating new folder in Google Drive from Appsheet

[HazemDardar]

Hi 

I have one view wich is linked to my sheet It's Contacts list sheet .

Is it possible to automate when someone Add a new contact it automatically create a new folder in Google Drive and name the folder to be similar to the contact ID 

Another thing is it possible to let users see this Folder and see it's contents.

Thank you.

[dbaum · Accepted solution]

Create an automation with a Call a script task that calls a function from an Apps Script project that creates the folder, sets its permissions, and returns the information you need to provide a link to the user via the app.

[JuanRomo]

Hello,

Ok after you create the folder and so on, how you see the folder as part of the record so you can upload files to it. I have use the options of creating a GDrive Folder Table as Data Source, but I can not dinamically assign the subfolders to the view. 

[HazemDardar]

Thank you @dbaum for your Kind Support.

I'm new to appsheet not experienced 🙃 

I know you helped with the solution, i hope that someone made  youtube video on how to do it 

Thanks alot