Automatically creating folder in drive for new item added to table

[MichelleUK]

Process:  I have a meeting workspace. When a new meeting date is added as a row to the meeting table, I go into drive create a new folder and name it using the meeting date. Then in the meeting form I amend the Drive link to the folder location. This means the documents used for that meeting can be found easy.

Is there a way to automate this?

Thanks

[TeeSee1]

You can probably do it by integrating the creation of a new meeting record and a Google Apps Script.

Create a meeting -> Create a folder -> Update the meeting record with the created folder info

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

https://support.google.com/appsheet/answer/10105002

https://automatescript.com/2020/03/17/create-folder-and-file-using-google-apps-script/

[MultiTech]

If you create a file, even if it's just a starting place-holder with no data inside it, you can folderize the placement of that document using Automation.

In a recent video, I showed how to create a Report table - part of this is folderizing the reports as they're made.

More Info: https://support.google.com/appsheet/answer/11568421#foldername-formed