Yet again this has simple validation has me baffled

Aim – If mailing country = Canada, then Canada_Email_Consent__c needs to be captured, if mailing country not equal to Canada then Canada_Email_Consent__c is not applicable

Field Label : Canada Email Consent

Data type : Picklist

Values : Yes/No

Okay First of all I have created the following validation;

Validation rule : Mailing Country

Error Formula:


Second validation i have is

Rule name : Testing_Canada_Email_Consent

Error Formula:

Upper(MailingCountry) = 'CANADA', 

Currently with the rules set up in place, if you type any other country Canada_Email_Consent__c is populated to yes. if mailing country = canada then Canada_Email_Consent__c is required

looking forward to your help

  • Is MailingCountry also a picklist? – Jagular Jun 23 '14 at 15:44
  • @ Jagular - I cant describe it, but when you type a characther it narrows down your search. For eg if i type in U into the mailing country, i get the values, USA,UK, Uganda etc – user8746 Jun 23 '14 at 15:47
  • @user8746 can you paste what you see in your debug log, it should say the validation name and that the rule fails and why it failed – Rao Jun 23 '14 at 16:09
  • @Rao- the rule is not failing. Currently, if the mailing country is not equal to Canada its populating Canada_Email_Consent__c with YES. I want it to say that if mailing country is not Canada, then Canada_Email_Consent__c should not be applicable. if mailing country is Canada, then they should have the choice from "Yes or No" from the field Canada Email Consent – user8746 Jun 23 '14 at 16:13
  • These are validation rules. Is there also a workflow rule affecting the field? – Jagular Jun 23 '14 at 16:35

You need the or condition... OR(AND( Upper(MailingCountry) <> 'CANADA', NOT(ISBLANK(TEXT(Canada_Email_Consent__c))), AND( Upper(MailingCountry) = 'CANADA', ISBLANK(TEXT(Canada_Email_Consent__c)) )

  • hi JJbennett530 thank you for providing a answer, however when i populate mailing country with UK for eg the field "Canada Email Consent" is being populated to yes, when in fact the field shouldnt be populated at all. – user8746 Jun 24 '14 at 8:10
  • A validation rule checks to see if the fields have the correct content, a workflow rule can be set up to populate the field or you could have a dependant picklist or a formula field, that sets the data. You might also check to see if there is a default value for that picklist field. – Jenny B Jun 24 '14 at 12:03
  • jjbennett530 the validation is -- OR(AND( Upper(MailingCountry) <> 'CANADA', NOT(ISBLANK(TEXT(Canada_Email_Consent__c)))), AND( Upper(MailingCountry) = 'CANADA', ISBLANK(TEXT(Canada_Email_Consent__c))) ) and i also had a workflow updating the field whoopsie. Thank you for your assistance – user8746 Jun 24 '14 at 14:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.