You need to sign in to do that
Don't have an account?
Alli I
Lead Validation Formulas: new to it all...
Hi,
New to formula's and I need to create 2 validation rules...
1.) That will not allow duplicate leads to be registered
2.) If Company & Email & Last Name are null do not register as a lead.
Any advice?
Blocking duplicates is not something you can do with a validation rule because a VR only checks the fields of a record being created or edited and doesn't compare it to other existing records. There are Apex triggers out there that handle de-duping that you can customize to fit, as well as AppExchange utilities you can download.
Your second item is easier to manage. Just substitute your field names, then if any of them are blank the error will be displayed. To see this and other examples, click new validation rule on any object, then click on "more examples".