Skip to content

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.

Boolean Data Type Prototype

User Experience


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.

Setting Options

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).

Additional Changes

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.