Tables and Linked Values: Building a Strength Training Form that links 1RM from a separate 1RM Event Form
To set this up, the strength form and the 1RM form both need to be linked to the same database and be in a table format. The Database field also needs to be marked as "group by".
Tables and Linked Values: A more complex strength training form can be created that links to a separate form for 1RM
First create the 1RM form that calculates an estimated 1RM from Weight and Reps. The Exercise field needs to be linked to the SAME database as the resistance training form and is selected as a "Group by".
Create the resistance training form to include the fields that you want to track. You MUST have the Exercise field as a database and tick the "group by" (shown in the image here)
Now pull in the a 1RM date into the Resistance Form from the Estimated 1RM Form, by adding in a "linked number" field and set it up to link to the Estimated 1RM field, and group by Exercise to Exercise so that the correct 1RM shows for the correct estimated 1RM.
Set up the Weight column so that it calculates 1RM (linked number) * % 1RM
Add in the other fields you require:
Load are set as calculations from reps * sets* weight
Session Load is a Table Calculation that aggregates the sum of the "Load"
Intensity could be set as Table calculation to calculate maximum % 1RM
Save the changes