In Budibase, there are two data types that allow a value to be set from a list of options.
The first is the Options type, which is compatible with the Text data type, and only allows a single option to be chosen.
The Multi-select type is similar to the options type, but it allows you to select multiple options, and is not convertible to any other type. You can still select a single option or none at all.
When a multi-select value is saved to a data table, the values will be presented in individual coloured pills:
A number of array based filters are available when using a multi-select.
The multi-select value must contain all of the selected comparison options.
The multi-select value must not contain all of the selected comparison options.
Note that in this case only rows that have both Senior AND Manager are filtered out.
The multi-select value contains any of the selected comparison options.
Updated 3 months ago