Google Form Script Notification when a number of submissions has been reached
Description This google form script sends out a notification to designated email addresses and closes the form so no more responses are accepted when a certain number of submissions have been reached. You can define who gets the…
Read More »Google Form Notification: Sending a Report When a Duplicate Submission is Made
Google Form Notification: I would like to be notified when a duplicate submission is made to my form: This script checks to see if someone has submitted previously and sends a report to the specified email address if…
Read More »Google Apps Script Removing Commas
Google Apps Script Removing Commas Removing commas from form submissions can be tricky. Certain question types can save the responses in a 1,2,3,4 type format. If you find that you want to remove the commas for each submission…
Read More »Google Sheets Sort by Timestamp When Opening
Google Sheets Sort: You automatically want Google Sheets to sort by time stamp when you open it up. Sometimes when you are working in your Google Forms response sheet things can get out of order. If your lazy…
Read More »Google Forms App Script Email based on Selection
Description In this google forms app script example you can send an email based on a form drop down selection. Here the school is identified as the criteria for who receives the email. The list of schools and…
Read More »