System Development, Software Updates, Quick Guides and Builder Training InformationBuilder Site Help Documentation Calculations and Table CalculationsReturning the "option" in a Table Option Calculation that references a Table Option field with scores

Returning the "option" in a Table Option Calculation that references a Table Option field with scores

 

Previously, if you assigned scores to an option field being used in a table option calculation it returned the value and not the text (as shown here)

Previously, if you assigned scores to an option field being used in a table option calculation it returned the value and not the text (as shown here)

In the image here you can see that the Current Status is returning the value "1" instead of returning "Injured- Unavailable". This is because the options in the Status field all have scores assigned to them (as shown in the image in the step below).

The scores that are assigned to the options in the "Status" field

The scores that are assigned to the options in the "Status" field

The system would return the option's scores instead of returning the option name in table option calculations.

In the Option Calculation Field you can now write in "option" before the field name and it will return the option instead of the value

In the Option Calculation Field you can now write in "option" before the field name and it will return the option instead of the value

Write in option before the field name to return the option name and not the value.

The calculation will then return the option and not the option's value

The calculation will then return the option and not the option's value

You can see that the option "Injured- Unavailable" appears instead of the value.

You ONLY need to write in option when there is a score assigned to the options that you are using the table option calculation.

You ONLY need to write in option when there is a score assigned to the options that you are using the table option calculation.

The image in the step here shows that the Current Status fields are not being pulled through. This is because the scores were removed for the option in the "Status" table field, but the Table Option Calculation is still written as option(Status).

Remember:

If you do NOT have scores assigned to the options, the system will only pull through the option, so just write the field name e.g. Status.

If you DO have scores assigned to the options, then you need to use the option function and write option(Status) to pull through the options and not the scores.

0 Comments

Add your comment

E-Mail me when someone replies to this comment