Oct 09, 2020 12:01 PM
Hello, Community!
I am a newbie and am trying to figure out how to use Airtable for a sports team. My goal is to track attendance per week throughout the season. I’ve grasped that I should have a master table - the roster - and pull in data from linked tables - the daily attendance. I am stumped on how to set up the days/weeks/months in some sort of calendar or a list. If I need 6 days each week for 3 months and I need to know which athletes attended which days, how do I set that up? One table per month and list the dates? One table with every date? What’s the method of crediting an athlete for any of those days? How do I then pull all attendance data per athlete?
Thank you!
Oct 09, 2020 12:55 PM
There are a few different ways you could set this up, but I think the simplest that should work for your use-case is to have, as you say, a Roster table and a Practices table.
Next, create a field in your Practices table that is a “Link to another record”, and link it to the Roster table, allowing multiple linked records. This allows you to attach the record of a team member to the record of a practice date, and you can do so for each team member in attendance for each practice date.
You’ll be able to see the names of each team member from the Roster that you have linked to a Practice record. And in your Roster table, you’ll be able to see the date of each Practice a team member has attended.
{Month}
, and give it a formula something like this:MONTH({Name of You Date Field})
This will extract the month as a numeral from the date you entered for that practice session.
{Month}
field, select the “Only include linked records where…” filter and set it up Where Month = 10
, and finally, give it this aggregation formula:SUM(values)
This will sum up all instances where you have linked the current Team Member to a Practice Session that took place in the month of October.
There’s a lot more you can do to continue to expand on the functionality and information this setup can give you – this is just a basic start. I encourage you (and Airtable encourages you) to play around with formulas, rollups, record links, new field types, etc. to see what you can do to meet your needs and goals. Mistakes are easy to fix in Airtable, and exploration is quite rewarding.