You need to sign in to do that
Don't have an account?
harry63
deduplication account
hi all
i am trying to write dedupliaction trigger on account based on account name and billingcity.can anyone give trigger code. issue:if any user try to enter same account name and city it should generate an error.
thanks in advance
You can use external id + workflow-field update ( account name + billing city);
So no trigger is needed.
Cheers,
hi rhi thanks for replying me..if you dontmind could you post the sollution...
Well, let me try to show you:
The idea is just to copy account name and city to the unique field. If unique field gets the same account + city,... this is what you want, right ?
- Create a text field on account and mark it as Unique
- Create a workflow rule:
+ Rule = OR(ISCHANGED( Name ) , ISCHANGED( BillingCity ))
+ Evaluation Criteria = Every time a record is created or edited
- Create a workflow action as field update.
+ choose your new unique field
+ Formula = Name + City
So unique field will not allow you to input the same value.
Hope this help.
Cheers,