Google Forms Script Help
August 11, 2014 4:27 AM Subscribe
I work at a school, and I'm trying to create a Google form to help get information out to parents. We have MULTIPLE means of doing that, though, and the problem is that EACH of the communication modes is handled by someone different. For example, one person is in charge of the website, another is in charge of the electronic sign out front, while another takes care of making afternoon announcements. I've created a form that allows teachers to 1. Type the verbiage they'd like to share, and 2. choose from a list of available media (website, sign, etc.).
I'm not smart enough to do the next step. Ideally, I'd like Google Docs to automatically send an e-mail to the appropriate person with the verbiage from each submission.
posted by richmondparker to Technology (7 answers total) 2 users marked this as a favorite
So, if someone creates a message and then checks that they'd like it to be on the website AND the afternoon announcements, I'd like for the webmaster and the afternoon announcer to get an e-mail with the text to be included when the form is submitted (JUST them, though, - - the sign person doesn't need to get copied since they don't need to do anything).
My Googling tells me that it should possible to write a script to handle this, but I'm not smart enough to take the examples I've found online and change them to turn them into something that works. Any INCREDIBLY patient mefites out there who would be willing to teach a teacher?