+ Start a Discussion
goutham k 5goutham k 5 

validation rule issue its not working as expected


(TEXT(Full_Care_Confirmed__c)) == 'Yes'
&&
(
((ISPICKVAL(CPQ_Order_Type__c,'Corporate-Full Care Equipment Domestic'))
||
ISPICKVAL(CPQ_Order_Type__c,'Corporate-Full Care International')
||
ISPICKVAL(CPQ_Order_Type__c,'Corporate-Full Care Demo Equipment Accept')
||
ISPICKVAL(CPQ_Order_Type__c,'Canada-Full Care Equipment')))

IF full care confimed picklist field is set to YES then CPQ_Order_Type__c picklist value should be any of the above
DevADSDevADS
Hey Goutham,

It needs to be as below - 
(TEXT(Full_Care_Confirmed__c)) == 'Yes'
&&
NOT(
((ISPICKVAL(CPQ_Order_Type__c,'Corporate-Full Care Equipment Domestic'))
||
ISPICKVAL(CPQ_Order_Type__c,'Corporate-Full Care International')
||
ISPICKVAL(CPQ_Order_Type__c,'Corporate-Full Care Demo Equipment Accept')
||
ISPICKVAL(CPQ_Order_Type__c,'Canada-Full Care Equipment')))

Happy Coding!
goutham k 5goutham k 5
No luck bro it is throwing error when we select any value from rule.
Abdulla d 5Abdulla d 5
try this goutham,

NOT ((TEXT(Full_Care_Confirmed__c)) == 'Yes'
&&
(
((ISPICKVAL(CPQ_Order_Type__c,'Corporate-Full Care Equipment Domestic'))
||
ISPICKVAL(CPQ_Order_Type__c,'Corporate-Full Care International')
||
ISPICKVAL(CPQ_Order_Type__c,'Corporate-Full Care Demo Equipment Accept')
||
ISPICKVAL(CPQ_Order_Type__c,'Canada-Full Care Equipment'))))