Validation rule to use

Use the sentence SET [...] to set a field to a specified value.
Multiple SET can be used in the same validation rule.

Validation rules available

SET U when Field is Value

Allows to set an option button field to a specific value according to a targeted value entered in a specified field.

Alternative rules:

  • SET S when Field is Value
  • SET NC when Field is Value
  • SET C when Field is Value
  • SET Yes when Field is Value
  • SET No when Field is Value
  • SET NA when Field is Value

Example: SET U when Temperature is greater than 4

Keywords available with this validation rule

SET Now

SET Now when Field is not empty

Allows to set a date, time or date/time value automatically if a specified field is not empty.
You may use the keyword Today or Now.
You can target a column instead of a field as well.

Alternative rules:

  • SET Now when Field is Value
  • SET Now when Field is not Value
  • SET Now when Field is Field
  • SET Now when Field is not Field
  • SET Now when Field is lesser than Value
  • SET Now when Field is < Value
  • SET Now when Field is greater than Value
  • SET Now when Field is > Value
  • SET Now when Field is lesser than Field
  • SET Now when Field is < Field
  • SET Now when Field is greater than Field
  • SET Now when Field is > Field
  • SET Now when Field is between Value and Value
  • SET Now when Field is not between Value and Value
  • SET Now when Field is between Field and Field
  • SET Now when Field is not between Field and Field
  • SET Now when Field is between Value and Field
  • SET Now when Field is not between Value and Field
  • SET Now when Field is between Field and Value
  • SET Now when Field is not between Field and Value

Keywords available with this validation rule

Did this answer your question?