Deleting bulk records with pipeline
I know using a bulk record upsert is a more efficient way to add or modify records using pipelines. Is there a best practice when deleting? Or just use the search function, and then a for each loop? ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIt looks like you use an Advanced Query to define the records to be deleted. You might not want to "blow" the Query Syntax and accidentally zap all your data, so be careful. I imagine that it's super fast to purge the records and much less load on your app than one by one.
https://helpv2.quickbase.com/hc/en-us/articles/4418021154708-Quickbase-August-2021-Release-Notes
Channel enhancement - Remove records in bulk
We have introduced a new step which speeds up the delete process for a large number of records. This can help you out when you're migrating automations.
 |
 |
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
MarkShnier__YouQrew Legend
Qrew LegendBy coincidence I had an opportunity to want to purge child records when a parent was deleted. I used the remove record step and based on the timestamp of the pipeline steps, the pipeline triggered and then one second later 608 children were deleted.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------