Skip to content

Lookup

Reference5 minFoundation

Keep contract statuses consistent with one choice from Draft, Active or Expired. Values come from selects the reusable lookupLookupA reusable list of choices for Lookup and Multi Select Lookup fields.Open glossary ↗ list, and Track value changes records each status change.

One value selected from a reusable lookup list.

LOOKUP

Use when

  • Contract status: Draft, Active, Expired

Choose another type for

  • Selecting several values at once

On a form

A dropdown or radio buttons, according to the form configuration.

In views

Can be selected for configured data view columns. Spreadsheet editing is offered for own, non-key fields of this type when the column is editable.

In Smart Script

getCurrentValue() has a String return type for every field type; an unset value can be null. The stored selection refers to ids, not the displayed label. For a single lookup id, use resolveLookupIdValue to read its text.

Import and export

Supply a numeric lookup id or matching lookup text. Prepare the lookup list in the destination workspace. Review the preview before confirming.

Example

Contract status: Draft, Active, Expired

Settings

SettingWhat it does
Values come fromChooses the reusable lookup list.
Track value changesRecords the old and new values in record history.
Show in record detailsIncludes this field in the record details; forms and data views are configured separately.
Show in the record headerIncludes this field among the record header fields.
PositionSets the order in record details; lower numbers appear first.
Virtual fieldComputes the value at display time instead of storing it.
Encrypt valuesChoose encryption when you create the field.
Encryption keySelect an ACTIVE encryption key.
Default valueSets a plain value or Smart Script for new records.
Field editor drawer for Status: a Lookup field whose values come from the Contract Statuses list, with on-page settings.

    Name the field

    Section titled “Name the field”

    Start the field name with an English letter. Use letters, digits, spaces and underscores.

    What's next

    Which field type should I use?Choose a field type by what people will enter and what you want to do with it later, from short text and dates to lookups, relations and smart fields.Add a fieldAdd a field to a module so people can capture a new piece of information, such as a contract's end date.

    Last checked