I am looking for a script that will allow me to share lesson plans easily using google docs.
I have a document - [login to view URL]
It is inside a folder called "lesson plans". I want this to be the template then once I Fill it out I press a button and where it says "BREAK" it will split the document and match the lesson E.G If I had yr7maths1 inside 2 of the tables those 2 lesson plans would end up inside a folder called "yr7maths1" and the next week as long as I call the call class same name it will end up inside the same folder.
The idea being I will share my "lesson plan" folder with my line manager and she will be able to see all my lesson plans..... well thats the idea anyway.
The screenshows the manual folders I have created.
In the future I hope that other staff can use the template, click the same button and it will create folders for them but because it will create the folders inside the "Lesson Plans" folder everyone will be able to see the lesson plans.
Description of your task is not clear for me in some places. At the same time i think that this routine has a solution in the script... but on Google Docs only if your source template file must be realized as spreadsheet (because it potentially have ability to be parsed by program). With this condition I am ready.