Selection (Field Type)
What this field type is used for
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.
How to Create
Click the
to add a field in your
form.
Choose “New Field”
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).
Select a field name and click “Choose Type”.
Choose “Selection” from the list of field types.
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.
List Options
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.
-
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
Allow Users to Add New Records
Features
Field Label
Grid Appearance
Other Fields in View Mode
Block Association
Select From a List of
Add While Choosing
Connected Fields
Default Value
Validation
Selection Method
-
-
-
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 History
View Only