Configure Field Validation Rules #

Field validatation rules that are checked in the forms in the UI before they are sent to the database.

For example, you can set a validation rule for a field to be a required/mandatory value, or for a text to have a max or min length requirement. The value entered in the form will be validated based on your rules and the user will be presented with a custom warning message in the UI. All before sending the data to the database.

Overview #

"DB Field Name" field - Indicates the name of the associated table field in the database for this Field Definition.

"Display Name" field - Indicates the Display Name for this Field Definition.

"Value is required" checkbox - Used to specify whether or not this field requires a value during Create and Edit operations. If checked, and there is no value provided, a message will be displayed and the Create/Edit will not occur.

"Validate Minimum Length" checkbox - Used to specify whether or not this field has an enforced minimum length. If checked, the value specified in the associated "Minimum length" field will be used to enforce a minimum length for values during Create and Edit operations. If the verification fails, the value in the associated "Minimum length warning message" field will be displayed as a warning message and the Create/Edit will not occur.

"Validate Maximum Length" checkbox - Used to specify whether or not this field has an enforced maximum length. If checked, the value specified in the associated "Maximum length" field will be used to enforce a maximum length for values during Create and Edit operations. If the verification fails, the value in the associated "Maximum length warning message" field will be displayed as a warning message and the Create/Edit will not occur.

"Validate all characters are valid" checkbox - Used to specify whether or not the value for this field will be checked to verify it only contains characters in the associated "Valid characters" field. If the verification fails, the value in the associated "Valid characters warning message" field will be displayed as a warning message and the Create/Edit will not occur.

"Reject invalid characters" checkbox - Used to specify whether or not the value for this field will be checked to verify it does not contain characters in the associated "Invalid characters" field. If the verification fails, the value in the associated "Invalid characters warning message" field will be displayed as a warning message and the Create/Edit will not occur.

"Close" button - When clicked, changes will not be saved and the dialog box will close.

"Save Changes" button - When clicked, changes will be saved and the dialog box will close.