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 ) &&
ISBLANK(BMCServiceDesk__FKOpenBy__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 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 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 at 12:05

Your Answer

 
discard

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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