Selection (Field Type)

Selection fields allow a user to select choices from a list. The choices in the list are created in one of two ways:

• Static - Choices are pre-defined, such as Yes/No, Small/Medium/Large. Any changes to the list of available options would need to be made in the development environment, then updated to testing/production. Use static lists when the choices in the selection field do not need to change often, and data does not need to be stored/referenced for each selection option.
• Dynamic - Choices for dynamic (sometimes called data-driven) selection fields are the records in another table within the application (e.g. a list of employees). Use dynamic lists when the user needs to select another record in the system, when the options available in the list need to change often, or when data needs to be stored/referenced for each selection option. Note: when using dynamic selection fields, the text of the record to be selected always comes from the title field for the selected table.

1. Click the to add a field in your form.
2. Choose “New Field”
3. Select the table you wish to add the field to. Most of the time, this will be the current table you are on (for more information, click here).
4. Select a field name and click “Choose Type”.
5. Choose “Selection” from the list of field types.
6. Select whether the options the user can select will come from another database table or from a static list.

There are number of options depending on various choices you make for your selection field. As you go through the wizard, you will encounter various options listed below.

• Select whether users can make one selection or multiple selections.
• Select what interface to use for selection
  • Text Search - As a user types in their selection, suggestions from the the list or database table will appear.
  • Left-Right Dialog - The user will select options from the left-hand box and move them to the right-hand box.
  • Checkboxes - Users see all the options and check a box to select their options.
  • Drop-down - A drop down list with the options appears for the user.
  • Radio Buttons - Users see all the options and can select only one.
• Select the table that holds the records the users can choose from
• Select what records from that table the users will see as their choices.
  • All - All the records in the table will be shown
  • Related - If there any existing relationships between the table from Step 3 and other tables, those relationships will appear here.
  • Other - You can create your own query. You can choose to manage a relationship based on the user selection.
• Manage a relationship
  • Do not manage a relationship - Select this if you will not need to use this field in a query later.
  • Add New Relationship Type - If you would like to add a new relationship, the wizard will walk you through this.
  • Select Existing - If there are existing relationships, you will see those listed.
• Search and Pick Records
  • If you are allowing users to search for records, you have three options:
    • Use the default WorkXpress created page to display records users can pick from
    • Select a different page you have already created
    • Create a new page to display records
• Allow Users to Add New Records
  • If you would like users to be able to add new records from the selection field, you have three options:
    • Use the default WorkXpress created page to add records to the table
    • Select a different page you have already created
    • Create a new page to add records

• Field Label
• Field Setting - Display Alternate Label (affects this form only)

• Column Span
• Row Span

• Other Fields in View Mode (only applies to dynamic selection fields)

• Tooltip
• Descriptive Text
• Display Alternate Descriptive Text (affects this form only)

• Temporary Block Association
• Global Block Association

• Dynamic Selection Fields Only
  • Define This Field's Search
  • Show Different Records in This Location
  • Options Available in List Searches
• Static Selection Fields Only
  • Select Option Name
  • Alternate Title
  • Order

• Add While Choosing

• Connected Fields

• Default Value

• Required

• Single Picker Select Method
• Select an Interface
• Variant
  • Dynamic Selection Fields that use the “List With Checkboxes” interface can choose an additional variant. The additional variant “Tree of Checkboxes with Child Field” will present the end user with an array of checkboxes. Under each checkbox row if that selection has valid child options as defined by the child field configuration then those options are rendered underneath that option and that option gains the ability to show and hide its child options. When this variant saves it will save values in both itself and the child field. This variant also affects how the field is interacted with in List Forms and Filter Fields. When this field is rendered in the filter it will show the same tree and if the user selects values at multiple levels then it will generate one filter per field, parent and child.

• Search

• Audit This Field
• Show Audit History

• View Only