Using Range Comparison as a Validator

Using Range Comparison as a Validator

Overview of Validator Column configuration screen

Range Comparison allows the Validator Column to compare a value entered by a user to a specific range of values, provided by the site administrator.
Image of the Validator column configuration screen when the Range Comparison check box is selected
The image has been edited to better represent the configuration options.
The following steps require you to have accessed the New Column settings screen and selected Bamboo Validator as the column type.


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


Check the Range Comparison check box to expose the pattern comparison configuration options.

NOTE:This option will be grayed out if Single Line of Text was selected as the Column Data Type.

3. Enter the Minimum and Maximum values into the corresponding fields.
4. Enter the required message that will be displayed when an entered value is determined to be invalid in the Validation message field.