Cloud scorekeeping system

[CestM0i]

Hey guys,

I’m looking for ideas to support keeping scores for a sports competition. I want to be able to have a digital point of access for a scorekeeper/timekeeper/judge to enter scores for their event, have those scores correlate with a participant ID and ideally arrive in a central spreadsheet.

Looking at a couple of hundred participants and 5 sports to score.

scores need to be easily collatable in a short period of time for awarding prizes which is why I want a digital solution.

 

My initial thoughts are a Microsoft form with branching logic so that scorekeepers only need to see the event they are scoring from, input the participant ID and score and then using power automate to update spreadsheet rows by using the participant ID as a key reference.

The more I pseudo code it in my head and play around with power automate the more fraught with problems this seems to be (from actually getting it to reference a row and then the potential for a response to the form overwriting the wrong data).

 

Scorekeepers will all be smartphone and web familiar but scrolling around a shared spreadsheet on a small screen is a nightmare and I think also has its own potential for incorrect data entry while panning around the table, so although that would be the simple solution I’m not convinced it’s the the best.

 

In an ideal world if I could print each participant an individual QR code that links to a data entry page that would be very shiny, but a system somewhere in the middle ground of this would be great.

 

Appreciate any thoughts you have or pointers to an affordable application/site (for a one off (maybe annual if it goes well) event) that will get me to this goal appreciated.