Field Constraints App is part of KWizCom Forms App (Standard edition).
With the Field Constraints app you can easily configure field-validation rules to enforce input patterns according to your required form logic: Email, field length, IP address, zip code value ranges and any other custom pattern. These field validation rules are processed when a user saved a list form (New Item or the Edit Item form).
KWizCom Field Constraints app
Validate Lookup and Person columns.
Validate a field value comparing to a regular expression.
Manage and share custom validation rules across your organization.
Dynamic validation rules: validation rules that are conditionally applied, depending on values of other fields and current user.
Save field permission settings within site and list templates
After you install the Field Constraints app, you will see its ribbon button in every list’s “List” ribbon:
Clicking this ribbon button will open the list’s Field Constraints settings page:
This settings page allows you to create field validation rules, each rule validates an input pattern for a selected field. After you have configured your rules and saved them, these rules will be processed according to their order every time user saves a list form.
To setup a field constraints rule, follow these steps:
Select a column that you wish to validate in the “Select a column” drop-down:
Create a new rule by clicking the “new rule” link:
A new rule definition section will appear:
To setup a rule:
After you save the rule by clicking “Apply” or “Save” this rule will appear below the “All Rules” section: To edit an existing rule, simply click the “Edit” link appearing on the left side of each existing rule.
When validating text fields, there’s an additional operator that you can use called “matches pattern”:
When selecting the “matches pattern” operator a list of various input pattern appear as possible values. These pattern enable you validate the text field’s input pattern and compare it to common patterns such as Date, Email, file names and more.
All of these patterns are located in a list; this makes it easy to share these custom patterns, and also add a new custom pattern of your own.
To create a new pattern, click the “go to patterns list” link below the “Value” control:
The Regex editor popup will appear:
This popup enables you to create new custom patterns (based on regular expressions), as well as to edit existing custom patterns.
To create a new custom pattern fill-out the following fields under the “new regular expression” section:
· Name – the new custom pattern’s name (should be clear to other users)
· Regular Expression – A valid regular expression string.
· Modifiers – Check the relevant options for your custom pattern.
· Test value – Type a value that should match your pattern, you will see an immediate feedback if it does match or not.
To save your new custom pattern click the “SAVE” button at the top of the Regex editor popup.