Category validation pertains to defining catagory properties. For information on entering validation data, refer to Step 3: Defining Category Properties.
A category with the data type of integer, float, text, or date can have predefined limits called validation. These validation limits provide a logical framework for future manual input into the category.
The data input into a category can be validated in two ways:
- Masking (for text categories): allows the user to create an input mask. For example, a phone number format mask. If the input is not within the masking definition for the category, the system prompts for the expected input.
- Data Validation: the data in the cell is checked for compliance with the predefined limits. For example, if the input has to be a positive number, negative numbers will be rejected.
Data validation is performed in the Forms, Dashboards, and Scorecards modules as well as the Cell Properties dialog box.
Note: Data validation is performed for manual data entry only. There's no validation if data is entered by functions calculation, etc.