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