I feel like I am stuck in an episode of The Twilight Zone episode. It’s an episode where things that have been there start disappearing with no explanation. Let me explain.
I have never been one to wait until something went away to find a “Plan B.” Not only will I need a way to be notified when people complete my form, but I have friends who use a Google Form as a replacement for the paper discipline referral form. The teacher clicks a link and completes an on-screen form. The referral populates the next blank line on the principal’s spreadsheet. The principal receives an instant notification email that a referral has been submitted. Those people are going to need a “Plan B.”
My Introduction to Scripts
A Google search brought me to this post. You will see a black rectangle about half-way down the page. Highlight and copy the contents of that box. Just above it is a simple set of instructions.
I created a discipline referral form and used that script. It worked like a charm. When I entered sample discipline into the form, I received an email immediately. What I got was actually better than the old notification rules. This email gave me the name of the student, the name of the teacher, the teacher’s comments, and anything else that had been entered.into the form.
More Curious About Scripts
What I learned from my last experiment was that I didn’t actually have to know how to write scripts, I just needed to know how to find ones other people had written. I found some other videos that talked about the “Scripts Gallery,” and through I would create a form or two with something from that gallery.
Guess what? It’s no longer there…The Twilight Zone, scene 3.
For the last couple of days, I have been working with the spreadsheets associated with Google Forms a lot. Working with the scripts has caused me to look at menu items more closely than ever before.
Suddenly, yesterday (Tuesday) afternoon, I saw something I had never seen before…something that had not been there even earlier the same day…a menu item called “Add-ons,” the fourth, and final scene from The Twilight Zone.
Here is a video which talks about “Add-ons”:
Is this why the notification rules went away? Is this why there is no longer script gallery? Is this the replacement? In just the limited amount of time I have explored the add-ons, I would say the answer is “yes.”
View the video, and explore the add-ons. I am hoping it will be a treasure trove of great functions. Time will tell.
Have you already founds the add-ons? What thoughts do you have?
Leave a Comment