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?
Drew Blanchard, MAT
Technology Integration Specialist
Winooski City Schools
70 Normand Street
Winooski, VT 05404