I’ve been tasked with setting up a scoreboard of sorts for my local spinning group. The idea is to run a league over a number of weeks where each participant can log the distance they complete during each 45 minute class. We’ve done it with pen and paper in the past, but I thought it might be interesting to see if I could build this with WordPress.
I’m hoping to be able to build this with ACF, but I could do with a little advice on a few things and I’m not completely sure that I can actually build a scoreboard with ACF in the first place.
My thinking is that I would have a front-end form that each participant could complete at the end of class with their name, date of the class, male or female, the decade they were born (we award extra points based on what decade someone was born in or their gender) and the distance completed. These submitted posts would then be displayed in a table and grouped by weeks and we’d be able to see an archive of weekly scoreboards to see how we’ve improved.
The first big question, is it possible to make calculations on fields? Example, a participant selects a field that tells us they were born in the 70s so we award them an extra 4km to the 20km they filled out in a number field. The resulting number of 24km is then shown in the scoreboard.
My second big question, would it be possible to display the weekly entries so the highest distances are always at the top?
I’m also not entirely sure I’d be then able to display these tables by week, is that going to be possible? And it would be awesome if I could also feed the top three highest scores into one main leader board.
Any advice on better ways to approach this are also welcome.
Many thanks.
