So, we have 2 fields on contact and lead:
- Alternate Email
To make sure they are not the same on the record, a simple validation rule is enough.
However, we want to disabled creating other records, but to also check email =/= alternate email.
This is not working, since it always checks the same field to it self.
I want that if a new lead is created, with email@example.com and another lead/contact has firstname.lastname@example.org as an alternate email, the duplicate alert will popup.