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.

  • 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
Quantity
  • Greater than
  • Less than
  • Greater or equal to
  • Less or equal to
  • Is
  • Is not
Date
  • Before
  • After
  • Is
  • Is not
Week/Fortnight/Month
  • Before
  • After
  • Is
  • Is not
Multi-line Text
  • Is
  • Is not
  • Starts with
  • Ends with
  • Contains