Skip Ribbon Commands
Skip to main content
Sign In

Customer Service: 1-855-594-9266

canada flag

Field Constraints

Product Overview

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).

 

Key Features

Feature

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


Configuring field constraints

Setting-up a field constraint

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:

 

  • Select validation operator
COMMENT: depending on the current column type, different validation operators will be available.

 

 

  • Select/type the value for the validation rule:


    The validation control depends on the validated column type. In the screenshot above you see a textbox with a date picker because the validated column in this rule is a date column.
    As you can see in this example, you can also use tokens, including column names, surrounded by brackets “[ ]”.

 

 

  • Type the validation error message:


    This error message will be displayed to the user who tries to save the form with value that does not match the validation rule.

 

 

  • Highlight field:


    Check this checkbox if you want the field to be highlighted when the validation error occurs.

 

 

  • Setup conditions:
    These conditions define when the field validation rule should be applied. You can create several conditions as you can see in the following screenshot:



 

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.

 

Using custom patterns

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.

 

Creating a new custom pattern

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.

 

Details
Last modified at: 11/16/2020 7:10 AM
Last modified by: Nimrod Geva
Type: User-guide
Rating:
Article has been viewed 677 times.

Also in this category

Powered by KWizCom WikiPlus