Print

Print


you could also look at some of Andrew Stillman's scripts...sheetspider in
particular
https://sites.google.com/site/heroscripts/course-feedback/sheetspider



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:
>
>> Greetings!
>>
>> 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
>>
>> --
>> Drew Blanchard, MAT
>> Technology Integration Specialist
>> Winooski City Schools
>> 70 Normand Street
>> Winooski, VT 05404
>> (802) 383-6073
>>
>