Open topic with navigation

Use this dialog to create a validation rule, which is a custom expression that you can use to make sure that the data in the selected field is valid. Depending on where in the user interface this dialog is opened from, its title might be Edit Record Validation or Edit Validation for Field.

The following options are available: 

• Rule: Provides an input box for you to enter the validation rule expression that you want, a pane that lists the expression elements, a search box, and a pane that displays a description of each element attribute.

  The following expression elements are available:

• Fields: Displays the field names and data type formats.

• Constants: Displays the available Boolean constants.

• Operators: Displays the available operators.

• Functions: Displays the available functions. The functions are organized into the following categories:

• DateTime: Displays the available date and time functions.

• Logical: Displays the available logical functions.

• Math: Displays the available mathematical functions.

• String: Displays the available string functions.

For each element, you can use the Search box to filter the valid values to find exactly the value that you want. Double-click a value to add it to the expression in the Rule input box.

• Error Message: Provides an input box for you to enter the error message that you want to be displayed if the data is not valid.