# Create, update and copy records in a workflow

> Use workflow actions to update records, create new or connected records, and duplicate or copy records, and set the values they get.

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

Six workflow actions change your data: **Update Record**, **Update Connected Records**, **Create Record**, **Create Connected Record**, **Duplicate Record** and **Copy Record**. Use them to keep records in step with each other, for example to set a job's status when its invoice is paid.

## Pick the right action

| You want to | Use |
| --- | --- |
| Change fields on the workflow's record, on a record an earlier step found, or on a record in another table | **Update Record** |
| Change fields on the records connected to the workflow's record | **Update Connected Records** |
| Add a record to any table, with no link back | **Create Record** |
| Add a record to a connected table, linked to the workflow's record | **Create Connected Record** |
| Copy a record within its own table | **Duplicate Record** |
| Copy a record into a different table | **Copy Record** |

To find records by filters first, add a **Find Records** step before these. See [Find records and use them in later steps](https://tadabase.com/docs/workflows/find-records-in-a-workflow).

## Set field values

Every action on this page that writes values has a list of mappings, one per field. Once the action knows its table, the list appears under **Set field values** (or **Override field values** for Duplicate Record and Copy Record).

1. **Add a mapping** Click **Add**. A new card appears.
2. **Choose the field** Under **Target Field**, pick the field to write.
3. **Choose where the value comes from** Under **Value Source**, pick a source, for example **Custom Value** for a fixed value, a field of the workflow's record, the current date, or the result of an earlier step under **Step Data**. See [Using workflow data](https://tadabase.com/docs/workflows/using-workflow-data).
4. **For lists, choose how to write** On fields that hold several values, such as connection fields, choose **Replace** to overwrite what the field holds, **Append Value** to add to it, or, where offered, **Remove Value** to take the value out.

When you write to a connection field with a value from elsewhere, **Match by** asks which field of the connected table identifies the record. Choose **Record ID** when the value is already a record ID. Values separated by commas are all looked up, and up to 100 matching records are linked, newest first.

![The Update Record step in the side panel, with Record to update set to Source Record and two field mappings below it](https://tadabase.com/docs-shots/workflows-update-record-mappings.webp)

## Update Record

Under **Record to update**, choose the record:

| Option | Which record |
| --- | --- |
| **Source Record** | The record the workflow is running on. Not offered inside a loop. |
| **Loop Item** | Inside a loop: the record the loop is on now. |
| **Step Data** | The record matched by an earlier **Find Records** step. |
| **Other Tables** | A record in any table, found with **Filters** and **Sort order** you set in the step. The first match is updated. |

With **Other Tables**, a **Batch Update** section appears. Turn on **Update all records** to update every record that matches the filters instead of only the first. The next step then gets only the first updated record.

> **Warning:** A workflow that starts when a record is updated, and updates that same record, can start itself again. Add a condition or a trigger filter so it only runs when it needs to.

## Update Connected Records

1. **Choose the connected table** Under **Connected table**, pick the connection to follow from the workflow's table.
2. **Narrow it down (optional)** Under **Filters**, set which connected records to update. Leave it empty to update all of them.
3. **Set the values** Add mappings under **Set field values**.

## Create Record

Choose the **Target table**, then add mappings under **Set field values**. The new record is not linked to the workflow's record unless you set a connection field yourself.

## Create Connected Record

Choose the **Connected table**, then add mappings under **Set field values**. The new record is linked to the workflow's record through that connection.

Some connections show **Remove existing connections**. Set it to **Yes** to unlink the records that were connected before, so only the new record stays connected.

## Duplicate Record

Duplicate Record creates a new record in the same table, with the values of the record you choose under **Record source** (the source record, the loop item, a record from an earlier step, or a connected record). For a connected record, only the first one is duplicated.

- **Override field values:** add a mapping only for each field that should differ on the copy, for example a status that should start as Draft. Fields you leave out keep the original values.
- **Copy Child Records:** when the table has child tables, this section lists them. Tick a child table to duplicate its records along with the parent, and set override values for them too. This section is not shown when the record source is a connected record.

## Copy Record

1. **Choose what to copy** Under **Record source**, pick the source record, the loop item, a record from an earlier step or a connected record, or open **Copy From Another Table** and pick a table. For another table, set **Filters** and **Sort order** to find the records to copy.
2. **Choose where it goes** Under **Target table**, pick the table to copy into.
3. **Check the matched fields** **Auto-map same name + type** (on by default) copies every field that has the same name and field type in both tables. **Auto-map preview** lists the pairs.
4. **Override values (optional)** Under **Set field values (overrides)**, add mappings for fields that do not auto-map or that should get a different value.

> **Note:** With a connected record as the source, only the first connected record is copied. **Copy From Another Table** copies every matching record, and only the first copy is passed to the next step.

## Use the new or changed record later

The record a step creates or changes is available to the steps after it. In a later step's **Value Source**, open **Step Data** and pick the step. A **Loop / Bulk Action** step can also loop over the records a Copy Record or Update Connected Records step produced.
