Conditional Value

The Conditional Value Parameter is used for forcing a value on a field based on the values of other fields. For example: You might want to determine if an individual is qualified to do a task. For them to be qualified they need to be accomplished in all 3 training courses related to that task. We will have three multi button fields initially, all three have two buttons each saying "Complete" or "Not Complete"

• Training Course 1

• Training Course 2

• Training Course 3

We then create a fourth field called "Is Qualified to do the task?" and set the conditional value on this so that all three Training Course fields must equal "Complete", by doing this we can set the value of "Is Qualified to do the task?" to Yes, if not we can set it to No.

Enter Resulting Value when all fields equal their expected values:

This is the value we want this field to have if all the the selected fields equal the values we want them to equal. In the example above this would be "Yes".

Enter Resulting Value when all fields don't meet their expected values:

This is the value we want this field to have if all the selected fields do not equal the values we want them to. In the example above this would be "No"

Enter Default Value:

This is the starting value before any data is changed, often this would be the same as the value when all fields don't meet their expected values.

Add New Field (Select) & Enter Expected Value for this field

You now begin to add the fields you wish to have in your criteria. In the example above you would set Training Course 1 to "Complete", Training Course 2 to Complete and Training Course 3 to Complete

[blocworx-any-word] is our built in "wildcard" value, what this means is that the field can equal any value at all and it will consider the criteria to be met.