Feb 10, 2020 09:36 AM
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:
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?
Feb 10, 2020 08:16 PM
I think it would work to have a Participant table and a Week Entry table (whatever you want to call them)
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} |
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.
Feb 12, 2020 02:00 PM
Thank you! I think that worked! You’ve saved me a lot of aggravation.