Forum Discussion
- EvanMartinezQuickbase StaffHi 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.- AdamKrzyzanekQrew CaptainDid it, Love it, worked for me:)
Thanks:) - EvanMartinezQuickbase StaffAwesome, I am glad that helped!
- AlexWilkinsonQrew Assistant CaptainAnother 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.
- AdamKrzyzanekQrew CaptainAlex, 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.