Apex Code Development You need to sign in to do that
Don't have an account?
Salesforce#### trigger to eliminate duplicate name and phone number and email in account
how to eliminate duplicates name and phone number and email using soql query in a single trigger while creating accounts ???
alternate approach is also fine other than filering in soql
alternate approach is also fine other than filering in soql
Deleting or merging your duplicate accounts? There are the problem of the existing duplicates and the check for the future creations that prevents duplicates.
1) The check for the future creations that prevents duplicates is easy with a trigger (just read the account with the same name or phone number or email with "before insert, before update" and generate an addError like here: https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_classes_pattern_and_matcher_example.htm ).
2) For the existing duplicates, it is more complex if you don't use the pre-existing powerful screens of Salesforce for individual merges manually based on lists sent to the owners of the accounts.
The owners of the accounts will decide what they want to keep account by account and field by field.
Alain