Setting Out-of-Specifications
Last updated
Last updated
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.
<
>
Less than, more than
<=
>=
Less than or equal to, more than or equal to
==
Equal to
!=
Not equal to
@Formula == true
If the formula field is checked
@Formula == false
If the formula field is unchecked
now()
The current date and time
equalText( @select/@Text, "text")
not equalText( @select/@Text, "text")
Note that this OOS applies to Select and Text field values only
or
OR statement
and
AND statement
@Field == null
If the field is blank