System Development, Software Updates, Quick Guides and Builder Training InformationBuilder Site Help Documentation Turning a field into a Table or MatrixTables and Linked Values: Building a Strength Training Form that links 1RM from a separate 1RM Event Form

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

Tables and Linked Values: A more complex strength training form can be created that links to a separate form for 1RM

The Image in the step here shows you a Strength Training Form that links to a separate form that tracks 1RM for each exericse in the strength training database.  

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

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

- The Exercise field is linked to the Exercise database

- Weight and Reps fields are numbers

- The 1RM calculation field is set up using the following equation:  (100*Weight)/(101.3-(2.7123*Reps))

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)

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)

The database that you link to needs to be the same database that you select in the estimated 1RM form.

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.

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

If you have set it up correctly, when you enter in a new strength training session on the application, the 1RM will pull through from the linked record, and the estimated 1RM will match for each type of data.

If you have set it up correctly, when you enter in a new strength training session on the application, the 1RM will pull through from the linked record, and the estimated 1RM will match for each type of data.

When you enter in a new resistance training session, you will also see that a link appears at the top of the page to update or add in new resistance training 1RM's.

If you need help creating different types of tables, then please post question here.

0 Comments

Add your comment

E-Mail me when someone replies to this comment