Step 3: Customize the Script
Step 3 will show you how to customize and personalize the script for you and your school.
A. You should still be in the Script Editor. Look for the following code in the script:
This part of the code is what will send an automatic email to the person who submits a form response. You can edit the text inside the parenthesis to customize the email. The email will be sent on behalf of the owner of the spreadsheet.
The first line, "Help Desk Ticket #" will be the subject of the email.
The \n\n are actually line breaks and will move the text after it to the next line in the email.
The {name:"Automated Help Desk"} will be on the "From" line of the email.
B. Look for this piece of code in the script:
This part of the code will send a Status Update email to the person after you update the spreadsheet. It will include information from the Notes, Status, and Resolution cells.
You can edit the text inside the parenthesis to customize the email. This email will be sent on behalf of the owner of the spreadsheet.
** DO NOT change the ("What is your email address?"), ("Notes"), ("Status"), and ("Resolution") code.
These are actually the cells in your spreadsheet.**
Look for the subject and body portions of the code to edit the text.
The last line with {name:"Automated Help Desk"} will be on the "From" line of the email.
C. Save your script when you are finished and close the tab.
Now that you're done editing the script, let's move on to step 4.