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
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
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