The 20m sprint form (shown in the image in the step above) is linking to the Back Squat and Bench Press data in the Strength Testing Form. Unfortunately, these measures were performed on separate days and the Bench Press has no data for the record for the 22-01-2013. This affects the link into the 20m sprint form and pulls through blank data.

Now there is an Advanced Fields setting that enables you to ignore the blank record and to search for the next most recent data (e.g. the record on the 18-01-2013).

For the linked field in the Advanced Property on the Builder you can now:

Set the "Ignore Blank Values" to Yes to set the system to ignore blank values to search for the next most recent value (for the field and date period you have selected)

Set the "Ignore Blank Vlues to No (this is the default setting) to enable blank values to be pulled through (an example for setting this to No is outlined in subsequent steps).

For the example here all 3 Fitness Testing linked records (yoyo, squat and bench) have been set to Ignore Blank Values = Yes.

This is the same record that appears in the image in the first Step. This time you can see that the Bench Press field ignores the blank record and pulls through the next record.

The image in the example here shows that fields that text fields that are linked from the form Running Time Trial are not showing any data because the comments field was not entered when the record on the 21 Jan 2013 was entered. You could specify to ignore the blank field and pull through the data from the record entered on the 19-Jan 2013. However, because we are viewing the time, and effort information from the 21st, you would also want to see any relevant comments from that specific test. For this example you would not set up the "ignore blank record".