You need to sign in to do that
Don't have an account?
IsPickval in conjunciton with $User.ProfileId=; syntax ok, results not.
Hello, we have a validation rule that works fine when we use it with one Profile parameter (see Version One). But it breaks if we try to add more (see Version 2 or 3).
Anyone know why this is and how I can expand it's function? Notice the first time I excluded ALL users that were not CSR's, the second I tried to excluded ALL users not CSRs, Mktg, etc etc, and I think I caused some kind of dual exclude because after that No one could save. The third I switched to the idea of EQUALS certain profiles instead of NOT EQUAL TO in the first two.
Version one
OR(ISPICKVAL(Opportunity.CSR_Processing_Status__c, "Pending"), ISPICKVAL(Opportunity.CSR_Processing_Status__c, "Working"))
&&
$User.ProfileId <> "00e60000000a5pv"
Version 2
OR(ISPICKVAL(Opportunity.CSR_Processing_Status__c, "Pending"), ISPICKVAL(Opportunity.CSR_Processing_Status__c, "Working"))
&&
$User.ProfileId <> "00e60000000a5pv,00e60000000avPC,00e60000000avPR,00e60000000aNgk"
Version 3
ISPICKVAL(Opportunity.CSR_Processing_Status__c, "Pending")
||
ISPICKVAL(Opportunity.CSR_Processing_Status__c, "Working")
&&
$User.ProfileId = "00e60000000avP7,00e60000000avPC,00e60000000avPR,00e60000000aNgk"
Does this work?
OR(ISPICKVAL(Opportunity.CSR_Processing_Status__c, "Pending"), ISPICKVAL(Opportunity.CSR_Processing_Status__c, "Working"))
&&
$User.ProfileId <> "00e60000000a5pv"
&&
$User.ProfileId <> "00e60000000avPC"
&&
$User.ProfileId <> "00e60000000avPR"
&&
$User.ProfileId <> "00e60000000aNgk"
All Answers
Does this work?
OR(ISPICKVAL(Opportunity.CSR_Processing_Status__c, "Pending"), ISPICKVAL(Opportunity.CSR_Processing_Status__c, "Working"))
&&
$User.ProfileId <> "00e60000000a5pv"
&&
$User.ProfileId <> "00e60000000avPC"
&&
$User.ProfileId <> "00e60000000avPR"
&&
$User.ProfileId <> "00e60000000aNgk"
that's working, we're going to launch this monday, thanks!