Validator Column enables you to create programmatic restrictions on values entered into a list column, so that data is automatically validated before being stored, and invalid data can be immediately corrected by users.
With just a few steps, it is easy to create a Validator Column using a number of different comparison methods:
- Use Pattern Comparison, and dial up a predefined pattern for many common business applications (phone number, e-mail address, social security number), or create your own, using regular expressions for validating elaborate custom SKUs and other data with complex format requirements
- Restrict numeric or date-based values to a specific range with Range Comparison
- Or use Value Comparison to base your data restrictions on a fixed value, OR the current value of another column in the list — and use arguments like Greater Than/Less Than, Contains/Does Not Contain to further customize your rules
With the Validator Column, invalid data is quickly flagged as it is entered and the user can be alerted and assisted with custom error messages. There is no need to worry about improperly formed data polluting your list.