Skip to main content

Archive completed records

Copy finished records into an archive database app when their status changes to Completed, then remove the original so your working database stays short.

Written by Leo

Finished work clutters the views people use every day. This recipe moves it out of the way. When a record reaches its final status, Tape creates a copy in an archive database app and, if you want, deletes the original.

The automation Archive completed installations: When a record is updated and Status has changed in Installations, the filter Status Has changed to Completed, Create a record in Installation archive with Title, Customer, and Installer notes, and Delete the current record.

Note:

  • Add the delete step last, and only after the copy works. Run the automation without Delete record first and check the archive.

  • Copy every value you need. The new record only gets the fields you add to Create record.

What you'll need

  • A database app Installations with the fields Title, Customer, Installer notes (all text) and Status (with the option Completed).

  • A database app Installation archive with the text fields Title, Customer, and Installer notes.

  • To build this automation, you need to be a Workspace admin in the workspace of the Installations app.

Archive a record when it's completed

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

  2. Select New automation, then select When a record is updated.

  3. In the trigger, select the field name. Tape preselects one of the app's fields. Select Status under FIELDS, then select the preselected field again to remove it.

  4. Under And if the following conditions are met, select Add filter. Pick Status, then Has changed to, then Completed.

  5. Select Add action → Create record. The step reads Create a record. Select the app Installation archive.

  6. Select Add field, pick Title, then type @ in Value and select the Title of the installation. Repeat for Customer and Installer notes.

  7. Select Add action → Delete record. The step reads Delete the current record.

  8. Leave Continue on error off in the menu (•••) of both steps. It's off by default, so if Create record fails, the run stops before the record is deleted.

  9. Select Create automation.

The result

When an installation's Status changes to Completed, a copy appears in Installation archive and the original disappears from Installations. Open the automation's Runs to see both steps. If Create record fails, the run stops before the delete step, and the original stays.

Variations

  • Keep the original. Leave out Delete record. Instead, set a field such as Archived on the original with Update record.

  • Archive on a date. Start with When a date field arrives on a Closed on date, so records are archived 30 days after closing.

  • Keep a copy of the old values. Add Get previous values first, so the archive can hold what the record contained before the last change.

  • Limit who can edit the archive. Open Installation archive and select Share. Select the row Everyone at with your workspace's name, and set Workspace members to Can view. Then add the people who maintain the archive in Add people, groups, or emails… and give them Full access. Learn more about sharing an app →

Learn more

FAQs

Are files copied to the archive?

Not automatically. Only the fields you add to Create record are copied. To take files along, add the file field to Create record, select Add files, and insert the file field of the original record.

Can I get a deleted record back?

Yes, with Restore record in an automation. A record that the automation deletes only shows up in a Trash if you chose a person under Author in the menu of Delete record. It then lands in that person's Trash, where they can click the restore icon next to it. Learn more about restoring records → The archive copy stays either way, so you keep the values.

Will the new archive record start other automations?

Not by default. Trigger automations in the menu of Create record is off, so automations on the archive database don't run. Turn it on if they should.

Are you a developer using the Tape API for automations?

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

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

Did this answer your question?