+ Start a Discussion
salesforce@14salesforce@14 

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

Hi

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
https://appexchange.salesforce.com/listingDetail?listingId=a0N30000003IYLlEAO
https://appexchange.salesforce.com/category/data-cleansing


Demand tools is very good, and highly recommended:
http://appexchange.salesforce.com/listingDetail?listingId=a0N300000016bXjEAI

Or, if you want to try something free you could try Dupecatcher:
http://appexchange.salesforce.com/listingDetail?listingId=a0N30000003IYLlEAO

Please let us know if this will help you
 
salesforce@14salesforce@14
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
https://appexchange.salesforce.com/listingDetail?listingId=a0N30000003IYLlEAO
Dedupe leads, contacts, accounts (person & business), and web-to-leads