Skip to main content
All CollectionsPaperless Forms | Form CreationValidation Rules
Validation Rule: Invalid when is lesser than/greater than [...]
Validation Rule: Invalid when is lesser than/greater than [...]

#EN #Excel #Validation

Updated over 2 years ago

Validation rule to use

Use the sentence Invalid when is lesser than [...] or Invalid when is greater than [...] to set a field to be triggered when it is lesser/greater than a value.

Validation rules available

Invalid when is lesser than Value

Allows to set a field as invalid when it is lesser than a value.

Alternative rules:

  • Invalid when < Value

Invalid when is greater than Value

Allows to set a field as invalid when it is greater than a value.

Alternative rules:

  • Invalid when > Value

Invalid when is lesser than Field

Allows to set a field as invalid when it is lesser than a value in a targeted field.

Alternative rules:

  • Invalid when < Field

Invalid when is greater than Field

Allows to set a field as invalid when it is greater than a value in a targeted field.

Alternative rules:

  • Invalid when > Field

Keywords available with this validation rule

  • Numeric (up to 7 numbers)

  • Text (up to 12 numbers, no text, no symbols)

Did this answer your question?