Field Validation
Short Description
The Field Validation module allows users to define single or multiple validation rules such as field value requirements and behaviour of the fields throughout the VMS. Field validation (or data validation) is the process of ensuring that data is valid and correctly entered into the fields of a system/program. The purpose is to prevent incorrect data entry and can be set either via the Field Validation module or from within another module.
Each validation rule must contain a name identifying the field it is for, (i.e. the field's database name), a validation type indicating the requirements of the field and a validation level indicating the type of message that will display if a validation rule is broken. A validation rule can for example be defined as allowing only positive numbers to be entered into a certain field, for example fo_rob_delivery should always be a positive, never a negative, etc.
The field validation settings in Dataloy VMS are divided into three types indicating field value requirements:
- Length - Defines the number of exact charaters allowed and/or required.
- Not Null – Requires field to be filled in.
- Range – Defines a range of allowed numeric values.
- Set – Defines a number of exact allowed numeric or string values.
The validation level indicates the type of message that will display if a validation rule is broken. There are three levels:
- ERROR - An error message is displayed and the user is not allowed to proceed until data is entered correctly.
- OFF - Validation rule disabled - No warning is given when data is incorrectly entered.
- WARNING - The system prompts a warning that data is incorrectly entered but allows a user to proceed.
Alerts indicating that a validation rule has been broken can be displayed by red or yellow onscreen indicators (depending on level) and in some instances with additional pop-ups.
Location: Modules > System > Field Validation
