Boolean Data Type¶
Boolean data types are used to store TRUE or FALSE values.
This prototype might be outdated due to global component updates. Please refer to the link under ‘Setting Options’ for an updated version of the shared components.
User sets a column to ‘Boolean’ data type¶
The user can set the column data type to ‘Boolean’ by accessing the ‘Data Type Options’ in the columns header menu. Whether there are existing values or not, the outcomes will vary if they are valid boolean values. If there are valid URL values, the system will convert them to boolean types. There are only two boolean values. They are True and False. However, we might map existing values or integers as equivalents to true and false, for example, ‘yes and no’ or ‘0 and 1’.
If there are no valid boolean values, the system will prevent the change from being made.
The following is an interactive representation of the various options that users can set for this type: Boolean Type Options
User enters a new ‘Boolean’ data type value¶
Depending on the configuration, the user will enter a ‘Boolean’ value with two different controls.
- Default Dropdown (TRUE, FALSE)
- Custom Dropdown (TRUE Custom Value, FALSE Custom Value)
- Checkbox (Checked, Unchecked)
User filters a ‘Boolean’ data type column¶
Users can filter ‘Boolean’ data type columns by basic equality operators (is, is not) and whether the value is empty.
User groups a ‘Boolean’ data type column¶
Users can group ‘boolean’ data types columns simply by adding them to the group columns list. The function will create a group for each boolean value (TRUE, FALSE).
Disable Unique Constraint for Certain Data Types¶
The user won’t be able to disallow duplicate values for a ‘Boolean’ type column. The setting should appear disabled under the column header menu.