Delete record and Restore record are actions that remove the current record or bring it back (the trigger decides when the automation runs, and the action decides what happens). They're meant to help you tidy up records, for example after you've copied them somewhere else.
You can use these actions for many things, including:
Deleting a task from a working database app after a copy was saved in an archive database.
Bringing a record back in the same run when a later check fails.
Restoring a record right after someone deleted it, with the trigger
When a record is deleted.
Note:
A manual run deletes real records. Test with a record you can restore.
Delete works best as the last step. Put
Delete recordat the end of an automation, after the actions that still need the record.These actions need a record. They work on the current record and aren't offered after
On a scheduled time or intervalorWhen a webhook is received.
Who can use the Delete record and Restore record actions?
Automations are available on all plans: Free, Plus, and Premium. 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 these actions, you need to be a
Workspace adminof the workspace the database app is in. App permissions alone aren't enough.
Add the Delete record action
To delete 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→Delete record. The step appears asDelete the current record.Select
Create automationfor a new automation, orSave changesfor an existing one.
The action has no fields to fill in.
Add the Restore record action
To restore 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→Restore record. The step appears asRestore the current record.Select
Create automationfor a new automation, orSave changesfor an existing one.
The action has no fields to fill in either. It restores the current record if it's deleted, no matter who deleted it. Use it with the trigger When a record is deleted to bring a record back, or after Delete record in the same run, for example inside Conditional actions.
Delete record and Restore record settings
Open the ••• menu next to either action to find Settings, Author, Silent, Trigger automations, Trigger webhooks, Continue on error, Deactivate, Turn into, Duplicate, and Remove. These matter most:
Author: the person the change is attributed to. Without a choice, it's attributed to the automation itself. Both actions don't check the rights of the person underAuthor. If you choose a person forDelete record, the deleted record goes to that person'sTrash, where they can restore it. Without an author, the record doesn't appear in anyone'sTrash.Silent: deletes or restores the record without notifications.Trigger automations: decides whether the change can start other automations, such as one that reacts toWhen a record is deleted.Trigger webhooks: decides whether the change sends webhooks.
Silent, Trigger automations, and Trigger webhooks are off when you add the action.
Let's look at an example
Let's say your property team keeps open listings in one database app and sold listings in an archive database. Here's how to move a listing:
Set the trigger to
When a record is updatedand select theStatusfield.Add the filter
WhereStatusHas changed to"Sold".Select
Add action→Create recordand create a copy in theSold listingsdatabase.Select
Add action→Delete record.Select
Create automation.
The next time a listing is marked "Sold", it appears in the archive and disappears from the open listings.
Delete record and Restore record errors
If a step 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.Actions run one after another, so
Delete recordcan follow other actions on the same record, for exampleUpdate record. You don't needDelay executionbefore it.Delete recorddoesn't check the rights of the person underAuthor. The automation itself needs access to the record, so choosing another author doesn't fix a failed delete.
Test, pause, or edit these actions
Manual runruns the automation once. UnderRun on, select the records, then selectSave and start run. Records are deleted for real.To stop only one action, select
•••→Deactivate.To change an action, open the automation, select the step, make your changes, then select
Save changes.
Learn more
FAQs
Can I delete a record in another database app?
Can I delete a record in another database app?
No, not directly. Delete record only deletes the record that started the automation. To delete records in another database, collect them, then use Call automation on collected to call an automation in their database that runs Delete record.
Can I delete a record permanently?
Can I delete a record permanently?
No, Delete record doesn't delete for good. If you choose a person under Author, the record goes to that person's Trash, where they can restore it. Without an author, it doesn't appear in anyone's Trash, but Restore record can still bring it back.
Can I delete many records at once?
Can I delete many records at once?
No, not with one action. Delete record deletes one record, the record that started the automation. To clean up a group, collect them, then use Call automation on collected to call an automation that runs Delete record on each record. Learn more about Call automation →
Can I wait before a record is deleted?
Can I wait before a record is deleted?
Yes! Add Delay execution before Delete record. It waits 15, 30, 45, or 60 seconds. Learn more about Delay execution →
Can I get a deleted record back?
Can I get a deleted record back?
Yes. If you chose a person under Author, that person can restore it from their Trash. An automation with the trigger When a record is deleted can also restore it with Restore record, and Restore record can bring back a record that Delete record deleted earlier in the same run.
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_delete in the developer docs →
Still have questions? Find answers and get help from community experts in the Tape community →
