Skip to main content
Question

How can I delete duplicate records if they were all added at the same time?

  • May 22, 2019
  • 0 replies
  • 164 views

Forum|alt.badge.img+1
Eliminate accidental duplicate records.
This topic has been closed for replies.

How exactly do you know they are duplicates after the fact? Ideally - you would want to try and stop the original entry from happening - so think about unique fields so users can't create dupes in the first place. Are these being entered via grid edit or import? 

If setting up a unique field to stop the entry isn't an option - you'll need a way to actually identify systematically which ones are dupes before you can look into deleting them. 


Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base

You can do a summary report by date created and there will be a block of records all added at the same date and time. (Summary on equal values), then drill down to explode open the detail and use the "More ..." button to delete.

Forum|alt.badge.img+1
  • Author
  • Registered
  • May 22, 2019
HI;

I don't understand what the More button is.   Also, I added on the same date.  Can you give more details - I am not that savy.  Thank you very much!!

No problem,

Make your summary report like i described above.
Locate the block of record which were all added at the same date/time.
Drill into that block on the summary report to open up all those individual records.

Then mass delete the record either by using the checkbox at the left of each record (there is a master checkbox at the top of the checkboxes to check all) and then delete, or easier if there are many record is to locate the "More .." button at the the top right of the report and it will let you delete all the records on the report.