Category Validation

Category validation pertains to defining category 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.