Setting up a Status Indicator to colour the athletes according to injury/illness status. For Advanced Builders ONLY

When you enter data for an athlete you may need to know whether the athlete is available or injured depending on an injury or illness status. The following provides you with guidelines on how to set up status indicators (e.g injured, available etc) for your athletes. This can be quite hard to set up, and most of the time will already be set up by your Distributor.

Most status fields are set up using an option calculation field that calculates injury/illness states from an injury SOAP table or from return to play/training dates.

Please remember: when you set up your options or the options in an option calculation for status, you MUST always set the options in order from best to worst. Your sidebar and athlete colouring will not work if you set it up from worst to best. Additionally, any linked values from an injury form that are set to appear by poor state will not work correctly.

Set up the field that will be the status field in your form. Depending on how your injury/illness form is developed up you can use a use either a single selection field (shown here), a calculation field (using return to play dates), or a table calculation (from injury status within a table)

Set up the field that will be the status field in your form. Depending on how your injury/illness form is developed up you can use a use either a single selection field (shown here), a calculation field (using return to play dates), or a table calculation (from injury status within a table)

The example here shows an injury status field that is a simple single selection field that is updated over time.

The example here shows an Option calculation field that will calculate status based on return to play dates that are entered into the system

The example here shows an Option calculation field that will calculate status based on return to play dates that are entered into the system

The availability field (field that sets the status for the athlete) in this example is an option calculation field that calculates out the availability based on date of first symptoms, if the athlete is unfit to train and the date of return to play.

The options are:

Available

Injured-Available

Injured-Unavailable

The equation is:

if(isempty (Date Fully Resolved), if(Is the athlete unfit to compete/train="Yes", if (isempty (Date of Return to Training/ Competition),"Injured-Unavailable",

"Injured-Available"), "Injured-Available"),

"Available")

Other fields use a table option calculation where the injury status is updated daily in a SOAP table and a table calculation calculates the current injury status

Other fields use a table option calculation where the injury status is updated daily in a SOAP table and a table calculation calculates the current injury status

Never set the status field for the injury status question in the actually table because it will just take the first entry from the table, and NOT the most recent. You will need to set up a separate field (e.g. a Table Option calculation) to return the last entered option in the Injury Status Table Column.

To set up your injury status options in an option calculation field check your options are correct

To set up your injury status options in an option calculation field check your options are correct

For this example we are going to use the availability field as the status field. Ensure your options are correct and then set up their scores (shown in the step below). Again remember to set them up from best status to worst status.

YOU MUST set up the Score the options from best (highest) to worst (lowerst score) or the status will not work correctly.

YOU MUST set up the Score the options from best (highest) to worst (lowerst score) or the status will not work correctly.

The scoring need to be set up and can be set for the options in the option calculation field (as well as the table calculation or just a single selection field). The best available option needs to be set a the highest value and the worst option is set to a score of 1. Then click Update.

Now, set up the field's Advanced Properties as "Status Indicator" Yes

Now, set up the field's Advanced Properties as "Status Indicator"  Yes

Now you MUST set the status indicator field as Yes.

Please Note that you can ONLY have one field in your entire application as a status indicator. The only time another field can be set to a status indicator is if it uses EXACTLY the same options, calculations and scoring (e.g. if you have a separate injury or illness record). If you set different fields with different options as status indicators, the system will not be able to recognise which is correct and will NOT update the athlete's injury/illness status correctly.

Save the form changes

Save the form changes

Now, create a Performance Standard to colour the options that you have set up

Now, create a Performance Standard to colour the options that you have set up

In the Performance standards section, create a new Performance Standard to colour the injury status field correctly.

Create the Performance Standard and save it

Create the Performance Standard and save it

The colours that you set for each option will then be displayed for that athlete depending on their availability.

Save the performance standard.

Now go to the application and enter in a new injury/illness for an athlete

Now go to the application and enter in a new injury/illness for an athlete

This form's advanced properties have been set to autocolour (so the Performance Standard shows when you are entering in the actual data into the Event Form). See the lesson on Advanced Form Properties- autocolour.

Enter the injury/illness record and check that the status is being updated correctly based on the work flow you have for your injury status calculation.

The colour of the athlete will be updated depending on the selection made for that field when you go to enter in new data for them

The colour of the athlete will be updated depending on the selection made for that field when you go to enter in new data for them

The actual entry is coloured based on the field that you set as a status field, and the colour that appears for the different status now shows for the entry and for the athlete (as shown below)

The enter data for athlete should now be coloured according to their injury status as well

The enter data for athlete should now be coloured according to their injury status as well

The Sidebar will also be coloured appropriately as more injury records are entered based on their injury status

The Sidebar will also be coloured appropriately as more injury records are entered based on their injury status

You can see the athlete is coloured yellow (injury available) based on the worst injury.

If the worst injury is not the most recent, the status field will still show as the worst injury (as shown here)

If the worst injury is not the most recent, the status field will still show as the worst injury (as shown here)

Injury Status for Two Event Forms. If you do have a separate Injury and Illness form and you need both of them to have a status indicator, you need to ensure that the fields and options that calculate injury/illness status are identical in BOTH forms.

Injury Status for Two Event Forms. If you do have a separate Injury and Illness form and you need both of them to have a status indicator, you need to ensure that the fields and options that calculate injury/illness status are identical in BOTH forms.

The field names need to be exactly the same, e.g. injury/illness duration

The availability options need to be the same (as shown in the image in the step below) e.g. inj/ill unavailable (you cannot have injured-unavailable in the injury form, and ill-unavailable in the illness form. They both need to be inj/ill-unavailable with the same scoring.

If the fields are set up correctly, they will colour according to the worst injury OR illness that is entered for the athlete (as shown here)

If the fields are set up correctly, they will colour according to the worst injury OR illness that is entered for the athlete (as shown here)

The athlete is coloured Red because they are marked as unavailable for their injury record and their illness status is not as severe.

N.B. The Event Name will NOT colour in the sidebar unless you also set one field from that form to appear as a Summary Field

N.B. The Event Name will NOT colour in the sidebar unless you also set one field from that form to appear as a Summary Field

The Event Form Name will NOT colour correctly unless one of the fields from the Form (e.g. Injury Diagnosis or Injury/Illness Duration) is selected to appear as a Summary field.

If you only have the event date appearing in the sidebar the Event Form Name will not appear correctly.

If you have accidentally set up other fields on your system as status fields and your status is not updating correctly, click on the "Application Specification" on the Builder Site

If you have accidentally set up other fields on your system as status fields and your status is not updating correctly, click on the "Application Specification" on the Builder Site

The entire site specification (Event Forms, Profile Forms, Databases etc.) will appear as a PDF. At the very BOTTOM of that specification, a list of any Forms that have Status Fields in them will be shown

You can see here that two fields have been set up as Status Fields. The status field from the Injury Record (SOAP) and the status from the Injury Record testing second status

If you have any errors in your status indicator check the following

If you have any errors in your status indicator field:

1: Check the options

2: Check that the calculations reference the correct options

3. Check that the options list is from best to worst

4. Double check the scoring of the options

5: Check you are NOT referencing the status from a field within the table, it needs to be a separate table calculation

6: Make sure no other fields in the system are set as status codes (unless you have a separate injury and illness form and they both have exactly the same options and option calculations).

7. Make sure at least 1 field from the form is set as a Summary field to appear in the sidebar

0 Comments

Add your comment

E-Mail me when someone replies to this comment