Google Script - Form to Email Part 1: Establishing Email
I've been working with our counselors to create an online request form that replaces the "pink slips" currently in use by students. We are hoping this solution increases efficiencies at several levels (i.e. students can put in the appointment request at any time including at home, pink slips are not lost, etc). There were two pieces in this. The first is setting the counselor's email, while the second is to create and send the email. Part 1. Establishing Email One piece in creating this and putting it into place was having the counselors' names on the form, then using a script to add the counselor's email into another column. Here is the script to put into the Script Editor - function setEmail() { var sheet = SpreadsheetApp.getActiveSheet(); var startRow = 2; // First row of data to process var numRows = sheet.getLastRow(); // Number of rows to process var numColumns = sheet.getLastColumn(); //Number o...