Field (Format) Validation
The Vizion Platform provides Field Validation for Administrators to ensure data is properly entered for fields requiring a specific format. When moving and merging data, it is important to make sure data from different sources will conform to business rules and not become corrupted due to inconsistencies in type or context. The goal is to create data that is consistent, accurate, and complete which prevents data loss and errors.
Every instance of the Vizion Platform comes with a standard set of field formats to choose from for validation. This page covers topics for managing this Field Validation list.
Accessing the Field Validation List
Steps to Access the Field Validation List | ||
|---|---|---|
1 | Navigate to Dev Center > Design Applications > Fields |  |
2 | On the Admin Fields page, select Field Validation from the Command Bar or the ellipsis menu. |  |
3 | The list of available field validations display. From here, Administrators can edit, add, or delete from the list in addition to choosing export functions. |  |
Standard Field Validation List for New Vizion Platform Instances
Below is the standard list of Field Validations available in new Vizion Platform instances. These validations can be applied to fields on the Admin Field form.
Adding to the Field Validation List
Steps to Add to the Field Validation List | ||
|---|---|---|
1 | Access the Field Validation list following the steps above and click Add. |  |
2 | Complete the fields on the General tab. Name - Enter a name for the validation. Pattern - Enter the pattern that all fields with this validation must follow. To find a regular expression (regex) to enter here, see http://regexlib.com/. To test your expression, see regex101: build, test, and debug regex or use Test SQL in the Vizion Platform. See Testing SQL. Error Message - Enter the message that displays when data entered in the field does not match the validation pattern. It is a Best Practice to include example acceptable patterns in the error message so users can easily see what will work if they aren’t entering the right format. | 
|
3 | Click OK. |
|
4 | Now the new validation can be applied to a field using the Validation tab on the Admin Field form. See Field - Validation Tab. |
|
Applying Field Validation to a Field
Administrators have the ability to apply field validation to a field using the Validation tab on the Admin Field form. When data is entered incorrectly for a field with field validation applied, an error message displays and the field is not updated. For information on applying field validation, see Field - Validation Tab.
