Dropdown Box (Single) (DB) Field

Single-select dropdown whose options are pulled from a datastore. Use it whenever the option list belongs to an admin-editable table.

Conditional options

• Data Source — which datastore (and which field) the options come from.
• Field to Group By — if the source has a grouping column, options are grouped under headings.
• Option Sorting (Required) — Alphabetically (A-Z), Alphabetically (Z-A), or By Field. Picking By Field reveals a Sort Field Name input.
• onChange Code — a Javascript function you would like to run when a new option is selected. You can use e.currentTarget.id to get the field ID, e.params.args.data.id to get the option value and e.params.args.data.text to get the option text.
• Option Filter (Required) — narrows the source rows by criteria.
• Display Format — if you'd like the value displayed in a different format or with additional fields. ##AMDATA_**## tokens are replaced with field values from the source row.
• Only Fetch Own Records? — if ticked, only rows inserted into the linked table by the logged-in user will be shown in the dropdown list.
• Show Data from all Tenants? — if ticked, options from all tenants will be shown. Only applies if the user logged in has architect access.

When to pick Single (DB) vs. Searchable (DB)

Single (DB) renders a standard <select> — best when the option list is small. Searchable (DB) renders a type-ahead search box — best when the list is long (100+ options) or filtering by typing is faster than scrolling.