Skip to main content

Hi,


I would like to create a fitness tracker for our climbing team. I periodically test our athletes (ie, vertical jump, shoulder strength, etc).


I would like to track each athlete’s test scores/numbers, enter that information into airtable and have the ability to track each athlete’s improvement for each fitness test. One test is the vertical jump. I will need to test their standing reach and then standing jump. Ideally, I want to enter standing reach every so often (not every test) since the kids don’t grow that quickly. But I want to update standing jump every time we test.


How do I enter standing reach into airtable and be able to retrieve that for future tests? I would like future tests to record standing jump but then reference standing reach in order to calculate vertical jump (ie, standing jump less standing reach).


Thoughts?

Hi @James_Chi, if I were you I’d have two tables, one to contain the athletes and one to contain the score tracking


From there, I’d link each tracked score to the appropriate athlete record, and then use the rollups to get the latest tracked score of each type, resulting in something like this:





And here’s a base I set up that shows how to do the rollup thing


You can also hire me to just set it up for you too!

Athletes Table: Create a table to store information about each athlete, including their name, age, and any other relevant details.

Fitness Tests Table: Set up another table to define the different fitness tests you conduct, such as vertical jump, shoulder strength, etc. Include fields for the test name and any other relevant information.

Test Results Table: This table will track the test results for each athlete. Each record in this table will represent a single test session for a specific athlete. Include fields for athlete (linked to the Athletes table), test type (linked to the Fitness Tests table), standing reach, standing jump, and any other relevant data.

Formulas for Calculations: In the Test Results table, you can use formulas to calculate the vertical jump based on the standing reach and standing jump. For example, you can create a formula field called "Vertical Jump" that subtracts the standing reach from the standing jump.

 

Create a separate "Athletes" table in Airtable with each athlete’s latest standing reach recorded. Then, in your "Fitness Tests" table, link each test entry to the athlete and use a lookup field to pull their standing reach. You can then use a formula field to calculate vertical jump = Standing Jump - Standing Reach. Update standing reach in the "Athletes" table only when needed, and all future tests will automatically reference the latest value.

Reply


Terms & Conditions