• Jennifer Thomas
  • NEWBIE
  • 10 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 3
    Questions
  • 1
    Replies
Hello, 

I'm am struggling with a Vaildation Rule and really need some help! Please!  No syntax issues, it just doesn't work the way I need it to.
When I go to test the rule, if I select a from the picklist a single field System__c, "Axis360"), the rule fires and requires me to enter a value on 3 customer fields Device__c, Browser__c and Format_Reader__c. 

I'm not sure how to fix this. Hope this makes sense to someone.  Thanks in advance for any assistance


(ISBLANK(TEXT( Device__c ))) ||
(ISBLANK(TEXT( Browser__c ))) ||
(ISBLANK(TEXT( Format_Reader__c ))) ||

(ISPICKVAL ( System__c, "Axis360") &&
ISPICKVAL(Status, "Closed")) &&


ISPICKVAL( Case_Type_PS__c ,"Issue Axis 360") &&

( ( ISPICKVAL(Case_Sub_Type__c , "Error Message") &&
( ISPICKVAL (CS_Category__c,"Initial Setup") ||
ISPICKVAL (CS_Category__c,"Account/Profile") ||
ISPICKVAL (CS_Category__c,"Ordering") ||
ISPICKVAL (CS_Category__c,"Login/Password") ||
( ISPICKVAL (CS_Category__c,"Magic Wall") &&
( ISPICKVAL(CS_Subcategory__c , "Using & Viewing Titles") ||
ISPICKVAL(CS_Subcategory__c , "Checkout") ||
ISPICKVAL(CS_Subcategory__c , "Download") ||
ISPICKVAL(CS_Subcategory__c , "Returns")
)
)
)
) ||

( ISPICKVAL(Case_Sub_Type__c , "Error-Failed") &&
( ISPICKVAL (CS_Category__c,"Initial Setup") ||
ISPICKVAL (CS_Category__c,"Account/Profile") ||
ISPICKVAL (CS_Category__c,"Ordering") ||
ISPICKVAL (CS_Category__c,"Login/Password") ||
( ISPICKVAL (CS_Category__c,"Magic Wall") &&
( ISPICKVAL(CS_Subcategory__c , "Using & Viewing Titles") ||
ISPICKVAL(CS_Subcategory__c , "Checkout") ||
ISPICKVAL(CS_Subcategory__c , "Download") ||
ISPICKVAL(CS_Subcategory__c , "Returns")
)
)
)
) ||

( ( ISPICKVAL (Case_Sub_Type__c , "Title Not on Patron Bookshelf") ||
ISPICKVAL (Case_Sub_Type__c , "Unable to Open/Play") ||
ISPICKVAL (Case_Sub_Type__c , "Compatibility") ) &&
( ISPICKVAL (CS_Category__c,"Magic Wall") &&
( ISPICKVAL(CS_Subcategory__c , "Using & Viewing Titles") ||
ISPICKVAL(CS_Subcategory__c , "Checkout") ||
ISPICKVAL(CS_Subcategory__c , "Download") ||
ISPICKVAL(CS_Subcategory__c , "Returns")
)
)
)
)
Hello, 

I'm am struggling with a Vaildation Rule and really need some help! Please!  No syntax issues, it just doesn't work the way I need it to.
When I go to test the rule, if I select a from the picklist a single field System__c, "Axis360"), the rule fires and requires me to enter a value on 3 customer fields Device__c, Browser__c and Format_Reader__c. 

I'm not sure how to fix this. Hope this makes sense to someone.  Thanks in advance for any assistance


(ISBLANK(TEXT( Device__c ))) ||
(ISBLANK(TEXT( Browser__c ))) ||
(ISBLANK(TEXT( Format_Reader__c ))) ||

(ISPICKVAL ( System__c, "Axis360") &&
ISPICKVAL(Status, "Closed")) &&


ISPICKVAL( Case_Type_PS__c ,"Issue Axis 360") &&

( ( ISPICKVAL(Case_Sub_Type__c , "Error Message") &&
( ISPICKVAL (CS_Category__c,"Initial Setup") ||
ISPICKVAL (CS_Category__c,"Account/Profile") ||
ISPICKVAL (CS_Category__c,"Ordering") ||
ISPICKVAL (CS_Category__c,"Login/Password") ||
( ISPICKVAL (CS_Category__c,"Magic Wall") &&
( ISPICKVAL(CS_Subcategory__c , "Using & Viewing Titles") ||
ISPICKVAL(CS_Subcategory__c , "Checkout") ||
ISPICKVAL(CS_Subcategory__c , "Download") ||
ISPICKVAL(CS_Subcategory__c , "Returns")
)
)
)
) ||

( ISPICKVAL(Case_Sub_Type__c , "Error-Failed") &&
( ISPICKVAL (CS_Category__c,"Initial Setup") ||
ISPICKVAL (CS_Category__c,"Account/Profile") ||
ISPICKVAL (CS_Category__c,"Ordering") ||
ISPICKVAL (CS_Category__c,"Login/Password") ||
( ISPICKVAL (CS_Category__c,"Magic Wall") &&
( ISPICKVAL(CS_Subcategory__c , "Using & Viewing Titles") ||
ISPICKVAL(CS_Subcategory__c , "Checkout") ||
ISPICKVAL(CS_Subcategory__c , "Download") ||
ISPICKVAL(CS_Subcategory__c , "Returns")
)
)
)
) ||

( ( ISPICKVAL (Case_Sub_Type__c , "Title Not on Patron Bookshelf") ||
ISPICKVAL (Case_Sub_Type__c , "Unable to Open/Play") ||
ISPICKVAL (Case_Sub_Type__c , "Compatibility") ) &&
( ISPICKVAL (CS_Category__c,"Magic Wall") &&
( ISPICKVAL(CS_Subcategory__c , "Using & Viewing Titles") ||
ISPICKVAL(CS_Subcategory__c , "Checkout") ||
ISPICKVAL(CS_Subcategory__c , "Download") ||
ISPICKVAL(CS_Subcategory__c , "Returns")
)
)
)
)