# Add, edit and find records in the Data Builder

> Add and edit records on a table's Records tab, search, filter and sort them, save views, and open a record's history.

Source: https://tadabase.com/docs/data/records  
Status: Verified Nov 17, 2026. Checked against the current product

A record is one row of a data table, such as one job or one customer. On a table's **Records** tab you can add and edit records, search, filter and sort them, and save the filters you use often as views.

## Open the Records tab

In **Data Builder**, click a table, then click the **Records** tab. The records show in a grid with one column per field.

![The Records tab of the Jobs table, with the search box, Hide fields, Row Height, Filters and Sort buttons above the grid of records](https://tadabase.com/docs-shots/data-records-grid.webp)

## Add a record

1. **Open the new record form** On the **Records** tab, click the **Add New** button at the top right. It is named for one record of the table, such as **Add New Job**.
2. **Fill in the fields** Enter a value for each field you need.
3. **Save** Click **Save**. The record is added to the grid.

## Edit or delete a record

- **Change one value in the grid:** click a cell, then click the expand icon that appears in it. Change the value in the editor that opens. Formula, equation, rollup, auto increment and dynamic fields, and system fields, can't be edited this way because their values are calculated.
- **Open the whole record:** click the expand icon at the start of the row (**Edit record**). Change any fields and click **Save**.
- **Delete a record:** open it and click **Delete**.

To change or delete many records at once, tick them in the grid or use **Batch Operations**. See [Update or delete many records at once](https://tadabase.com/docs/data/update-or-delete-records-in-bulk).

## Search, filter and sort

| Control | What it does |
| --- | --- |
| **Search records...** | Type a word and press Enter to show the records that contain it. The refresh button next to it reloads the grid. |
| **Hide fields** | Turn fields off to hide their columns. **Hide All** and **Show All** switch every field at once. |
| **Row Height** | **Short**, **Medium**, **Tall** or **Extra Tall** rows. |
| **Filters** | Click **Add Filter**, choose a field, a condition and a value, then click **Apply**. The button shows how many filters are on. |
| **Sort** | Choose a field to **Sort by**, pick **A → Z** or **Z → A**, add more fields with **Pick another field to sort by**, then click **Apply**. |

You can also click the sort icon in a column header to sort by that column; click it again to reverse the order. Each filter and sort you apply shows as a tag under the toolbar. Click its **×** to remove it, or click **Clear** to remove them all.

## Save a view

A view saves a set of filters and sorts so you can come back to them in one click.

1. **Filter and sort the grid** Apply the filters and sorts you want to keep.
2. **Save it** Click **Save View** under the toolbar, type a name in **Save as** (up to 40 characters) and click **Save**.
3. **Use it** Your views show as tabs above the toolbar. Click one to apply it.

If you save with the name of an existing view, that view is overwritten. With a view open, click **Rename View** to rename it, or to delete it with **Delete**.

## See a record's history

Click the history icon at the start of a row (**Record History**) to see the logged changes to that record. Changes are logged only when **Log Record Changes** is on for the table. See [Track record changes and deleted records](https://tadabase.com/docs/data/record-logs).

## Other buttons on the Records tab

- **Import** and **Export** bring records in from a file and download them. See [Import records from a CSV file](https://tadabase.com/docs/data/importing-from-the-builder).
- The trash icon (**Deleted Records Log**) lists the records deleted from the table while **Log Deleted Records** was on. It shows when your plan includes deleted-record logging.
- The **Show Relation Graph** icon draws this table's connections. See [See how your tables connect](https://tadabase.com/docs/data/table-connection-graph).

## Other ways to add and change records

- Forms on your app's pages. See [Form component](https://tadabase.com/docs/pages/form-component).
- Workflows, which add and update records automatically. They replace the record rules and scheduled tasks older apps used. See [Workflows overview](https://tadabase.com/docs/workflows/workflows-overview).
- Imports from CSV and other files. See [Import records from a CSV file](https://tadabase.com/docs/data/importing-from-the-builder).
- The REST API. See [REST API overview](https://tadabase.com/docs/developers/rest-api-overview).
- Zapier and Make. See [Zapier integration](https://tadabase.com/docs/integrations/zapier-integration).

To let people search records in your live app, add a search to a page. See [Search component](https://tadabase.com/docs/pages/search-component).
