Selecting values from a range of options

All pickers are Form components that cover a range of data types.

In addition, each picker can perform an Action when an item is selected through the On Change event.

This page will summarise the four available pickers within Budibase.

Options and Multi-select pickers

There are three available data sources for dropdown lists in Budibase.

The Options Picker only allows the user to select a single item, whereas the Multi-select Picker allows a user to select many.

Relationship picker

This picker should always be used to handle Relationship fields.

Whilst also a dropdown list, it enforces select one or many options depending on whether the relationship is defined as one or many.
Furthermore, the options will automatically be populated with the rows of the related table.

The label column will match the display column of the related table.
The value column will be the _id of the selected relationship row(s).


Filter by relationships

You cannot filter by relationship when using the Budibase DB.
External SQL data sources, on the other hand, can be filtered by relationship.

Date picker

The Date Picker allows a user to select a Date/Time from a pop-up calendar.