The batch update block is part of Airtable Blocks, a Pro plan feature. Blocks let you extend the functionality of your bases: you can use blocks to bring new information into Airtable, visualize and summarize your records in colorful ways, and even directly integrate your Airtable bases with your favorite apps.
The batch update block allows you to specify multiple actions to update all the records in a view.
Watch this video to learn more about how to set up and use a batch update block, or read on for further information.
When you first install a batch update block, it'll automatically open the new block's settings page. From the settings, you can select the desired table and view you wish to update.
To add an update action, click the Add action button.
Then, select the field whose values you want to update, and set the update action to be performed on the field.
You can specify a number of different types of actions with the batch update. Here are a few examples:
- With multiple select and multiple collaborator fields, you can sort the values as they appear in the cells.
- You can also add or remove select options or collaborators.
- With numeric fields, you can increment or decrement all values.
- You can also increment or decrement values in date fields.
Once you've set up the action, click the Done button.
If you want, you can line up multiple actions in a single batch update block. Just click the Add action button again to add more update actions. To remove an action, click on that action, then click on the Remove action button.
Once you're done configuring the actions, you can click the Update records button. If you change your mind right after clicking, you can also click the Undo button.
For any batch update block that's already been configured, you can use the update records button again to repeat the batch update process. This is great for repeated workflows, like approving every item in a view or re-sorting select options.