I’m trying to set up a form for our baseball league to collect scores from games so we can then do additional data manipulation to calculate win/loss records, calculate total runs for and against etc. The first single select field that I’ve created is to capture the team’s age group. Based on that choice I then want to have a drop down that only shows the teams that are in that particular age group. We’re tracking information on 100+ teams, and I’d like to do this in a single form so we can give our volunteers a one place to go to do their entry regardless of the age of the team. I’m trying to figure out how to populate the second single select to remove the possibility of our volunteers entering a name manually and spelling it differently than we’re expecting or calling the team something different than how we have them in our records. (Think Cards instead of Cardinals)?
As an example we could have:
Cardinals, Rockies, Giants, Mets, Dodgers
Cubs, White Sox, Giants, Mets, Angels, Marlins
Cardinals, Cubs, Red Sox, Mariners, Royals, Brewers
I’ve also thought about making multiple grids, one for each age group, but I haven’t been able to figure out if there is a way for the form to write to a specific grid based on the selection of age group.
Any help is greatly appreciated. Thanks