Constants

A constant is a lookup table — a structured grid of columns and rows. Constants serve two purposes in termco:

1. Controlled values — Restrict a processor field’s valid values to entries in a constant column.
2. Logic lookups — Reference constant data in logic block expressions for dynamic validation.

Creating a Constant

1. Navigate to Data > Constants and click New Constant.
2. Enter a name, optional description, and tags.
3. Define columns — each column has a name and unique ID.
4. Add rows by filling in cell values.
5. Click Save.

Editing

• Add or remove columns at any time.
• Edit cell values by clicking directly in the table.
• Add new rows with the Add Row button.
• Delete rows by selecting them and clicking Delete.

CSV Import and Export

Import

1. Click Import CSV on the constant editor.
2. Upload a CSV file — column headers become constant columns, and rows populate the data.
3. Review and adjust before saving.

Export

Click Export CSV to download the current constant data as a CSV file.

Using in Processors (Controlled Values)

Link a constant to a processor field to restrict its values:

1. Open the Processor editor.
2. On the target field, set Controlled Values to the desired constant.
3. During review, the field displays a dropdown of values from that constant column instead of free text.

Using in Logic Blocks

Use the lookup() function in logic block expressions to reference constant data:

lookup($field_value, "constant_id", "lookup_column", "return_column")

This finds the row where lookup_column matches the field value and returns the return_column value. If no exact match is found, fuzzy matching is attempted.

See the Expression Syntax reference for details.

Duplicating

To create a copy of an existing constant (useful for versioning or creating variants):

1. Open the constant you want to copy.
2. Click Duplicate.
3. The copy opens in the editor with all columns and rows preserved.
4. Rename and modify as needed.