All Collections
Paperless Forms | Form Creation
Validation Rules
Validation Rule: Invalid when empty if [...]
Validation Rule: Invalid when empty if [...]

#EN #Excel #Validation

Updated over a week ago

Validation rule to use

Use the sentence Invalid when empty if [...] to set a field to be triggered when a condition is met.

Validation rules available

Invalid when empty if Field is Value

Allows to set a field as invalid when a targeted field has reached a targeted value.

Alternative rules:

  • Invalid when empty if Field is not Value

Example: Invalid when empty if Condition is U

Invalid when Value if Field is Value

Allows to set a field as invalid when it reaches a targeted value and if a targeted field has reached a targeted value.

Alternative rules:

  • Invalid when Value if Field is not Value

Example: Invalid when NC if Condition is NC

Invalid when empty if Checkbox is checked

Allows to set a field as invalid when a targeted checkbox field is checked.

Alternative rules:

  • Invalid when empty if Checkbox is unchecked

Invalid when empty if Field is lesser than Value

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

Alternative rules:

  • Invalid when empty if Field is < Value

Invalid when empty if Field is greater than Value

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

Alternative rules:

  • Invalid when empty if Field is > Value

Invalid when empty if Field is lesser than Field

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

Alternative rules:

  • Invalid when empty if Field is < Field

Invalid when empty if Field is greater than Field

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

Alternative rules:

  • Invalid when empty if Field is > Field

Keywords available with this validation rule

Did this answer your question?