Checkbox

  • Updated

The Checkbox data type mceclip1.png is for toggling a true/false state. Sometimes called binary or boolean, the checkbox is a simple yes/no box that is useful for visually showing yes or no and for forms where users can quickly check boxes.

mceclip0.png

Use Checkbox data types to check off effected user types in that bug tracker you built, to track if respondents answered yes or no to questions in your survey, or as a tick box in a sheet you create for your team to vote on lunch.

Converting data to the Checkbox data type

If you already have data in some cells recorded as "true" or "false", Spreadsheet.com can convert that data to the Checkbox data type. In the animation below, we have a sheet with some data already in it, then we set a column to the Checkbox data type and note how the previous data was converted.

Checkbox.gif

Strict

Like other data types, Checkbox data types can have Strict enabled. Selecting the Strict checkbox for Checkbox cells will restrict users to input only true/false statements. Also, columns that have Strict enabled cannot have cells of different data types.

Formatting

Checkbox sizes and colors are fixed, but you can modify the alignment of checkboxes using the alignment settings in the toolbar.

mceclip1.png

The Checkbox data type is only one of the many data types that can be used for custom forms, including the Rating data type, Icon set data type, Select, and Multiselect data types. Check out our Introduction to Data Types article for more ideas on which you can use.