How to Check Multiple Boxes in Airtable at Once

To check the same checkbox for several Airtable records, check one cell and use the fill handle to copy it down the column. You can also copy the checked cell, select the other checkbox cells, and paste it into them.

If you only want to update certain records, filter the view first. The records you can see are then the ones you can select and update.

Airtable checkbox field showing multiple boxes checked at once

Check several boxes in a view

  1. Open the table in a grid view.
  2. Add a filter if you only want to update part of the table.
  3. Check one box in the field you want to update.
  4. Select that cell and drag the small square in its lower-right corner down through the other records.

Airtable copies the checked value into the cells you cover. This is the quickest way to mark a filtered group as complete, approved, or ready.

You can use copy and paste instead if that is easier. Copy a checked cell, select the other cells in the same checkbox field, and press Cmd + V on Mac or Ctrl + V on Windows.

To clear several boxes, start with an unchecked cell and use the same fill-handle or copy-and-paste method.

Check or clear records automatically

Use an automation when the same update needs to happen on a schedule or whenever records meet a condition. For example, you could clear a weekly checklist every Monday or check every record that reaches a particular status.

Set up the automation like this:

  1. Open Automations and create an automation.
  2. Choose a trigger, such as At a scheduled time or When a record matches conditions.
  3. Add a Find records action and choose the view or conditions that identify the records.
  4. Add a Repeating group and use the records found in the previous step as its input list.
  5. Inside the repeating group, add Update record. Use the current item's Airtable record ID, then set the checkbox field to checked or unchecked.
  6. Test the steps and turn on the automation.

The Find records action can return up to 1,000 records per run. If the table has more records than that, split the update into batches or use a script to fetch the rest.

When you test the Find records step, Airtable may show only the first 10 records in the preview. That preview does not change the 1,000-record limit for a live run. See why Airtable automations only show 10 records in Find records if the test result looks incomplete.

Add a button for the update

Airtable does not have a check-all button in the grid. If you want someone to start the update with one click, add a button to an Interface and connect it to an automation with the When a button is clicked trigger.

The automation still uses Find records, Repeating group, and Update record. The button only replaces the trigger, so the person can start the bulk update from the Interface instead of checking the boxes manually.