Linked Fields: setting the system to ignore blank records and pull through a previous record

You may have set up linked fields and the field that is pulling though on the system from the most recent entry has not data entered for it.This means it will display as blank. You can now specify to ignore blank records and pull through the most recent record that is not blank. Some users may need this if they want the most recent record. Other users may need to see that a field in a record is blank, so use it to meet you exact work flows.

The image in the step here shows that the most recent record is blank for the data for the linked Bench Press Field

The image in the step here shows that the most recent record is blank for the data for the linked Bench Press Field

When you view the athlete history for this data that is see that the squat and the bench were performed on different days. The most recent entry for Bench is actually Blank

When you view the athlete history for this data that is see that the squat and the bench were performed on different days. The most recent entry for Bench is actually Blank

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

Now there is an Advanced Field setting that enables you to ignore the blank record and search for the next most recent data. This is called "Ignore Blank Values"

Now there is an Advanced Field setting that enables you to ignore the blank record and search for the next most recent data. This is called "Ignore Blank Values"

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.

You can now see that the system pulls through the most recently entered values and ignores blank records (e.g. the Bench Press Record is showing)

You can now see that the system pulls through the most recently entered values and ignores blank records (e.g. the Bench Press Record is showing)

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.

You would not set the ignore blank fields setting when you are viewing multiple fields linked from the same form; as shown in the example here

You would not set the ignore blank fields setting when you are viewing multiple fields linked from the same form; as shown in the example here

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

For the example in the image above you could leave the system as it's default, or set the field to No. This will leave the value as blank so you do not a comment from a previous running test pulling through

For the example in the image above you could leave the system as it's default, or set the field to No. This will leave the value as blank so you do not a comment from a previous running test pulling through

0 Comments

Add your comment

E-Mail me when someone replies to this comment