Deleting using an Automation is not practical for high record counts unless high means less that 1,000 and its in the middle of the night. They delete at a slow rate of about 5 per second at most. So deleting 1,000 records would take 13 minutes. If a user is expecting a report to be empty after a button push, then that is too slow.
We have an additional tool now in Piplines. We still cannot deleted a single record at a time as it would probably be too slow, but more importantly we ned to think about Step Runs. No sense to blow 1,000 step run on deleting one by one.
So I would have the Pipeline call a webhook which would use the API Purge records API. I would probably make a relationship between the old and new table so I'm 100% sure that I'm not deleting records which were not successfully copied across.
I would also make a nice clean checkbox field in Base called [OK to Purge], and then allow any logic in the pipelin to be as stupid simple as possible.
So yes it does mean the need now to learn Pipelines. I have just started to use them successfully in the last 2-3 weeks, including for two real customer situations to send timed, mid-day emails., so not just practice., Fortunately there are some session at next week's EMPOWER on Pipelines "101 and 201", ie "intro to" and then a bit more advanced.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
