Overview of the Validator Column configuration screen

Overview of the Validator Column configuration screen

Image of SharePoint list with one visual progress bar indicators and color status indicatorsThe Bamboo Validator Column lets you validate column data, and ensures that it matches predefined or custom formats, ranges, and structures.

The Validator Column checks data as it is entered, preventing invalid data from being added to a list.

Image of the Validator Column configuration screenThe above image has been edited to better represent the configuration options.
Function

1. From the List Settings menu, click Create column, then enter the Column name.


2. Select the Bamboo Validator radio button. The screen will refresh.


3. Choose the type of data to be entered into the column from the Column Data Type drop down menu.
The available choices are:

  • Single Line of Text

  • Number

  • Currency

  • Date and Time

NOTE: Additional formatting options may appear in the configuration screen based on your selection.


4. Check Input Required if this is a required field.


5. Identify how the column contents will be validated by selecting the appropriate validator mode check box:

  • Pattern Comparison: allows the Bamboo Validator to compare the user-entered value with a pre-defined pattern or custom expression.

  • Range Comparison: allows the Bamboo Validator to compare a user-entered value to a specific range of Administrator-defined values.

    NOTE: This option will NOT be available if Single Line of Text is selected as the column data type.

  • Column and Value Comparison: lets Bamboo Validator compare the user-entered value with a pre-defined value, or a value found in another column in the current list.

    Icon-Tip Multiple Validator Modes can be selected when configuring a single column.


6.
To include custom tool tip text for the column, enter it in the Tool Tip Text field. Users will see this text when they mouse over the column in the New or Edit forms.

NOTE: This field will only be available in the configuration screen when a validator mode is selected.