The select box widget lets the dashboard reader make a selection from a dropdown list. The choices in the dropdown can be text, numbers or dates. The select box can be used as a filter for other widgets, similar to the date picker.
In the sidebar
General: use the general properties of the sidebar to add a name for your select box and adjust the widget’s appearance.
Instructions: here you can add content which will appear below the title of the widget. This can include text, images, tables, links and other common content tools.
Options: the options available in a select box are typically populated from a field in a data source (or you can add them yourself as custom options). Often, you might populate the select box widget with a text string such as the About field of an event form, allowing the user to pick a single athlete and then view data about that athlete in the other widgets. Alternatively, you can use text strings, numbers or dates from any other field in the event form you’re using as your data source. Make sure you specify the correct options data type based on the data you’re displaying.
Use the data filters button to add filters which limit what values are available in your select box, based on other filter widgets (select boxes and date pickers) in your dashboard or custom filters applied directly to the select box.
You can also specify how you’d like the select box to order the available options. You can elect to order options by:
Value: will order based on the alphanumeric value of the option (regardless of whether the options are strings, numbers or dates).
Date of first occurrence: will order based on the first occurrence of each option. This will identify the date of the oldest record where each option occurred, and assign the order based on these dates.
Date of last occurrence: will order based on the last occurrence of each option. This will identify the date of the newest record where each option occurred, and assign the order based on these dates.
Based on the order of the options you select, you can also change the order direction to be ascending or descending.
In addition to this, you can choose whether or not you’d like the select box to reset options on data change. This will only have an impact if your select box is has any filtering (from other select box or date picker widgets, or as custom filters). If this setting is turned on, your select box will reset to the first option in the list if the data changes, even if the previously selected option is still available based on any filtering applied.
Selection settings: this section gives you access to several settings which allow you to enable multiple selections in the widget, allow for an empty selection, and set a default selection.
Advanced properties: in the advanced properties section, you can choose whether to enable search. This allows the user to type in the select box field to find the option they’re looking for.