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)
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:
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",
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
YOU MUST set up the Score the options from best (highest) to worst (lowerst score) or the status will not work correctly.
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.
Now, create a Performance Standard to colour the options that you have set up
Create the Performance Standard and save it
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 Sidebar will also be coloured appropriately as more injury records are entered based on their injury status
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.
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)
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
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