Linking Fields- Linking data between Event Forms: Important information about Linked Fields and Linked Values

You can link fields from one Event Form into another Event Form. This can be important if you only want to a field once, but you need it to pull through into multiple Event Forms. For example, you track body weight in an anthropometry form and you want it to pull through to fitness tests or physiology tests. Having a linked field enables you to track the field in the anthropometry form and then pull through the most recent result into any forms that you need that result for.

You can link a field from one Event Form and have the field appear in a different Event Form. The image here shows the Linked Fields that are available on the Form Builder

You can link a field from one Event Form and have the field appear in a different Event Form. The image here shows the Linked Fields that are available on the Form Builder

You can link the following field types:

Value- a numeric field/calculation. e.g. link any numeric based field from one Event Form into another form.

Options- Pull through an option from one Event Form into another one. N.B. You MUST have an exact copy of the options from the field you are linking from and use these in the Linked Option field you are linking to.

Text- Pull through text based information from one Event Form into another.

Click on the "Linked Value" field  in the Add Question section of the builder. Name the Field. In this example we are pulling weight (from an anthropometry form) into a Strength Training Form

Click on the "Linked Value" field  in the Add Question section of the builder. Name the Field. In this example we are pulling weight (from an anthropometry form) into a Strength Training Form

#1: Add in the Linked Field type that you require. For this example we are linking weight (which is a numeric field) from the anthropometry Event Form. To link a numeric field you would choose a "Linked Value".

#2: Name the Field in the linked form.

-Even though it is named Weight in the anthropometry form, you will need to name the field in the form are linking to. You can name the field what ever you choose. The field does not have to be named the same as the field you are linking from.

#3: Next, click on the Calculation Link in the Form Builder and choose which Event Form and field you want to link from (as shown in the image in the step below).

In the Calculation section of the Linked Field you need to select the Event Form (shown here) and Field (shown in the following step) that you are linking from

In the Calculation section of the Linked Field you need to select the Event Form (shown here) and Field (shown in the following step) that you are linking from

#1: Click on the Calculation link

#2: Click on the Event Form drop down

#3: Select the Event Form you want to link the field from

Now select the Field you want to link to from that Event Form. For this example we are selecting Weight

Now select the Field you want to link to from that Event Form. For this example we are selecting Weight

You can see that all of the Fields from the selected Event Form that are numeric will be displayed. Choose the field that you want to link from.

Group By and Match To are only needed when you have fields that are grouped using the Group By property. Most fields do not have this enabled so leave these settings blank

Group By and Match To are only needed when you have fields that are grouped using the Group By property. Most fields do not have this enabled so leave these settings blank

If you want to see an example of using the "Group By" for Linked Fields see the lesson on "Tables and Linked Values: Building a Strength Training Form that links 1RM from a separate 1RM Event Form"

