The Searchable (DB) dropdown adds a type-ahead search box on top of a DB-driven option list. It's the right pick for fields with more than around 50 possible options, or where the user knows what they want and finds typing faster than scrolling.
Conditional options
- Data Source — which table and field the options come from.
- Field to Group By — group options under headings.
- Option Sorting (Required) — A-Z, Z-A, or By Field (reveals a Sort Field Name input).
- onChange Code — Javascript run on selection. Use
e.currentTarget.id,e.params.args.data.id,e.params.args.data.text. - Option Filter (Required) — filter options by criteria.
- Display Format — control how each option is rendered.
##AMDATA_**##tokens are replaced with source-row field values. Example:##AMDATA_firstname## ##AMDATA_lastname## (##AMDATA_email##). - Only Fetch Own Records? — only options inserted by the logged-in user.
- Show Data from all Tenants? — pull options across all tenants (requires architect access).
- Parent ID Field — if you would like to show the options in a hierarchy tree, please enter the parent ID field name here. The table must contain at least 1 row with the value of 0 in the parent ID field.
- Option Enable Field — if you would like some options to be disabled, you can enter the field name within the source options table here. This works best with tickbox and toggle switch fields as 0 = disabled and 1 = enabled.
- Allow Multiple Selections (Required) — Yes for multi-select, No for single-select.
- Colour Field — if the source table contains a colour field, options will be shown in the specified colours per row.
- AJAX Mode (Required) — if there are a large amount of options within the dropdown field then you may experience better performance using AJAX to fetch the options. Picking AJAX Mode loads options on demand as the user types.
Hierarchy trees
Set Parent ID Field to render a tree. The platform expects rows whose Parent ID column is 0 to be top-level, and rows whose Parent ID points to another row's ID to be children. Users see expandable groups in the dropdown.