I need help writing a validation rule to make specific fields on a custom object required based on met criteria...can one of you awesome people help?

What is the Expected End Result:

a) When Platform = EQC, make ‘EQC Login’ mandatory

  • Platform__c = Picklist
  • EQC_Login__c = Text

b) When Platform = EQC AND Status = ‘Connected’ , make ‘Go Date’ mandatory.

  • Platform__c = Picklist
  • Status__c = Picklist
  • Go_Date__c = Date
  • 1
    Are you looking for a validation rule that has an Error Condition Formula such as: ISPICKVAL(Platform__c, 'EQC') && ISBLANK(EQC_Login__c). When the formula is true display a message telling the user that EQC Login is mandatory?
    – BarCotter
    Aug 25 '15 at 15:43
  • Yes, that is the hope anyways. Wasn't sure if I could keep it all in one rule or if two rules needed to be written.
    – Marina P.
    Aug 25 '15 at 15:52

It sounds like you would need two validation rules

EQC Login validation Rule:

Error Condition Formula:

ISPICKVAL(Platform__c, 'EQC') && ISBLANK(EQC_Login__c)

Error message:

EQC Login is a mandatory field

Go Date validation Rule:

Error Condition Formula:

ISPICKVAL(Platform__c, 'EQC') && ISPICKVAL(Status__c, 'Connected') && ISBLANK(Go_Date__c)

Error message:

Go Date is a mandatory field

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.