I need to run a joint competition with a neighbouring region. We want to have the flights combined so the kids all compete together, but need to generate separate results for each region. Can this be done?
Yes – when you create the competition, be sure to check the ‘Separate results per region/state’ box. Make sure the region is set on your entry form. There are two ways to do this. (a) Put the word ‘multiregion’ in cell C1, then the region for all entrants on that form is read from cell G9 (which is normally used for team colours – so you can set this in the Clubs sheet). Or (b) Put the region in column S for every entrant on the form.
Take a look at the USAG entry from sample to see how it is done there.