Skip to main content

Lookup List

Validate against predefined lists of acceptable values.

Settings

  • Lookup list - Select from available team lookup lists
  • Context - Additional fields for multi-column validation
  • Default value - Fallback when no match is found
  • Autocomplete - Enable value suggestions during manual entry
  • Translation - Enable alternative value mappings

Validation

  • Exact matching against list values (case-insensitive)
  • Multi-column matching when context fields configured
  • Translation mapping for alternative formats
  • Warnings for multiple matches, errors for no matches

Common Use Cases

  • Country and region codes
  • Product categories and types
  • Vendor and supplier names
  • Currency and payment codes
  • Status and classification values