How to Check All Boxes in Airtable at Once

You’re working in Airtable and you’ve got a checkbox field in your table.

Sometimes, you need to quickly check all the boxes at once.

There are plenty of situations where this comes up.

For example, you might filter your table to show only agents of a certain type, and then you want to check all the boxes for just those filtered records.

Or maybe you’ve typed in a keyword, narrowed the list down, and now you want to mark every single one of them at once.

In other words, the use cases vary but the need is the same. You want to mark checkboxes in bulk without having to click one by one.

The problem is that Airtable doesn’t give you a native way to apply a checkbox change across multiple records in one go.

If you’ve got hundreds of rows, clicking each box manually is time-consuming and error-prone.

So is there a way to do this faster?

Yes. There are a couple of approaches you can take.

1. Copy and paste a checked value

You can do this quickly without an automation.

What you need to do is click on any record in the table and check the box so it becomes ticked. Then copy that single cell.

Next, select all the other cells in the checkbox field where you want the box to be ticked. You can drag through the column to highlight them.

Once they are selected, paste the value with Ctrl+V or Cmd+V.

All of the selected checkboxes will instantly become checked. That’s it.

The nice thing about this approach is that it also works with filters. If your view is showing only certain records, you can paste into those without affecting anything hidden.

2. Use an automation to check boxes

If there is a set of records you need to update regularly, you can make this automatic with an Airtable automation.

What you could do is set up the automation and then connect it to a button in your table or in an interface. That way, instead of copy-pasting every time, you just press the button and all the checkboxes get ticked in one go.

Here is how the setup works:

• Add a “Find records” step along any conditions you want, so that the automation only finds the exact records you want to check.

• Pass those records into a repeating group.

• Inside the repeating group, add an “Update record” action that sets the checkbox to checked for each record in the list.

Once you set it up, the automation will loop through all the filtered records and check the boxes automatically.

The copy-paste method is quick and easy for one-off updates. Automation works better if you need to repeat the process regularly.

Either way, you’ll save yourself from the tedious work of clicking through each checkbox individually.