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 Type | Controlling Field | Dependent Field |
Calendar End TimeHolds 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 TimeHolds the time to be displayed. | A time data item. | Displays the time selected in the field. Must be a Calendar data item. |
Calendar NameHolds 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 DateHolds 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 TimeHolds 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 TokenUsed 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 VendorUsed to set the credit card vendor in or get the vendor out of a credit card object. | Can be either:
| 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 TableThe 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 KeyThe 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 ControlThe use is determined by the data item type of the dependent field. | Can be either:
| The dependent field for each is defined in:
|
Inline Attachments Carousel On (deprecated)Allows attachments to be displayed in a carousel in the detail form. | N/A | The attachments displayed inline. Must use the AttachmentGroupId data item. |
Inline Filter Table NameUses 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 ValidationUse 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 DefaultUses 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 FilterUses 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. |