Boolean field

The Baserow boolean field makes it easy to track binary (yes/no, true/false) information with a simple checkbox.

This guide covers what the Baserow boolean field is, why it’s used, and how to add and use it in your tables.

How to add a boolean field in Baserow

Overview

A boolean field is a data type that stores information in a binary true/false format. In Baserow, this is represented by a checkbox. You can click the box to set its value to true (checked) or leave it empty to set the value to false (unchecked).

This field is perfect for any data that has only two possible states. Common examples include:

  • Marking a task as “Done”
  • Tracking if a contact has “Subscribed” to a newsletter
  • Noting if an item is “In Stock”
  • Confirming if a requirement has been “Met”

How to add a boolean field

To add a boolean field to your table:

  1. In your table, add a new field.
  2. Search for and select Boolean from the list.
  3. Name your field (e.g., “Done,” “Subscribed”).
  4. (Optional) You can set a default state. Check the Default value box if you want all new rows to have this field checked (true) by default.
  5. Click Create.

How to use a boolean field

Once added, you can interact with the boolean field in two simple ways:

  • Mouse: Click the checkbox in the cell to toggle it between checked (true) and unchecked (false).
  • Keyboard: Select a boolean cell using your arrow keys and press the Spacebar or Enter key to check or uncheck it.

Learn more: Configure field types

Frequently asked questions

What is a boolean field used for?

A boolean field is used to store any data that has only two opposite states, like yes/no, true/false, or on/off. In Baserow, it’s shown as a checkbox, making it easy to see and update the status of a row.

How is a boolean field different from a single select field?

A boolean field is for binary data only (true/false). A single select field is for data that can have one of several custom options (e.g., “To Do,” “In Progress,” “Done”).

If you only need to track a “yes” or “no” status, the boolean field is faster and more efficient. If you need more than two states, use a single select field.

Can I filter rows using a boolean field?

Yes. You can create a view and filter your rows based on the boolean field. The filter conditions will be “is checked” (true) or “is unchecked” (false). This is very useful for creating views like “Completed Tasks” or “Active Subscribers.”

Related content

Still need help? If you’re looking for something else, please feel free to make recommendations or ask us questions; we’re ready to assist you.