AgileApps Support Wiki Pre Release

Dependent Picklist

From AgileApps Support Wiki
Revision as of 00:36, 19 February 2011 by imported>Aeric (Text replace - ', or click [Cancel] to stop the action' to '')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

A Dependent Picklist provides the ability to define (or filter) a group of choices, based on the selected value.

Any of these field display types can be used to build Dependent Picklists:


How it Works

In manufacturing, a computer might be created from a few Sub Assembly items, each made up of available component parts. The Component Parts might be enumerated, based on inventory level, for example.

Example
Field Name Field Display Type Available Values
Sub Assembly Picklist

External Case Assembly / Circuit Board Kit / Data Storage Devices / Ports and cables

Component Parts Dependent Picklist (select Sub Assembly as Dependent Field)

ST-2342 / ST-99843 / ST-3209 / ST-0094 / FR-23432 / FR-6530 / FR-9093 / RF-234 / RF-235 / RF-237 / GTT-34534 / GTT-0779 / GTT-300567 / GTT-300595 / GTT-300827 / GTT-300857

The resulting Child Values are created based on associations created between Component Parts and the Sub Assembly Parent Value:

Add a Dependent Picklist

For each Dependent Picklist, a "parent" field is selected, which defines the top-level field in the dependency hierarchy. Additional values ("child" fields) are defined within the dependent picklist. The resulting dependent picklist is created by associating "child" field(s) with each "parent" field.

This is a two-step process; first, create the "parent" field, then create the Dependent Picklist (the "child" field).

  1. Using the instructions in Fields, create a new field of any of the following types, add picklist values and save the field (this will be used as the parent field):
  2. Using the instructions in Fields, create a new field of type: Dependent Picklist, and enter the following information:
    Label
    The field label that will be displayed
    Display Type
    Dependent Picklist
    Parent Field
    • Select the "parent" field (created in the previous step)
    • Enter the picklist values
    Optionally, modify any of the remaining sections, using the instructions in Fields
    • Click the [Save] button to save your changes

Manage Enumerated Values

  1. Optionally, click the [Reorder Picklist Values] button to change the order (applies only when Sort List Alphabetically option is unchecked)


Learn more: Enumerated Fields