Keyword to use
Use this keyword to create a control to validate other fields.
This control will allow you to absorb the invalidities of targeted fields by removing their invalid bars and setting automatically the button's options according to the choice of options:
Description | Keyword to Use |
Buttons C/NC/NA | validityCNCNA |
Buttons S/U/NA | validitySUNA |
Buttons Yes/No/NA | validityyesno |
Buttons No/Yes/NA | validitynoyes |
Buttons Pass/Fail/NA | validitypassfail |
Buttons Accepted/Refused/NA | validityacceptedrefused |
Buttons Ac/Re/NA | validityacre |
Buttons Acceptable/Unacceptable/NA | validityacceptableunacceptablena |
Buttons A/U/NA | validityAUNA |
With this control, you will be able to:
Create a read only option button control, that will compare the invalidities of mutiple targeted fields within one control;
View the fields triggering the invalidity with the help of a visual indicator;
There is no limit of fields you can compare.
In order to use this control, you need to:
Set the validation rules in the targeted fields for the validation control;
Use column C (or the third row for a column) to taget fields by adding them between parentheses ("(" et ")");
All the fields, except for optional ones, must be filled in order for the validation to resolve.
Example of fields for validation:
Example of a table with validation:
Example of validation of a column:
Explanation of validation
This control compares invalidities of targeted fields to automatically set Satisfactory, Unsatisfactory or Non Applicable in a validation control.
This automatism is executed once all targeted fields are filled.
If all fields are valid, the result will be S;
If all fields are invalid, the result will be U.
A pale red visual indicator will let you know which field causes the invalidity;
If one of the fields is invalid, the result will be U.
A pale red visual indicator will let you know which field causes the invalidity;
If one of the field is non applicable, but others are valid, the result will be S;
If one of the field is non applicable, but others are invalid, the result will be U.
A pale red visual indicator will let you know which field causes the invalidity;
If one of the field is non applicable, but one of the others is invalid, the result will be U.
A pale red visual indicator will let you know which field causes the invalidity;
If all fields are non applicable, the result will be NA;
If a field (or multiple) is optional, it will not affect the validation.
In summary:
Type of controls available with this keyword
Field
Use the ABC method to create a field control.
Column
Use the 123 method to create a column control.