Setting Out-of-Specifications
Users can set an Out-of-Specification expression on Number, Formula, Text, and Select fields, using the formula language.
The expression must resolve to a boolean true or false .
If the expression is true, the field will be highlighted and you will see an icon warning that the value is out-of-specification.
Add and edit the field ‘out of spec’ expression from the field three-dot-menu.
Use the @ symbol to see available field value suggestions.
Reference the field value that you want to validate against any condition using the operators available in Seal's formula language.
You can compare the field value to other field values within the same entity.
Out-of-Spec Expression Additions
The out-of-spec (OOS) expression extends the capabilities of the standard formula language. This section outlines specific operators and techniques unique to OOS within the formula language framework.
now()
-
The current date and time
@Field == true
E.g.
@Cell checked == true
Checkbox
If the field is checked
@Field == false
E.g.
@Cell checked == false
Checkbox
If the field is unchecked
@Field == null
E.g.
@Number == null
Any
If the field is blank
Last updated