Skip to main content

Update record action

Change fields of the record that started an automation. Set fixed values, copy record values, calculate new ones, or clear a field, all in a single action.

Written by Leo

Update record is an action that changes fields of the current record, which is the record that started the automation (the trigger decides when the automation runs, and the action decides what happens). It's meant to help you keep records up to date without editing them by hand.

You can use this action for many things, including:

  • Setting a lead's status to "Contacted" after an email goes out.

  • Stamping an expense with the approval date and the approver.

The Update the current record action setting Status, Processed on, and Approver

Note:

  • The action needs a record. Update record works on the current record. It isn't offered after On a scheduled time or interval or When a webhook is received. To change records there, collect them first and use Update collected. Learn more about Update collected →

  • A manual run changes real records. Test with a record you can restore.

  • An update can start other automations. If an automation changes the records it reacts to, it can run in a loop. Turn off Trigger automations in the action menu to prevent that.

Who can use the Update record action?

  • Automations are available on the Free, Plus, and Premium plans. The number of automation actions per month depends on your plan. See the limits for your plan on our pricing page.

  • To add or change this action, you need to be a workspace admin of the workspace the database app is in. You also need full access to every database the automation uses.

Add the Update record action

To update the current record from an automation:

  1. Open the database app and click the automations icon at the top right (Create and view automations).

  2. Open an automation, or select New automation and choose a trigger.

  3. Select Add action → Update record. The step appears as Update the current record.

  4. Open the field dropdown and select the field you want to change.

  5. Choose how the value is set, then enter the value.

  6. Select Add field to change more fields in the same action.

  7. Select Create automation for a new automation, or Save changes for an existing one.

Selecting Add field adds a row, and the field dropdown lists the fields of the database

Update record settings

The action shows one row per field. Each row has three parts, from left to right: the field, how its value is set, and the value itself.

  • Field: open the dropdown to choose any field of the database app. Fields marked with a red asterisk are required in the database.

  • How the value is set: depends on the type of field.

  • Set value is used for text and number fields. Its menu contains Clear value and Calculation.

  • Set option is used for status and single select fields. Open Select an option and pick one of the options under Field options.

  • Set date is used for the date of a date field. Choose Current date to use the date of the run, or Current date & time. You can add or subtract Days, Weeks, or Months, for example Current date + 14 Days.

  • Set time is used for the time of a date field. Choose Current time and add or subtract Hours, or choose Exact time.

  • Set person is used for person fields. Choose a member from the list.

  • Other field types have their own options. For example, a number field also has Lookup, a multiple select field has Set options, Add options, and Remove options, a relation field has Search record, and a file field has Add files and Remove files.

  • Clear value empties the field. Calculation computes the value instead of typing it. Learn more about calculations →

  • Value: type a fixed value, or insert fields of the current record. In the editor, they appear as tags like @Expense / Amount. When the automation runs, Tape replaces each tag with the value from the record.

  • Add field: adds another row. One Update record action with several fields changes them all in a single update.

  • The ••• menu of a row contains Duplicate and Remove.

Action menu

Open the ••• menu next to the action to find Settings, Author, Silent, Trigger automations, Trigger webhooks, Continue on error, Deactivate, Turn into, Duplicate, and Remove. For Update record, these matter most:

  • Author: the person the change is attributed to. Without a choice, it's attributed to the automation itself.

  • Silent: changes the record without notifications.

  • Trigger automations: decides whether the change can start other automations.

  • Trigger webhooks: decides whether the change sends webhooks.

The ••• menu of the Update the current record action with Settings, Author, Silent, Trigger automations, Trigger webhooks, Continue on error, Deactivate, Turn into, Duplicate, and Remove

Let's look at an example

Let's say your finance team wants every approved expense to show who approved it and when. Here's how:

  1. Set the trigger to When a record is updated and select the Status field.

  2. Add the filter Where Status Has changed to "Approved".

  3. Select Add action → Update record.

  4. Select the field Processed on, choose Set date, then choose Current date.

  5. Select Add field, choose Approval note, and use Set value with "Approved by automation".

  6. Select Create automation.

The next time an expense is approved, its approval note and processing date fill in on their own!

Update record errors

  • If the update fails, the run shows the step and its message. Open the automation and select ▷ next to Manual run (View all runs, cmd/ctrl + 1). Each run shows its status, for example Success; select a run to see every step. For all automations, open Runs in the Automation Center and filter by App, Automation, or Status.

  • If a field doesn't change, check that you chose the right field type option, such as Set option for a status.

  • If records keep changing without end, an automation is probably reacting to its own change. Turn off Trigger automations, or narrow the trigger to specific fields. Learn more about runs that loop →

Test, pause, or edit the Update record action

  • Manual run runs the automation once. Under Run on, select the records, then select Save and start run. The records change for real.

  • To stop only this action, select ••• → Deactivate.

  • To change the action, open the automation, select the step, make your changes, then select Save changes.

Learn more

FAQs

Can I update more than one field at once?

Yes! Select Add field to add a row for each field you want to change.

Can I update records in another database app?

No, Update record only changes the record that started the automation. To change linked records, use Update related. To change a group of records, collect them first and use Update collected. Learn more about Update related →

Can I copy a value from another field?

Yes. Insert the field in the value box. Tape replaces the tag with the field's value when the automation runs.

Can I empty a field, such as a file or date field?

Yes. Most field types have their own clear option, for example Clear value for text and Clear date for date fields. To empty a file field, choose Remove files and select All. To copy files from another record, use Add files and insert the file field of that record.

Why didn't my record change?

If the record didn't change, it could be because:

  • The filter didn't match, so the automation stopped before this action.

  • The step failed. Open the automation, select ▷ next to Manual run, and check the Update the current record step.

  • The action is deactivated.

Are there other actions I can use?

Yes! Actions can create and update records, add comments, send emails, create PDFs, call other services, and more. See every action in Automation actions →

Are you a developer using the Tape API for automations?

The automation API has its own documentation for developers. Full reference: current_record_update in the developer docs →

Still have questions? Find answers and get help from community experts in the Tape community →

Did this answer your question?