16 week run/bike challenge leaderboard

[Stacey_Shea]

Looking for help on the best way to set this up:

My company is running a 16-week run/bike challenge and we are using airtable to track everybody’s totals. This is the information we’re going to track:

• Participant Name
• Office Location
• Run Distance (by week)
• Run Time (by week)
• Bike Distance (by week)
• Bike Time (by week)
• Total Run/Bike Distance (by week)
• Total Run/Bike Time (by week)
• Overall Run/Bike Distance (running total of each week)
• Overall Run/Bike Time(running total of each week)

The eventual views we want participants to see is a weekly leaderboard (grouped by Week 1, Week 2, etc.) and an overall leaderboard (showing the running totals).

So, what’s the best way to organize this so that i can track the weekly data and then feed that into the overall running totals?

[Julie_Sheffield]

I think it would work to have a Participant table and a Week Entry table (whatever you want to call them)

Week Entry

Field	Type
Participant	Link to Participant table
Run Distance	Number
Run Time	Duration
Bike Distance	Number
Bike Time	Duration
Total Run/Bike Distance	Formula: {Run Distance} + {Bike Distance}
Total Run/Bike Time	Formula: {Run Time} + {Bike Time}

Participant

Field	Type
Name	Text
Office Location	multiple choice
Overall Run/Bike Distance	Rollup of Run/Bike Distance from Week Entry table
Overall Run/Bike Time	Rollup of Run/Bike Time from Week Entry table

Then you can just have different views grouped by week on the Week Entry table and sorted by either total Distance or Time. The Participant table can be sorted by Time. Z-A in all cases. You could even get creative with formulas and add Average Running Pace, etc.

[Stacey_Shea]

Thank you! I think that worked! You’ve saved me a lot of aggravation.