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?
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.