search
API Documentation

Valid Values

The Valid Values feature in Decision Tables plays a crucial role in maintaining the integrity and accuracy of your data. By restricting cell entries to a predefined set of valid options, you can prevent errors and ensure consistency across your decision-making processes.

Valid values can be defined in three ways:

  1. Value - A predefined list of allowed values in specific column.

  2. Regex - Pattern-based validation using regular expressions.

  3. Lookup Table Reference - Values from another Lookup Table.

This functionality enhances the reliability of your tables, streamlines data entry, and establishes clear guidelines for data input, fostering a more dynamic and responsive decision-making environment.

hashtag
How to Apply Valid Values

  1. Click the arrow icon in the header of the column.

  2. Select Valid Values.

  1. A modal will open with three validation type tabs: Value, Regex, and Lookup Table Reference.

  1. Choose your validation type and configure it (see sections below).

  2. Click Save values to apply.

circle-exclamation

Valid Values apply to simple cells only.

Valid values do NOT apply when a cell is set to function mode.

Valid values cannot be set for calculated columns (calc columns are always in function mode).

hashtag
Validation Type 1: Value (Predefined List)

Define a specific list of allowed values for the column.

How to set up:

  1. Open the Valid Values modal.

  2. Select the Value tab.

  3. Type valid value and press Enter to confirm.

  4. Repeat for all allowed values.

  5. Click Save values.

Once valid values are applied, every cell (except for functions) in the column is checked against the predefined list. If a cell contains an invalid value, it will be flagged.

Additionally, when valid values are set, you cannot directly type into the cells in that column. Instead, a dropdown with the list of valid values will appear when you click on a cell, allowing you to select the appropriate value.

circle-check

You can use not just simple values, but also variables, dates, or even full expressions as valid values. Spaces and operators are also allowed within a valid value.

hashtag
Validation Type 2: Regex (Pattern Matching)

Use regular expressions to validate cell values against a pattern.

How to set up:

  1. Open the Valid Values modal.

  2. Select the Regex tab.

  3. Enter your regular expression in the Expression field. Examples:

    1. Email validation ^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}$

    2. Phone (US) ^\d{3}-\d{3}-\d{4}$

    3. Postal Code ^\d{5}(-\d{4})?$

    4. Alphanumeric ^[A-Za-z0-9]+$

  4. Test your regex:

  • Enter a test string in the Test String field.

  • Click Test Regex to verify if the pattern matches.

  1. Click Save values.

For more information about regular expressions and pattern syntax, see:

hashtag
Validation Type 3: Lookup Table Reference

Validate values against data from a Lookup Table in your space.

For detailed information about Lookup Table References and how they work, see Lookup Table Reference

Last updated

Was this helpful?