SharePoint Custom Column – Validate SharePoint Data

Control the structure and format of list data as it's entered.

Read more about two other Custom Columns, Bamboo Rich Text and Bamboo Visual Indicator, in this blog entry.

Take a look at getting started with Custom Columns in this SharePoint Blank entry.

Learn one of the ways we use the Visual Indicator here at Bamboo in this blog entry.

Search the Bamboo Knowledge Base.

Working for a U.S. Government agency or on behalf of one? See our Section 508 Compliance page for information regarding Bamboo product accessibility.

The Bamboo 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.

Color Code

With just a few steps, it's easy to create a Bamboo 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 Bamboo Validator Column, invalid data is quickly flagged as it's entered, and the user can be alerted and assisted with custom error messages. There's no need to worry about improperly formed data polluting your list.

Extending SharePoint Lists and Libraries without InfoPath forms has just become a lot easier. With the List and Forms Extensions Toolkit, receive all the custom columns Bamboo has to offer in a single, convenient package. The List and Forms Extensions Toolkit provides a vast range of functionalities, including true column–level security within your SharePoint lists. Seeking effective key performance indicators (KPIs) for your existing projects? Want to standardize your SharePoint data by requiring users to follow a predefined data–entry format? These capabilities and more are available in a free 30–day fully functional trial.

If you are interested in purchasing more than one Bamboo custom column, consider purchasing the List and Forms Extensions Toolkit, which includes all Bamboo custom columns in a single package (conveniently activated by a single license key).