Skip to content

Insight

Reference5 minFoundation

Show a contract’s status progress or time until expiry using fields it already has. Insight field opens the wizard for Progress, Age, Due or Compare and creates a Smart field behind the visual.

A visual Smart field configured with the Insight field wizard.

SMARTFIELD

Use when

  • Contract: show its status progress or time until expiry

Choose another type for

  • Typing a new stored value

On a form

Use record displays to show the computed result from the record’s existing values.

In views

Can be selected for configured data view columns. Configure its display in the data view settings.

In Smart Script

getCurrentValue() has a String return type for every field type; an unset value can be null. Read the string value before using it in an expression.

Import and export

The output is calculated by a script. Import the source fields rather than relying on an imported computed value.

Example

Contract: show its status progress or time until expiry

Settings

SettingWhat it does
ProgressShows lookup stages as Bar, Steps or Ring.
AgeMeasures time since a date, with warning and danger thresholds.
DueShows today between a start date and a due date.
CompareCompares the numeric fields you choose.
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.
The Insight field configuration and its type-specific settings.

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