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.

Operators
Description

< >

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

Last updated