We currently have a validation rule that reads:
AND(
CONTAINS(TEXT(Status),'Resolved'),
NOT(ISPICKVAL(Type, "Inquiry")),
OR(
ISBLANK(Text(Responsible_Party__c)),
ISBLANK(Text(Resolution_Type__c)),
AND(ISPICKVAL(Resolution_Approval_Status__c,"Approved"),
ISBLANK(Actual_Cost__c)),
AND(NOT(ISPICKVAL(Resolution_Approval_Status__c, "Approved")),
OR(Actual_Cost__c != 0, ISBLANK(Actual_Cost__c)))
)
)
All I need to do is essentially say If the record type does not equal a specific record type, then begin this process. I thought it would be
AND (
RecordType.Name <> "TESTING")
and then the rest of the formula, but I can't seem to get it to work. Any suggestions? Thanks!
답변 11개
Can you please copy paste below validation rule and try that.
AND
(
RecordType.Name <> "Admin Support Case Testing2",
CONTAINS(TEXT(Status),'Resolved'),
NOT(ISPICKVAL(Type, "Inquiry")),
OR
(
ISBLANK(Text(Responsible_Party__c)),
ISBLANK(Text(Resolution_Type__c)),
AND
(
ISPICKVAL(Resolution_Approval_Status__c,"Approved"),
ISBLANK(Actual_Cost__c)
),
AND
(
NOT(ISPICKVAL(Resolution_Approval_Status__c, "Approved")),
OR
(
Actual_Cost__c != 0,
ISBLANK(Actual_Cost__c)
)
)
)
)
