Define validation rule in Aspen
Keep the following in mind when you are defining the rules in Aspen:
- Rules are attached to tables in the Data Dictionary.
- You can set up rules to be enforced when records are saved.
- Do not create a custom validation expression for an address field here. Instead, define it in the General
- If a rule is violated, the user is presented with
a custom error message, such as the following:
To create a validation rule:
- Log on to the
- Select Admin > Data Dictionary tab.
- Select the table you want to add a validation rule for, and click Details.
- Under Tables, click Validations.
- Select Options > Add. The New Data Validation Rule page appears.
-
- Use this table to enter information in the fields.
-
Field
Description
Identifier
Type an identifier for the rule. You can define your own identifiers or you can use state-defined identifiers.
Error Message
Type the error message to appear when a rule is violated.
Example: Active students must have a homeroom. Disabled
Select this checkbox to disable the validation rule.
Note: You might want to create rules, keep them disabled, and then run them as needed. This keeps the rules from running constantly. Condition
Type the condition to be met.
Example: {f:stdEnrStatus} = {Active}
If a student is Active ...
Expression
Type the expression or result when the condition is met.
Example: {f:stdHomeroom} !EMPTY {}
Then the student's homeroom cannot be empty.
