+ Start a Discussion
arun Bikkasaniarun Bikkasani 

i want check duplaicate using validation rules in salesforce

Best Answer chosen by arun Bikkasani
SoundarSoundar
Hi Arun Bikkasani,

1. validation rules would not be used for the purpose of prevent duplicate records. 
2. https://appexchange.salesforce.com/listingDetail?listingId=a0N30000003IYLlEAO
3. I think this App should be help's to find duplicate.

Try It Once (Free of Cost)

DupeCatcher enables users to identify, block and dedupe leads, accounts, contacts, and person accounts in real-time at the point-of-entry. Retain full control of the identification and merging process, eliminating fear of loss while cleaning data.
Identify duplicate contacts, leads, accounts, and person accounts as they're added in REAL time.
Block duplicate leads, contacts, accounts, and person accounts, and/or merge them with existing records.
Run DupeCatcher in the background to collect data on duplicates for analysis before rolling it out to users.


Regards,

Soundar Raj

All Answers

SoundarSoundar
Hi Arun Bikkasani,

1. validation rules would not be used for the purpose of prevent duplicate records. 
2. https://appexchange.salesforce.com/listingDetail?listingId=a0N30000003IYLlEAO
3. I think this App should be help's to find duplicate.

Try It Once (Free of Cost)

DupeCatcher enables users to identify, block and dedupe leads, accounts, contacts, and person accounts in real-time at the point-of-entry. Retain full control of the identification and merging process, eliminating fear of loss while cleaning data.
Identify duplicate contacts, leads, accounts, and person accounts as they're added in REAL time.
Block duplicate leads, contacts, accounts, and person accounts, and/or merge them with existing records.
Run DupeCatcher in the background to collect data on duplicates for analysis before rolling it out to users.


Regards,

Soundar Raj
This was selected as the best answer
HARSHIL U PARIKHHARSHIL U PARIKH
Do you want to check duplicate Contact? What is the field that makes a record unique besides ID?
Swimming through thecloudSwimming through thecloud
You cannot check the duplicate values with validation rules. However you can do it by creating a new field, Tag it as UNIQUE and create a workflow rule to update this field. If you create a duplicate record which will not be allowed since our new field has been marked as Unique.