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.
Note:
Add the delete step last, and only after the copy works. Run the automation without
Delete recordfirst 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
Installationswith the fieldsTitle,Customer,Installer notes(all text) andStatus(with the optionCompleted).A database app
Installation archivewith the text fieldsTitle,Customer, andInstaller notes.To build this automation, you need to be a
Workspace adminin the workspace of theInstallationsapp.
Archive a record when it's completed
Open the
Installationsapp and click the automations icon at the top right (Create and view automations).Select
New automation, then selectWhen a record is updated.In the trigger, select the field name. Tape preselects one of the app's fields. Select
StatusunderFIELDS, then select the preselected field again to remove it.Under
And if the following conditions are met, selectAdd filter. PickStatus, thenHas changed to, thenCompleted.Select
Add action→Create record. The step readsCreate a record. Select the appInstallation archive.Select
Add field, pickTitle, then type@inValueand select theTitleof the installation. Repeat forCustomerandInstaller notes.Select
Add action→Delete record. The step readsDelete the current record.Leave
Continue on erroroff in the menu (•••) of both steps. It's off by default, so ifCreate recordfails, the run stops before the record is deleted.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 asArchivedon the original withUpdate record.Archive on a date. Start with
When a date field arriveson aClosed ondate, so records are archived 30 days after closing.Keep a copy of the old values. Add
Get previous valuesfirst, so the archive can hold what the record contained before the last change.Limit who can edit the archive. Open
Installation archiveand selectShare. Select the rowEveryone atwith your workspace's name, and setWorkspace memberstoCan view. Then add the people who maintain the archive inAdd people, groups, or emails…and give themFull access. Learn more about sharing an app →
Learn more
FAQs
Are files copied to the archive?
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?
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?
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?
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 →
