This question is more for those who use Google Spreadsheet as data source for Appsheet Apps and who also do some Google App Script
So it’s a tricky one.
(I also left a question in the Google Sheets Community, but thought to give it a go here as well)
So whenever I start a New Project, I have to do a bunch of things that I wish to have them happen all at once by just Adding a New Project in Appsheet (what a dream).
- I have to Copy, Paste and Rename a Google Drive “Client Template” Folder, from a “Tamplates” folder to a “Clients” folder, where all the current Clients Folders are kept.
- I also have to add the New Project in Appsheet
- I also have a row to link the new folder to appsheet and have that folder available from an action button in the Deck View of Projects in Appsheet.
There a few more steps, but solving these two, I can definitely solve the others.
So there are two possible ways about this
either have it so that when I make a new folder, the spreadsheet makes itself a new row and collects some data from that new folder (which i think is less likely to be possible)
either when I add a new Row to a spreadsheet, through some google script, the spreadsheet will copy the “Client Template” Folder, Paste it into the “Clients” Folder, and rename it to the value of the Cell in the Column A of the New Row that has just been added in the Spreadsheet via Appsheet (wouldn’t that be … a m a z i n g)
My main hopes are on the second version, because I can imagine that there must be an OnEdit Script in the Spreadsheet.
(if it is the first version, then the spreadsheet has to have a TimeDriven Script that would have to search every minute so it wouldn’t be instant and how would it search for changes in names of the folder … problems just keep adding up)
It can’t be done through Zapier - it can create new folder, but I need to copy, paste and rename a Template folder that contains other folders inside it!
But the fact that that option is available, makes it clear to me that this is now, a possible dream to try and achieve.
I’m sure this can be done, I’m just too much of a rookie in google script (I mean,I’ve done some things by copying bits and peaces and putting them together, but it took me two very stressful hours to realize that in a If statement in script, you have to put two equal signs instead of just one to make things work … that rookie).
So if anybody has any ideas, whether you actually have done just this, or know where to get some education on Google Script creation/organizing of Google Drive Folders from spreadsheets, or maybe a different forum/community where to ask the question … I would be truly grateful.
Of course, if I get to the bottom of this, I will leave here all the details because I can imagine how others must have tried something similar out because this Many Separate Client Template Folders is not such a unique scenario, and the need to make it easy to rename and organize information made in each folder must be a common request
Thank you and can’t wait to see this happen,