This question is a tribute to the law of unintended consequences. There is a webhook in table 1 that will create a new record in a table 2 in a different app when a new record is added to the to table 1 and a checkbox is checked. That had been working ok for the new records that were initially imported with the checkbox checked. However, the source data for the import is not always accurate and the checkbox is not checked. The webhook was modified to fire when a record was added or modified and there a check was added to the checkbox. That seemed to make sense, but it created duplicate records every day when the data was uploaded (I should mention, table 1 currently has a manual update every morning that includes all previous records plus any new records that were added the previous day). After two weeks, there are over 125k duplicate records. Is there way to remove the duplicate records without resorting to brute force manual deletion of the duplicates?
------------------------------
Paul Peterson
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.