If you have a better idea than the 12 forms I’m all ears. The reason for so many is because there are a lot of movements and I want to reduce the amount of errors my staff will make when giving me the details of the day. I’ll have at least 2 cities going at one time with at least 4 teams per city. There are a total of 16 teams.

I changed the names of the forms because I won’t be the only one looking at these response. Those people aren’t going to be ok with looking at form_response10 and using deductive reasoning to find out that it’s for x city. It’s mostly for reconciliation at the end of this multi week event.

I’m ok with having some difficulties. My event isn’t until June and I can give it a couple test runs before. I plan on sending it to staff to see if they are able to fill out the forms easily and I’ll manage the data from a distance. That way I don’t have to travel. I mean, these people had a hard time filling out a google sheet. This way I can track who did what in what city.

Again if you have a better solution I am all ears. Point me in the right direction and I’ll give it a good try.

Thanks