Configure field dependencies by configuring the type of field, the value in the field, and then which field should be impacted. For example, if you wanted the currency code for one field to be dictated by the currency code being used in a different field, you would fill the following into the Field Dependencies subtable:

  • Controlling Field Type: Currency. Tells the system what part of the dependent field should be dictated by the controlling field. In this case, it is a currency code for the field. 
  • Controlling Field: The name of the field that controls the dependent field. In this case, the name of the currency field whose currency code you want to control the dependent field.
  • Dependent Field: The name of the field that is impacted by the controlling field information. In this case, the field whose currency code is controlled by the controlling field. 

With this configuration, whatever currency code is used in the controlling field controls which currency code is used in the dependent field. If the controlling field has a USD code, the dependent field also has a USD code. 

There are many configuration options for Field Dependencies, as seen in the table below:

Controlling Field TypeControlling Field Dependent Field
Calendar End Time
Holds the end time to be displayed on the calendar. 
A time data item. Displays the selected time as the last time visible on the calendar. 
Must be a Calendar data item. 
Calendar Jump to Time
Holds the time to be displayed.
A time data item. Displays the time selected in the field. 
Must be a Calendar data item. 
Calendar Name
Holds the calendar name to be displayed in the Calendar data item. 
The data item that holds the calendar name, or a table lookup on the calendar.Displays the calendar of the calendar name specified in the controlling field. 
Must be a Calendar data item. 
Calendar Start Date
Holds the calendar data to be displayed in the calendar. 
A date data item. Displays the selected date in the calendar. 
Must be a Calendar data item. 
Calendar Start Time
Holds the start time to be displayed on the calendar.
A time data item. Displays the selected time as the first time visible on the calendar. 
Must be a Calendar data item. 
Chameleon Data Item (Limited Use)
Takes on the data item type of whatever data item is in the controlling field. 
The value in the controlling field must resolve to a valid data item. Supports values based on data item types. 
All data item types are valid. 
Chameleon Table (Limited Use)
The dependent field turns into a table lookup over the table entered in the controlling field. 
The value in the controlling field must resolve to a valid table name. Table lookup field with values based on table name and default search field.
Must be a table lookup over a Table Schema data item type. 
Chameleon Workflow (Limited Use)
The dependent field shows the workflow options for workflow set up over that table.
The value in the controlling field must resolve to a valid table name. Table lookup field of type Text. 
Credit Card Token
Used to get the credit card API token out of a credit card object.
A credit card object. A text value which contains the credit cards token. 
Any field of type Text data item.
Credit Card Vendor
Used to set the credit card vendor in or get the vendor out of a credit card object. 
Can be either:
  • A credit card object. 
  • A value from the APIKeyVender List Lookup. 
If you select a credit card object as the controlling field, a value from the APIKeyVender List Lookup is the dependent field. 
If you select a value from the APIKeyVender List Lookup, a credit card object is the dependent field. 
Expression Source Table
The controlling field value tells the dependent expression field the table name whose fields are available to use in the expression. 
Only one controlling field of this type is allowed per dependent expression field. 
Must resolve to a valid table name. An expression that contains fields from the table defined by the controlling field value. 
Must be an expression data item type. 
Expression System Engine Key
The controlling field tells the dependent expression field which category of System Values are available for use in the expression. System Values are mapped in the System Value application and associated with a System Engine Key. 
Only one controlling field of this type is allowed per dependent expression field. 
Must resolve to a value from the SystemEngines list lookup.An expression that contains system values whose engine is equal to controlling field value.
Must be an expression data item type. 
Field Control
The use is determined by the data item type of the dependent field. 
Can be either:
  • A valid 3 character currency code. 
  • A valid name format. 
  • A valid address format. 
The dependent field for each is defined in:
  • The Currency Manager application. Must use a currency data item type.  
  • The Format Definitions application. Must use a name data item type. 
  • The Format Definitions application. Must use an address data item type. 
Inline Attachments Carousel On (deprecated)
Allows attachments to be displayed in a carousel in the detail form. 
N/AThe attachments displayed inline. 
Must use the AttachmentGroupId data item. 
Inline Filter Table Name

Uses the controlling field value to determine what table an inline filter data item will build its filter over.

A table lookup to the TableSchemas table.

Note: If this field is left blank, the table that this application is built over is used as the default.

The inline filter data item that should build its filter based on the value in the controlling field.
Lookup Validation
Use with filtered table lookups to disable the dependent field (the filtered field) when the controlling field is not populated with a value. 
The field on the app containing the value used to filter the table lookup. The filtered table lookup field. 
Must use a Table Lookup data item. 
Multi-Segment Format Default
Uses the controlling field value to find the format whose unique name is exactly equal to the text value, then sets the format in the panel and locks it so that it cannot be changed by the user. 
Must resolve to a valid multi-segment format name. The multi-segment data item whose format is set to the controlling field value. 
Must use the Multi-segment data item group. 
Multi-Segment Format Filter
Uses the text value from your controlling field to filter out any formats whose unique format name does not begin with that value.
Any value of type text. The multi-segment data item whose available formats begin with the controlling field value. 
Must use the Multi-segment data item group.