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.
Note:
The action needs a record.
Update recordworks on the current record. It isn't offered afterOn a scheduled time or intervalorWhen a webhook is received. To change records there, collect them first and useUpdate 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 automationsin 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:
Open the database app and click the automations icon at the top right (
Create and view automations).Open an automation, or select
New automationand choose a trigger.Select
Add action→Update record. The step appears asUpdate the current record.Open the field dropdown and select the field you want to change.
Choose how the value is set, then enter the value.
Select
Add fieldto change more fields in the same action.Select
Create automationfor a new automation, orSave changesfor an existing one.
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 valueis used for text and number fields. Its menu containsClear valueandCalculation.Set optionis used for status and single select fields. OpenSelect an optionand pick one of the options underField options.Set dateis used for the date of a date field. ChooseCurrent dateto use the date of the run, orCurrent date & time. You can add or subtractDays,Weeks, orMonths, for exampleCurrent date+ 14Days.Set timeis used for the time of a date field. ChooseCurrent timeand add or subtractHours, or chooseExact time.Set personis 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 hasSet options,Add options, andRemove options, a relation field hasSearch record, and a file field hasAdd filesandRemove files.Clear valueempties the field.Calculationcomputes 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. OneUpdate recordaction with several fields changes them all in a single update.The
•••menu of a row containsDuplicateandRemove.
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.
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:
Set the trigger to
When a record is updatedand select theStatusfield.Add the filter
WhereStatusHas changed to"Approved".Select
Add action→Update record.Select the field
Processed on, chooseSet date, then chooseCurrent date.Select
Add field, chooseApproval note, and useSet valuewith "Approved by automation".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 toManual run(View all runs,cmd/ctrl+1). Each run shows its status, for exampleSuccess; select a run to see every step. For all automations, openRunsin the Automation Center and filter byApp,Automation, orStatus.If a field doesn't change, check that you chose the right field type option, such as
Set optionfor 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 runruns the automation once. UnderRun on, select the records, then selectSave 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?
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?
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?
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?
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?
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 toManual run, and check theUpdate the current recordstep.The action is deactivated.
Are there other actions I can use?
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?
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 →