Select Value is used to select additional information about the field you are pulling through. You can choose to pull through the newest, oldest, maximum, minimum, and state (if

Select Value is used to select additional information about the field you are pulling through. You can choose to pull through the newest, oldest, maximum, minimum, and state (if

For most forms you will only want to pull through the Newest Value. For our weight example, this means that the most recent weight entered into the Anthropometry form will pull through into the Strength and Conditioning Form.

The Select Value Options are as follows

Newest: pulls through the most recently entered value in the form you are linking from.

Maximum: will pull through the maximum value ever entered for that field.

Minimum: will pull through the minimum value ever entered for that field.

Oldest: will pull through the first entry ever entered for that field.

Current State: will pull through the field based on the state (status field) of the athlete. This is ONLY for use for injury status fields.

Current Poor State: will pull through fields based on the poorest state (e.g. injured unavailable, not fully available). Again, this is only for use with injury status fields. See the lesson on creating an "Linking using State: an example of an Availability Event Form"

You MUST set up the Manual Update in the Advanced Properties for the Linked Value

You MUST set up the Manual Update in the Advanced Properties for the Linked Value

Manual Update

Manual Update =True means a link to the Event Form you are linking from will appear at the top of the Event Form. The linked field will automatically pull through, but you may want to update it by clicking on the link at the top of the form and entering in new data for the Field you are linking from.

Please note that for each field in the Event Form that is a Linked Field (option, text or vale) a separate link will appear at the top of the Event Form (as shown in the image in the step below). If there are 20 linked Fields in the Form and they are all set to Manual Update =True, then 20 links will appear at the top of the Event Form regardless if they all link from the same Event Form !!!

Manual Update = False means the most recent results (or the worst, or minimum depending on how you set up your calculation) will be pulled through into the linked form and no link to enter in a new entry will appear at the top of the Event Form.

If the Linked Field is set as Manual Update "True" then a link will appear at the top of the Event you are linking to. You can click on these links to update the field you are linking from. E.g click to update the weight field in the Anthropometry Event Form

If the Linked Field is set as Manual Update "True" then a link will appear at the top of the Event you are linking to. You can click on these links to update the field you are linking from. E.g click to update the weight field in the Anthropometry Event Form

Most users disable the manual update=True if they are entering in fields that  they do not need to updated  from the linked form. If you have too many linked fields set as Manual Update =True they will clutter the page.  

It is important for forms like strength and conditioning forms when you need to update 1RM.

Then set up the Linked Range. If you leave it blank it will pull through the most recent results. If you set the Range it will pull through according to your requirements

Then set up the Linked Range. If you leave it blank it will pull through the most recent results. If you set the Range it will pull through according to your requirements

Linked Update Range. This is complex, so read carefully!!!!

For this example; think about entering in a new strength and conditioning form on the 3rd of August.

-Blank: The most recent variable that is entered on the system that matches the date of entry will be pulled through.

-Start of previous day: only variables that are entered before the start of the previous day will be pulled through. E.g. using the example of entering in a new S and C session on the 3rd August, only anthropometry weight entered before 00:00:01 on the 2nd of August (start of the previous day) will be pulled through.  Weight from the 1st of August or any time before that would be pulled through. Weight from the 2nd onwards wouldn't.

-End of previous day: only variables that are entered before the end of the previous day will be pulled through. E.g. using the example of entering in a new S and C session on the 3rd August, only anthropometry weight entered before 23:59:59 on the 2nd of August (end of the previous day) will be pulled through.  Weight from the 2nd of August or any time before that would be pulled through. Weight from the 3rd onwards wouldn't.

-Start of current day: only variables that are entered before the start of the current day will be pulled through. E.g. using the example of entering in a new S and C session on the 3rd August, only anthropometry weight entered before 00:00:01 on the 3rd of August (start of the current day)  will be pulled through.  Weight from the 2nd of August or any time before that would be pulled through. Weight from the 3rd onwards wouldn't.

-End of current day: only variables that are entered before the end of the current day will be pulled through. E.g. using the example of entering in a new S and C session on the 3rd August, any anthropometry weight entered before 23:59:59 on the 3rd of August (start of the current day)  will be pulled through.  Weight from the 3rd  of August or any time before that would be pulled through.

If the following data was entered for the Anthropometry Event Form for the athlete.

If the following data was entered for the Anthropometry Event Form for the athlete.

SP: The record for the 1st August will be pulled through into the Start of the Previous Update Range

EP and SC: The record for the 2nd August will be pulled through into the End of the Previous and the Start of the Current Update Range

EC: The record for the 3rd August will be pulled through into the End of the Current Update Range

Setting the Update Range is important because it directly affects the range of the data that is pulled through into the Linked field

Setting the Update Range is important because it directly affects the range of the data that is pulled through into the Linked field

Based on the date examples outlined in the two steps above, the image here shows you which data is pulled through based on the Update range set for each field. To help clarify which anthropometry records are pulled through based on which Update Range, we set up Linked Text Fields that had the same Update Range to pull through the date field from each anthropometry Event Form.

Now set up the usual Advanced Properties such as format (e.g. 0.00,) higher or lower is better, default show in tables etc and save the Event Form

 Now set up the usual Advanced Properties such as format (e.g. 0.00,) higher or lower is better, default show in tables etc and save the Event Form

Test the Event Form out on the system by entering in a New record that you are linking from. Then enter in a new record for the Event you are linking to

Check:

1. That the Update Range is correct

2. That you have set up the Manual Update correctly based on your requirements

3. That you have set up best values, number formats etc for the linked variables

0 Comments

Add your comment

E-Mail me when someone replies to this comment