Value List

Value lists are reusable catalogs of options that link to sheet fields. They let you standardize the values allowed in a field — countries, categories, statuses, currencies — and keep consistency across multiple sheets.

Types of value lists

Static

Manually defined values. Each value has:

Sheet-based

Values dynamically pulled from a column in another sheet:

• Source sheet: the sheet the values are pulled from.
• Value field: the column that provides the values (keys).

This lets the list of options update automatically whenever the source sheet’s data changes.

System and common value lists

Besides the lists you define manually, Mind One includes two built-in families of lists that are available from day one, with nothing to create. They appear as an option when configuring a sheet field, just like any other value list.

System value lists

System lists validate a field’s values against the application’s own metadata. Instead of defining the options by hand, the field is validated against your account’s actual entities, and the options resolve dynamically: if you add, say, a new user or workspace, it appears automatically with nothing to update.

They’re useful for fields that must reference an existing entity — for example, an “Owner” field that only accepts real users of the account, or a field that points to a specific workspace or sheet.

Common value lists

Common lists are predefined catalogs of common values that follow international standards. They come preloaded and ready to link to any field, so you don’t have to maintain everyday catalogs like countries, languages or currencies by hand.

Unlike system lists, the values in common lists are static: they represent standardized catalogs that rarely change.

Creating a value list

1. From the sidebar, go to Value Lists.
2. Click Create value list.
3. Fill in the fields:
   • Key: a unique identifier (for example, countries, product_categories). It can’t be changed after creation.
   • Name: a descriptive name.
   • Description (optional): the purpose of the list.
   • Type: static or sheet-based.
4. If static, add the values with their key, label and order.
5. If sheet-based, select the source sheet and the fields.
6. Confirm the creation.

Linking to sheet fields

To use a value list in a sheet field:

1. When defining or editing a sheet field, set the Value list key property.
2. Enter the value list’s key (for example, countries).
3. The field will show a dropdown with the value list’s options.

The same value list can be linked to fields across multiple sheets.

Usage tracking

Mind One tracks which sheets and fields use each value list. From a value list’s detail view you can check:

• The total number of sheets using it.
• The total number of linked fields.
• A breakdown per sheet: the sheet’s name and the specific fields.

Management

Edit

Modify the name, description, values or source configuration. Changes are reflected immediately in every sheet that uses the value list.

Activate/Deactivate

Inactive value lists don’t appear as an option when configuring fields, but sheets that already use them keep working.

Delete

A value list can only be deleted if no sheet is using it.

Templates

Value lists can be marked as templates for reuse when creating new lists with the same value structure.

Permissions

Related

• Sheets — Sheet fields link to value lists.
• Workspaces — Workspace schema fields can also use value lists.