Validation Rules

You can define rules for the validity  of Records. Users won't be able to save a Record that does not follow the validation rules. You can base the validation rules on the fields of your Form or on a specific Formula. Writing a Formula for a validation rule allows you to set more advanced validation rules.

  • A field with validation rules can be a Key field.
  • A field with validation rules can be hidden.
  • A field with validation rules can also have relevance rules.
Field Type Condition
Text
  • Is
  • Is not
  • Starts with
  • Ends with
  • Contains
  • Formula is true + Formula
Quantity
  • Greater than
  • Less than
  • Greater or equal to
  • Less or equal to
  • Is
  • Is not
  • Formula is true + Formula
Date
  • Before
  • After
  • Is
  • Is not
  • Formula is true + Formula
Week/Fortnight/Month
  • Before
  • After
  • Is
  • Is not
  • Formula is true + Formula
Multi-line Text
  • Is
  • Is not
  • Starts with
  • Ends with
  • Contains
  • Formula is true + Formula
Reference
  • Formula is true + Formula