+ Start a Discussion

Write Bulk Tigger to find Duplicate values while inserting and updating.


I have fields like S.No and Email. My Requirement is when i try to insert or update the bulk records using data loader, trigger has to check the S.No is already exists when S.No and Email is poulated and display the error message and in same way trigger has to check the S.No is already exists when s.no is populated  and Email is not poulated and display the error message.

Thanks in Advance.
Andy BoettcherAndy Boettcher
Have you tried the Data.com De-Deduplication engine?  It's free with your Enterprise Edition license and does exactly this - either logs the dupe or actively blocks it.
Amit Chaudhary 8Amit Chaudhary 8
Please try below app exchange product. I hope that will help you

Demand tools is very good, and highly recommended:

Or, if you want to try something free you could try Dupecatcher:

Please let us know if this will help you
Thanks for your response.

This App is free of cost or have to pay?
Amit Chaudhary 8Amit Chaudhary 8
Below app is free of cost
Dedupe leads, contacts, accounts (person & business), and web-to-leads