BMCServiceDesk__Queue__c = The Queue

BMCServiceDesk__FKOpenBy__c = The Staff


A. I'm trying to make it where, it does not allow Staff assignment without Queue assignment.

This works for that:

ISBlank(BMCServiceDesk__Queue__c ) && 
NOT(ISBLANK( BMCServiceDesk__FKOpenBy__c))

enter image description here enter image description here

B. But they also want... To be able to save it if No Queue Or Staff is assigned... & "A." prohibits that.:

enter image description here enter image description here

So I built this (instead), but it's not working because it's overriding "A." (Same Validation Rule, Different Syntax)

ISBlank(BMCServiceDesk__Queue__c ) && 
NOT(ISBLANK( BMCServiceDesk__FKOpenBy__c)
ISBLANK(BMCServiceDesk__Queue__c ) &&

What am I doing wrong and/or is this even possible?

  • Will, You explain your scenario briefly. In both cases what they are trying to do. – Pavan tej Oct 11 '18 at 14:07

You don't need a second rule. If queue is blank and staff is blank, then rule A won't trigger. In either case, your second version is wrong because validation rules trigger when the result is true, which it would be queue and staff are both blank. There's really no need to specify this as a rule.

  • Rule A, causes the error if both Staff and Queue are blank. – Tim Oct 11 '18 at 11:55
  • @Tim It shouldn't; it's likely you're doing something wrong. It will only fire exactly when queue is blank and staff is not. – sfdcfox Oct 11 '18 at 12:05

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.