Creating and Updating Data Validation Rules
To implement business policies and practices, you can build data validation rules that are checked when conditions are met in forms. Validation messages can be generated if entered data violates validation rules. You can also build limits on submitted planning unit data using validation rules, and designate a reviewer, owner, or notifier to review data that meets some condition.
For example, data validation can ensure that a department’s capital expenses adhere to company policies by preventing planners from submitting budgets that contain capital expenditures that fall outside the company’s guidelines. Sample scenarios that can be addressed using data validation rules are described in Data Validation Rule Scenarios.
Defining data validation rules involves these main tasks:
-
Identifying the data cells or location that you want to display with validation messages or in different colors when conditions are met.
-
Identifying the cells that need to participate during rule evaluation, and defining the rule accordingly.
-
Creating the data validation rule at the location identified, as described in this topic.
To create and update validation rules: