Thursday, March 19, 2020

Google Script Editor for event registration

Here is a sample google script editor program for those who look for google script to arrange the input data from google form automatically based on age group and divisions

This script will be helpful for those who use google form for kids events / school programs

Age group and Division Count can be customised in script variables

Script Code : https://github.com/godlytalias/My-Codes/blob/master/eventreg.gs

Sample Form : https://docs.google.com/forms/d/e/1FAIpQLSdFIZS81Pw4FnCtKunl3mjf5sdXCcwSGpjZwwQ-3KU7WZk4hg/viewform

Sample Response Sheet : https://docs.google.com/spreadsheets/d/1MPGWrlknvDmi-tIP9O_rpfTnwy9fgBCa85lNXripEFk/edit?usp=sharing

Pre-Requisite:
Form need to have 'Name' and 'Age' field
Response excel need to have a sheet named 'editedresponse' to get the manipulated data stored


You can enter the input in the above google form and see the responses getting added into the response sheet in 'editedresponse'.

No comments:

Post a Comment