Activeboards / Activeboard inputs / Using a select type input

Using a select type input

Data settings

Since this input creates a drop-down list, it works only with a limited number of possible values. To populate the list with values, click the input title bar and enter the values in the Data source field by clicking Edit. You can populate the Select input list in a couple of ways:

By entering a fixed list of values. Below you can see the syntax you must use to populate the list with different values:
["a", "b", "c", "d"]

Using a query. Below you can see how the query used in the Data source field of the input retrieves the values in the statusCode column.
```
query(
from demo.ecommerce.data
group by statusCode)
```

By default, you can only switch between the different values you have entered. To deselect a value and return to a neutral state, simply click on the drop-down list and hit the Esc key.

Visual settings

Placeholder	Enter a placeholder text to show in the drop-down box by default.
Allow multiple options	Toggle on to have more than one option available to choose from at the same time (value_1 OR value_2, and so on). When you use this option, note that the query that feeds the selector must follow the following format: `where field in $Select0.value` `where field = $Select0.value` is not allowed, since this would not get multiple query values.
Menu always open	Toggle this on to keep the menu options always visible.
Disabled	Toggle on to block the input.
Searchable values	Toggle off to disable the auto-completing option when entering characters in the drop-down box.

Watch the following video to learn how to get the most out of your select type inputs using the different visual settings:

Download as PDF