Print

Print


I happened upon this today, which seems relevant to this thread.
http://youpd.org/content/system-tracking-after-school-tutoring


On Tue, Dec 10, 2013 at 8:22 PM, Elizabeth McCarthy <
[log in to unmask]> wrote:

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


-- 
Charlie MacFadyen
Technology Integration Specialist
Champlain Valley Union HS
Hinesburg, VT
(802) 482-7117