Apex Code Development You need to sign in to do that
Don't have an account?
sfdc_beginner7 AND and OR in validation rule ?
i have to create a validation rule if RecordType is "ITOVC_Alert" and Resolution_Status__c="Closed with actions" and ((EVC__c=FALSE and
ISBLANK( EVC_Comments__c)) or (RCCA__c= FALSE and ISBLANK( RCCA_Description__c ) ) or ISBLANK(Resolution_Closing_Comments__c)) then throw the error , but the rule is not working as expected. If I populating EVC_Comments__c only it is getting saved.
)
AND(
RecordType.DeveloperName ="ITOVC_Alert",
ISPICKVAL( Resolution_Status__c, "Closed with actions") ,
OR(
AND(
EVC__c=FALSE,
ISBLANK( EVC_Comments__c )
),
AND(
RCCA__c= FALSE,
ISBLANK( RCCA_Description__c )
),
ISBLANK(Resolution_Closing_Comments__c)
)
)
What's wrong with my rule?
ISBLANK( EVC_Comments__c)) or (RCCA__c= FALSE and ISBLANK( RCCA_Description__c ) ) or ISBLANK(Resolution_Closing_Comments__c)) then throw the error , but the rule is not working as expected. If I populating EVC_Comments__c only it is getting saved.
)
AND(
RecordType.DeveloperName ="ITOVC_Alert",
ISPICKVAL( Resolution_Status__c, "Closed with actions") ,
OR(
AND(
EVC__c=FALSE,
ISBLANK( EVC_Comments__c )
),
AND(
RCCA__c= FALSE,
ISBLANK( RCCA_Description__c )
),
ISBLANK(Resolution_Closing_Comments__c)
)
)
What's wrong with my rule?