Google Scripts - Adding a Template Table to the Top of a Meeting Agenda On Demand
That seems like a weird title for this post, but I was trying to be as descriptive as possible - though the script will work for other uses as well with some easy modifications. I was posed the following problem by a person at one of our local districts: "Looking for a way for teachers on a [district] Team to be able to click on a link so that this blank template shows up above their prior week's entries. Does this make sense?" As I have not done much with using scripts in documents, I was eager to try this. Surprisingly, I was able to craft this one in less than 24 hours! And now, I see a myriad of ways that it could be used in other situations. What this script does : When opening the document, an additional menu is added (1). When the user selects to "Add a Table" from the menu, it adds an additional template table (2) below the top level document table, but above everything else. It also adds a horizontal rule between...