Skip to main content

Dropdown inputs

Parameterize your analysis based on users' selection of a single value from a list of enumerated numbers or strings.

info
  • Users will need Can Edit permissions to create and edit input cells.
  • Users with Can View App permissions and higher can interact with input cells in published Apps.

Static values​

Static values are input manually. Hex supports several methods:

  • Typing them one-by-one and hitting Enter/Return on your keyboard
  • Entering a comma-separated list (option 1, option 2, option 3) and hitting Enter/Return on your keyboard
  • Copy-pasting a comma separated list
Dropdown input parameter with statis input settings open

Dynamic values​

Dynamic values allow you to link a dropdown's available options to a dataframe column, list, numpy array, or Pandas series from the code itself.

Dropdown input parameter with dynamic input settings open

In both the Notebook view and App builder, if the selected value is no longer available in the input object (i.e., an upstream change eliminates that option), the selection will default to the first value in the input object.

tip

Dropdowns will only show the first 10,000 results, all following options will be truncated.

Optional input​

Enable the "Optional" toggle if you want users to be able to clear their selection. When enabled, users can click "Clear selection" in the dropdown to clear their selection. When this occurs, the output variable will pass None to any downstream cells that reference the output.

Dropdown input parameter with optional toggle enabled

On this page