You need to sign in to do that
Don't have an account?
sunnysfdcdvp
trigger that compare old value with new value
HI Everyone
plz check my requirement
In contact two fields are there one is mobile and another is phone
i need to avoid duplicate values in the both fields
ex :let us take in first record i enter moblie=909090 and phone=808080
when i am entering second record mobile=808080 and phone=909090(here i want through an error that moile number or phone is already exhists with another record)
thanks in advance
Try this trigger. It will work for you.
All Answers
Try this trigger. It will work for you.
Hi,
I think you can make both the fields as unique so that the same phone number and mobile number will not be entered again.
If you found this answer as a solution, Please give kudos by clicking on the star icon and mark it as a solution
Thanks!!!!
U Did a great job its working
Thanks master!!!!