Skip to main content

Delete and restore record actions

Delete the record that started an automation, or restore a deleted record. Both actions work without settings, and you choose who the change is attributed to.

Written by Leo

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.

The action Delete the current record in the automation editor

Note:

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

  • Delete works best as the last step. Put Delete record at 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 interval or When 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 admin of 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:

  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 → Delete record. The step appears as Delete the current record.

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

Adding the Delete record action in an Expenses automation: Add action, searching Delete rec, and selecting Delete record. The step Delete the current record appears

The action has no fields to fill in.

Add the Restore record action

To restore 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 → Restore record. The step appears as Restore the current record.

  4. Select Create automation for a new automation, or Save changes for 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.

A new automation for Expenses with the trigger When a record is deleted and the action Restore the current record

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 under Author. If you choose a person for Delete record, the deleted record goes to that person's Trash, where they can restore it. Without an author, the record doesn't appear in anyone's Trash.

  • Silent: deletes or restores the record without notifications.

  • Trigger automations: decides whether the change can start other automations, such as one that reacts to When 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:

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

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

  3. Select Add action → Create record and create a copy in the Sold listings database.

  4. Select Add action → Delete record.

  5. 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 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.

  • Actions run one after another, so Delete record can follow other actions on the same record, for example Update record. You don't need Delay execution before it.

  • Delete record doesn't check the rights of the person under Author. 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 run runs the automation once. Under Run on, select the records, then select Save 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?

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?

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?

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?

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?

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?

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_delete in the developer docs →

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

Did this answer your question?