Good news! I’ve already created your Google Drive based application.
Please watch this demo (replace [DOT] with real . symbol):
youtu[DOT]be/A30lYzuvhQ8
How it works :-
1. Particulars about a new project such as project manager name, client, project name, etc. are submitted through the Form.
2. Destination Spreadsheet automatically assigns a unique Id to that project
and triggers a back-end Script that creates the project folder and required subfolders under a pre-created folder for the project manager.
3. Also a link to that project folder is automatically created in the Spreadsheet so that you can open the folder directly from the Spreadsheet.
Please initiate a chat for any query.
I have expertise in integrating Google Apps Script code-snippets with Google Docs applications (Sheets, Docs and Form).
- Winner of multiple ‘Google Sheets + Apps Script’ oriented contests.
- Recently worked on a similar project, creating Custom Utilities for Google Sheets, and now waiting for my client’s final review.
Thank you so much for your time. Looking forward to work with you.