Difference between revisions of "Conditional Lists of Values"

From SmartWiki
Jump to: navigation, search
 
(5 intermediate revisions by the same user not shown)
Line 6: Line 6:
  
 
The article explains the configuration process using the '''ssOption''' syntax and provides examples of how these conditional lists work in practice.
 
The article explains the configuration process using the '''ssOption''' syntax and provides examples of how these conditional lists work in practice.
 
 
  
 
==Configuration==
 
==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 [[:Category:Custom Field Types|custom field types]]:
 
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 [[:Category:Custom Field Types|custom field types]]:
 
 
 
 
  
 
{|
 
{|
Line 25: Line 19:
 
To configure this functionality, for each dependent field:
 
To configure this functionality, for each dependent field:
  
* define the field that will condition the dependent values as the "Parent 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,
+
* 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 36: 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--&lt;ssOption:Canada>;Ontario;British Columbia&lt;/ssOption>&lt;sOption:United States>;Texas&lt;/ssOption></pre>
 +
 
* In the ''City'' field
 
* In the ''City'' field
 
** ''-- N/A --'' will always be shown,
 
** ''-- N/A --'' will always be shown,
 
** ''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--&lt;ssOption:Ontario>;Toronto;Ottawa&lt;/ssOption>&lt;ssOption:British Columbia>;Vancouver&lt;/ssOption></pre>
  
 
[[Image:Conditional Lists - Combined.jpg|link=]]
 
[[Image:Conditional Lists - Combined.jpg|link=]]
  
Any number of lists of values can be made dependent on other lists of values.
+
==Note==
 
+
* Any number of lists of values can be made dependent on other lists of values.
This feature will not work in conjunction with [[Custom Field Type: Dynamic Data – Dynamic Control Field|Dynamic Control fields]].
+
* This feature will not work in conjunction with [[Custom Field Type: Dynamic Data – Dynamic Control Field|Dynamic Control fields]].
 +
* This feature will not work with [[Standard Field|Standard Fields]] e.g. Application Type. Even if standard field is available to select as a '''Parent Field'''.
  
 
==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]]
  
 
[[Category:Custom Fields]]
 
[[Category:Custom Fields]]

Latest revision as of 08:09, 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--<ssOption:Canada>;Ontario;British Columbia</ssOption><sOption:United States>;Texas</ssOption>
  • 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--<ssOption:Ontario>;Toronto;Ottawa</ssOption><ssOption:British Columbia>;Vancouver</ssOption>

Conditional Lists - Combined.jpg

Note

  • 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.
  • This feature will not work with Standard Fields e.g. Application Type. Even if standard field is available to select as a Parent Field.

See Also