Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
kevin.chileskevin.chiles 

Assistance with Validation Rule

Normaly my posts on here are quite challenging.  Todays might be just me not thinking this through enough.  I am trying to force a field to be populated when a case is closed.  Customer portal users can see this field but are not required to fill it out as it is read only.  I need this rule to negate teh close if it is a customer portal user.  Here is what I have so far

 

ISPICKVAL(Status,"Closed")&& ISPICKVAL(SIS_Priority_Setting__c," ")&& $Profile.Name <>"*5.5 Customer Portal Manager Custom" ||
ISPICKVAL(Status,"Closed")&&ISPICKVAL(SIS_Priority_Setting__c," ")&& $Profile.Name <>"ACP Customer Portal Manager" ||
ISPICKVAL(Status,"Closed")&& ISPICKVAL(SIS_Priority_Setting__c," ")&& $Profile.Name <>"High Volume Customer Portal User-SFDC Test" ||
ISPICKVAL(Status,"Closed")&& ISPICKVAL(SIS_Priority_Setting__c," ")&& $Profile.Name <>"High Volume Customer Portal User" ||
ISPICKVAL(Status,"Closed")&& ISPICKVAL(SIS_Priority_Setting__c," ")&& $Profile.Name <>"New Customer Portal"||

ISPICKVAL(Status,"Closed")&&ISPICKVAL(SIS_Priority_Setting__c," ")&& $Profile.Name <>"SSC Client Customer Portal Manager Custom"

 

Does this make sense or am I going mad?

 

Best Answer chosen by Admin (Salesforce Developers) 
Avidev9Avidev9
How about using brackets ?
arround individual conditions ?
something like (ISPICKVAL(Status,"Closed")&& ISPICKVAL(SIS_Priority_Setting__c," ")&& $Profile.Name <>"*5.5 Customer Portal Manager Custom")

All Answers

Avidev9Avidev9
How about using brackets ?
arround individual conditions ?
something like (ISPICKVAL(Status,"Closed")&& ISPICKVAL(SIS_Priority_Setting__c," ")&& $Profile.Name <>"*5.5 Customer Portal Manager Custom")
This was selected as the best answer
kevin.chileskevin.chiles

Yeah, thats what it came down to @.  I was able to complete it so it looks like this

 

ISPICKVAL(Status,"Closed")&&
ISBLANK(TEXT(SIS_Priority_Setting__c))
&&
($Profile.Name <>"SSC Client Customer Portal Manager Custom")||
ISPICKVAL(Status,"Closed")&&
ISBLANK(TEXT(SIS_Priority_Setting__c))
&&
($Profile.Name <>"ACP Customer Portal Manager")||
ISPICKVAL(Status,"Closed")&&
ISBLANK(TEXT(SIS_Priority_Setting__c))
&&
($Profile.Name <>"High Volume Customer Portal User-SFDC Test")||
ISPICKVAL(Status,"Closed")&&
ISBLANK(TEXT(SIS_Priority_Setting__c))
&&
($Profile.Name <>"High Volume Customer Portal User")

 

 

Works like a charm :)
Avidev9Avidev9
So its working now ?
kevin.chileskevin.chiles

Correct sir, 

 

Swimmingly