You need to sign in to do that
Don't have an account?
Marilyn Buresh
validation rule missing ')'
Can someone tell me where I'm missing the ')' ? This is a validation rule on a custom object. I'm adding the line with OMTOA but getting a syntex error that I'm missing a ')' - help!
AND(
OR(
ISPICKVAL( Interview_Model__r.Interview_Type__c , "1"),
ISPICKVAL( Interview_Model__r.Interview_Type__c , "2"),
ISPICKVAL( Interview_Model__r.Interview_Type__c , "3"),
ISPICKVAL( Interview_Model__r.Interview_Type__c , "4")),
OR(
NOT(ISBLANK( Profiles__c )),
NOT(ISBLANK( External_Predictions__c )),
NOT(ISBLANK( Internal_Predictions__c ))),
OR(NOT( Interview_Model__r.Name , "OMTOA")),
$User.Bypass_Validation_Rules__c =false)
Thank you!
AND(
OR(
ISPICKVAL( Interview_Model__r.Interview_Type__c , "1"),
ISPICKVAL( Interview_Model__r.Interview_Type__c , "2"),
ISPICKVAL( Interview_Model__r.Interview_Type__c , "3"),
ISPICKVAL( Interview_Model__r.Interview_Type__c , "4")),
OR(
NOT(ISBLANK( Profiles__c )),
NOT(ISBLANK( External_Predictions__c )),
NOT(ISBLANK( Internal_Predictions__c ))),
OR(NOT( Interview_Model__r.Name , "OMTOA")),
$User.Bypass_Validation_Rules__c =false)
Thank you!
All Answers