Registration Results (DEMO)

Form Responses 1: This sheet shows raw data collected from the Parent/Guardian and Volunteer Registration Form.

Form Responses 2: This sheet shows raw data collected from the Child Registration Form. Emails registered to children with no Parent/Guardian information will be highlighted in [RED].

Registration Summary: This sheet shows an example summary data table that checks if a registered Adult is a Volunteer (Yes), is a Parent(Yes), and displays a count of any registered Children (2).

Settings: This sheet shows an example set of column mappings for a custom Google Apps Script. The app shown here creates new Contacts for each parent or volunteer that registers, and adds them to Contact Groups based on their form answers. This sheet tells the app which of your Form columns contains the user's Email address, first and last name, and any other important information. It's connected to the Registration Summary. We'll handle the initial set-up for this, but we include it in your spreadsheet so that if you decide to change the questions in your form later on, this will make it easier for you to keep everything connected to the custom app (no coding needed on your part!).

Group Map: This sheet tells the custom app which Contact Groups to place your Contacts into. In the example, all registrants will be added to the "VBS 2024" Contact Group. Parents (registrants with children) will be added to the "Parents" Group. Volunteers will be added to the "Volunteers" Group. For example: Jennifer Smith is a Parent who registered two children, and she also signed up to be a Volunteer. So, she will be added to all three of the Contact Groups [VBS 2024], [Parents], and [Volunteers]. Lily Booker, who did not yet register as a Parent or Volunteer, will be added to the Contact Group [VBS 2024] only. Later, if she registers as a Parent or Volunteer, she'll be added to the appropriate group(s).