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, 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 behind it). When an option is selected, that value is substituted into the block's assigned cell when the calculator runs.
Adding one
- In the Input tab, click + Add 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 is substituted there at run time. See Assigning input blocks to cells.
General
The General group has the shared title, description, and hover hint controls. See Common block settings.
Options
- Show numeric value — when on, each option displays its value beside the label as a light pill (for example
12,400), so visitors can see the number behind their choice. - Display as — appears only while Show numeric value is on. Choose Number, Currency, or %; picking Currency reveals a currency picker. See Number formats.
- Options — click the options row, which reads for example
4 optionsfollowed by Edit, to open the options drawer.
Building the options list
Open the options drawer and add a row for each choice with + Add. Give every option a Label and a Value. Once the list passes five options, a search box appears so you can jump to one by label.
To add many options at once, use the Import CSV button in the drawer. See Importing options from CSV.
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 Allow multiple answers 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.