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'.
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'.
