The Dropdown block lets a visitor pick one option from a list, and feeds that option's numeric value into your spreadsheet. This article covers building the options list, the autocomplete display, showing values, and importing options in bulk.
What it does
A Dropdown is single-select: the visitor chooses exactly one option. Each option has a label (what the visitor sees) and a value (the number written to your assigned cell). When an option is selected, its value flows into the formula engine.
Adding one
- In the Build tab, click + Add in the input area and choose Dropdown.
- Click the block to open its settings.
Settings
Formula
In the Formula group, click Assign to bind the dropdown to a spreadsheet cell. The selected option's value lands there. See Assigning input blocks to cells.
General
The General group has the shared title, description, tooltip, block spacing, and background controls. See Common block settings.
Options
- Show Value — when on, each option displays its numeric value alongside the label so visitors can see the number behind their choice.
- Number Format and Currency — control how option values are displayed. See Number formats.
- Options — the list of choices. Use the inline editor for a few options, or Table View for a fuller editor with search and CSV import.
Building the options list
Open the options editor and add a row for each choice. Give every option a Label and a Value. For long lists, click Table View to manage them in a table, search by label, and import from CSV.
To add many options at once, use the Import CSV button in Table View. See Importing options from CSV.
Autocomplete vs. fixed list
A dropdown can render either as a fixed click-to-open list or as a type-to-filter autocomplete box. Autocomplete is helpful for long option lists where the visitor knows roughly what they're looking for. The fixed list is best for short, browse-and-pick sets.
Single-select only
The Dropdown is always single-select. If you need visitors to pick more than one option and sum the values, use the Selection block with Multiple selection turned on instead.
Dependent dropdowns
You can chain dropdowns so a child dropdown only shows the options that belong to the visitor's choice in a parent dropdown. See Cascading (dependent) dropdowns.