Difference between revisions of "Conditional Lists of Values"

From SmartWiki
Jump to: navigation, search
(Configuration)
Line 22: Line 22:
 
* In the settings page of the "Child Field", there's a drop down field called "Parent Field" - this must be populated with the "Parent Field" being referenced.
 
* In the settings page of the "Child Field", there's a drop down field called "Parent Field" - this must be populated with the "Parent Field" being referenced.
 
* Surround the dependent values with the '''ssOption''' syntax:
 
* Surround the dependent values with the '''ssOption''' syntax:
 +
 
<pre>&lt;ssOption:Parent Value 1>;Dependent Value 1;Dependent Value 2&lt;/ssOption></pre>
 
<pre>&lt;ssOption:Parent Value 1>;Dependent Value 1;Dependent Value 2&lt;/ssOption></pre>
 
  
 
In the configuration shown below:
 
In the configuration shown below:
Line 31: Line 31:
 
** ''Ontario'' and ''British Columbia'' will only be shown if ''Canada'' is selected in the ''Country'' field, and
 
** ''Ontario'' and ''British Columbia'' will only be shown if ''Canada'' is selected in the ''Country'' field, and
 
** ''Texas'' will only be shown if ''United States'' is selected in the ''Country'' field.
 
** ''Texas'' will only be shown if ''United States'' is selected in the ''Country'' field.
<pre>-Select One-<ssOption:Canada>;Ontario;British Columbia</ssOption><ssOption:United States>;Texas</ssOption></pre>
+
 
 +
<pre>-Select One-;Ontario;British Columbia;Texas</pre>
  
 
* In the ''City'' field
 
* In the ''City'' field
Line 37: Line 38:
 
** ''Toronto'' and ''Ottawa'' will only be shown if ''Ontario'' is selected in the ''Province'' field, and
 
** ''Toronto'' and ''Ottawa'' will only be shown if ''Ontario'' is selected in the ''Province'' field, and
 
** ''Vancouver'' will only be shown if ''British Columbia'' is selected in the ''Province'' field.
 
** ''Vancouver'' will only be shown if ''British Columbia'' is selected in the ''Province'' field.
<pre>--N/A--<ssOption:Ontario>;Toronto;Ottawa</ssOption><ssOption:British Columbia>;Vancouver</ssOption></pre>
+
 
 +
<pre>--N/A--;Toronto;Ottawa;Vancouver</pre>
  
 
[[Image:Conditional Lists - Combined.jpg|link=]]
 
[[Image:Conditional Lists - Combined.jpg|link=]]
Line 46: Line 48:
  
 
==See Also==
 
==See Also==
 +
* [[Custom Field Type: Select Many – Check Boxes|Select Many – Check Boxes]]
 +
* [[Custom Field Type: Select One - Dropdown List]]
 
* [[Show/Hide Header]]
 
* [[Show/Hide Header]]
 
* [[Custom Field Type: Dynamic Data – Dynamic Control Field|Dynamic Control fields]]
 
* [[Custom Field Type: Dynamic Data – Dynamic Control Field|Dynamic Control fields]]
 +
* [[Custom Lookup Options|Custom Lookup Options]]
  
 
[[Category:Custom Fields]]
 
[[Category:Custom Fields]]

Revision as of 07:54, 26 January 2024

Overview

The article describes how to configure conditional lists of values in custom field. These lists, also known as dependent dropdown lists, change their available options based on the selection made in another, related field (the Parent Field). This functionality is applicable to custom fields:

The article explains the configuration process using the ssOption syntax and provides examples of how these conditional lists work in practice.

Configuration

The list of values selectable in a custom field can be made conditional upon the value selected in another custom field. This functionality can be configured on the following custom field types:

Canada-Ontario-Cities.jpg or US-Texas.jpg

To configure this functionality, for each dependent field:

  • Define the field that will condition the dependent values as the "Parent Field".
  • In the settings page of the "Child Field", there's a drop down field called "Parent Field" - this must be populated with the "Parent Field" being referenced.
  • Surround the dependent values with the ssOption syntax:
<ssOption:Parent Value 1>;Dependent Value 1;Dependent Value 2</ssOption>

In the configuration shown below:

  • In the Province field
    • --Select One-- will always be shown,
    • Ontario and British Columbia will only be shown if Canada is selected in the Country field, and
    • Texas will only be shown if United States is selected in the Country field.
-Select One-;Ontario;British Columbia;Texas
  • In the City field
    • -- N/A -- will always be shown,
    • Toronto and Ottawa will only be shown if Ontario is selected in the Province field, and
    • Vancouver will only be shown if British Columbia is selected in the Province field.
--N/A--;Toronto;Ottawa;Vancouver

Conditional Lists - Combined.jpg

Any number of lists of values can be made dependent on other lists of values.

This feature will not work in conjunction with Dynamic Control fields.

See Also