you could also look at some of Andrew Stillman's scripts...sheetspider in particular

On Tue, Dec 10, 2013 at 8:14 PM, Sigurd Andersen <[log in to unmask]> wrote:
At St. J School we've just started using a form-based Help Desk Ticket.
It's based on a Google Apps script - the one Nick linked, I think.
Having written code in various languages in the past, it was fairly easy
to follow what the code was meant to do.
One thing that took me a bit to figure out was that the "On Open" event
is "automatically" included, but I had to add a trigger for "On Form Submit"
to get the code that sends off an email (to the submitter and to our IT group) to run.

Also, when recipients get an email, it's from the "owner" of the form.
The owner (which was me, initially) will only see the generated email in "sent" mail, not in their inbox.
 I never got the emails sent to our IT group, though the others in the group would.

We created a "Dumbledore" account that owns the form. That's the account
that responds to help requests (as seen by the users), and I now get
the help request emails in my inbox, since I'm no longer considered the sender.

Sigurd Andersen

On 12/10/2013 2:31 PM, Drew Blanchard wrote:

We have a Google Form, used by our tutors, to enter information about students' work and other relevant details when they provide extra help after school.  The spreadsheet side of the Form has been shared with the teachers, so they can see what their students have worked on - and also see comments/feedback from the tutors.  Many teachers have said they'd like to be automatically notified when information relevant to them has been entered via the Form.  Ideally, they'd like the text entered on the form to be included in this email (instead of a generic "information relevant to you has been entered on the tutoring Form").  This is out of my area of expertise.  Is there a way to accomplish this by creating a script of some sort?

Thanks, eh!


Drew Blanchard, MAT
Technology Integration Specialist
Winooski City Schools
70 Normand Street
Winooski, VT 05404
(802) 383-6073