# Update or delete many records at once

> Set field values on many records at once, or delete them, from the Data Builder: pick records in the grid or match them with conditions.

Source: https://tadabase.com/docs/data/update-or-delete-records-in-bulk  
Status: Verified Nov 17, 2026. Checked against the current product

On a table's **Records** tab you can set field values on many records in one go, or delete many records. Work on the records you tick in the grid, or on every record that matches conditions you set.

## Choose which records

| Start from | Which records it changes |
| --- | --- |
| Tick records in the grid, then click **Update** or **Delete** next to **N Selected** | Only the records you ticked. |
| **Batch Operations** at the top of the Records tab, then **Update** or **Delete** | Every record that matches the **Conditions** you add in the dialog. |

> **No conditions means every record:** From **Batch Operations**, if you add no conditions, the update or delete applies to every record in the table. Check the count on the confirm step before you go on.

## Update many records

1. **Open Update Records** Tick the records and click **Update**, or click **Batch Operations** and then **Update**.
2. **Set the conditions** If you started from **Batch Operations**, click **Add New Condition** and choose the field, condition and value that pick the records. If you ticked records, the dialog says how many it is updating instead.
3. **Choose the new values** Under **Values**, choose a field in **Select Field**. Keep **Custom Value** and enter the new value, or choose **Set Blank Value** to empty the field. Click **Add New Value** to change more fields; each field can be picked once.
4. **Check the count** Click **Next**. The confirm step says how many records will be updated.
5. **Update** Click **Update**. When it finishes, the dialog shows how many records were updated.

![The Update Records dialog on the Jobs table, with Conditions, Values and the Bypass Table Rules and Equations and Trigger Immediately switches](https://tadabase.com/docs-shots/data-batch-update-modal.webp)

### Which fields you can set

You can set text, number, currency, email, phone, choice (select, multi-select, checkbox, radio), decision box, rating, slider, date and time, name, address, link and connection fields. For a connection field, choose the connected records to set.

You can't set fields whose values are calculated or uploaded: formula, equation, rollup, auto increment, date range, file, image and signature fields, or system fields such as the record ID.

### Update options

| Option | What it does | Default |
| --- | --- | --- |
| **Bypass Table Rules and Equations** | Skips recalculating the table's equations after the update, which makes large updates faster. Turn it on only if you don't need calculated values to change. (Table rules are the older automation that workflows replace.) | Off |
| **Trigger Immediately** | On: the update runs while you wait. Off: it is queued and runs in the background, which suits large tables; its progress shows on the Records tab. Not shown when you ticked records, which always update right away. | On |

> **What runs after a batch update:** Equations recalculate unless you bypass them. A batch update doesn't run the table's older rules (which workflows replace) and doesn't start workflows. If each record needs its automation, update the records one at a time or use a workflow.

## Delete many records

1. **Open Delete Records** Tick the records and click **Delete**, or click **Batch Operations** and then **Delete**.
2. **Set the conditions** From **Batch Operations**, click **Add New Condition** to choose which records to delete, then click **Next**. If you ticked records, the dialog goes straight to the confirm step.
3. **Confirm** Check how many records will be deleted and click **Delete**.

> **Warning:** Deleted records can't be restored from the Data Builder. Download a backup from **Batch History** (below) if you need the data back.

## See past batch runs

Click **Batch History** at the bottom of the Update Records or Delete Records dialog. It lists the batch runs on the table with their status, number of records, who ran them and when. Click **Download backup** on a run to download the data as it was before that run.

## In your live app

Table components on your pages can let users update or delete many records too, when you turn it on in the component. See [Table component](https://tadabase.com/docs/pages/table-component).
