Forum Discussion

AdamKrzyzanek's avatar
AdamKrzyzanek
Qrew Captain
6 years ago

[Automation] Backup - Move to other table when delete

I would like to make backup repository while somebody remove records.
I imagined that I will use Automation for it. I created copy of my table (backup table) and want that When a user deletes a record --> Copy to Backup table.
Tried but something wrong with rule I created.
Any help or other solution?

5 Replies

  • Hi Adam,

    In the past when I have created an Automation to copy deleted records over to a backup table I didn't use the Copy option I instead set it to Add a record and then based it on the fields of the record being deleted. This way it transferred that data over. The copy action is going to instead once triggered grab a set of matching records that exists somewhere based on your criteria and copy them. If you are trying to target the deleted record by the time the copy runs I believe the source record you are looking for would already be gone. I would suggest trying the version to instead Add a record and then picking out the fields you want to copy over from another record. 

  • AlexWilkinson's avatar
    AlexWilkinson
    Qrew Assistant Captain
    Another option: Don't give your users permission to delete records. Instead allow them to edit a checkbox called "Please Delete". When an automation detects that this box is checked, first copy the record to another table, then delete the original record.
    • AdamKrzyzanek's avatar
      AdamKrzyzanek
      Qrew Captain
      Alex, indeed it would work as well but, I believe, my problem was that I wanted to Copy instead of add. It looked for same Record ID which were not existing in second table. Now it will add it as separate record.