Using Google Forms to set up appointments with teachers? parents? staff? A common request is the wish for a confirmation email. Well, the wait is over! If you would like to have a confirmation email sent out to the people submitting their information to your form, this is the way to do it.
Step 1: Create a form (keep it open in one tab) Be sure you ask for their email address!
Step 2: Click on "View Responses" on the top of the Form (another tab opens, leave it open)
Step 3: Open another tab and go here https://sites.google.com/site/formemailer/, click on "Updates"
Step 4: Choose the top choice and download the attachments (the little piece of paper at the bottom of the post. See diagram for directions.
After you download it (pay attention where it goes)
Step 5: Right click and open with Notebook (it will look like crazy HTML)
Step 6: Select ALL text and copy it
Step 7: Go to your responses form, Tools > Script Editor
Step 8: Delete the script already there, then paste the script in the box
Step 9: Save the script (change the name) to FormEmailer
Step 10: Go to Resources > Current Project Triggers (this will tell the spreadsheet when to send the email)
Step 11: Look at the diagram for the settings.
Step 12: Save
Step 13: Go to Run > onInstall > Authorize
Step 14: Now go back to the Response Sheet > FormInstall (now on your toolbar) > Install > Install (a new sheet is inserted and a new column is on the left side)
Step 15: Go back to FormEmailer at the top > Settings
Step 16: To have the email go to someone else, change the Answers Placeholder to the cell with their email address in it
Step 17: Click "Insert placeholder" next to the "To" line.
Step 18: Take out any information you don't want included that is in the body.
Step 19: Save and Close
Now when this form is filled out by someone, they will receive an email. If you would like to have another person, like yourself, receive an email, too, we can set that up. This is a process for a confirmation email.
This post was inspired by the video tutorial down below from Jen Jonson.
Fifth grade teacher in a 1:1 iPad classroom, sharing my journey with technology in the classroom