You need to sign in to do that
Don't have an account?
Pamela DuPont
Need help making Validation Rule more efficient
Hi!
I have a validation rule that is doing what it is supposed to be doing however I know it is not written in the most efficient way. Does anyone have any suggestions on how to streamline the code? I'm new to writing more complex rules so am not quite sure how to go about it. Any help or suggestions would be wonderful. Thanks!
AND(
Product__r.ProductCode <> "36726",
Product__r.ProductCode <> "40631",
Product__r.ProductCode <> "36724",
Product__r.ProductCode <> "36722",
Product__r.ProductCode <> "41518",
Product__r.ProductCode <> "42662",
Product__r.ProductCode <> "34482",
Product__r.ProductCode <> "33207",
Product__r.ProductCode <> "33208",
Product__r.ProductCode <> "33206",
Product__r.ProductCode <> "25723",
Product__r.ProductCode <> "54359",
Product__r.ProductCode <> "54361",
Product__r.ProductCode <> "54358",
Product__r.ProductCode <> "54357",
Product__r.ProductCode <> "21335",
Product__r.ProductCode <> "74350",
Product__r.ProductCode <> "74348",
Product__r.ProductCode <> "35214",
Product__r.ProductCode <> "17958",
Product__r.ProductCode <> "42891",
Product__r.ProductCode <> "39283",
Product__r.ProductCode <> "42890"
)
&&
CU_Code__c="A352"
&&
RecordType.DeveloperName="CP_Product_Performance_Assurance"
&&
Assurance_Issue__c=TRUE
||
AND(
Product__r.ProductCode <> "48120",
Product__r.ProductCode <> "48121",
Product__r.ProductCode <> "53916"
)
&&
CU_Code__c="A362"
&&
RecordType.DeveloperName="CP_Product_Performance_Assurance"
&&
Assurance_Issue__c=TRUE
I have a validation rule that is doing what it is supposed to be doing however I know it is not written in the most efficient way. Does anyone have any suggestions on how to streamline the code? I'm new to writing more complex rules so am not quite sure how to go about it. Any help or suggestions would be wonderful. Thanks!
AND(
Product__r.ProductCode <> "36726",
Product__r.ProductCode <> "40631",
Product__r.ProductCode <> "36724",
Product__r.ProductCode <> "36722",
Product__r.ProductCode <> "41518",
Product__r.ProductCode <> "42662",
Product__r.ProductCode <> "34482",
Product__r.ProductCode <> "33207",
Product__r.ProductCode <> "33208",
Product__r.ProductCode <> "33206",
Product__r.ProductCode <> "25723",
Product__r.ProductCode <> "54359",
Product__r.ProductCode <> "54361",
Product__r.ProductCode <> "54358",
Product__r.ProductCode <> "54357",
Product__r.ProductCode <> "21335",
Product__r.ProductCode <> "74350",
Product__r.ProductCode <> "74348",
Product__r.ProductCode <> "35214",
Product__r.ProductCode <> "17958",
Product__r.ProductCode <> "42891",
Product__r.ProductCode <> "39283",
Product__r.ProductCode <> "42890"
)
&&
CU_Code__c="A352"
&&
RecordType.DeveloperName="CP_Product_Performance_Assurance"
&&
Assurance_Issue__c=TRUE
||
AND(
Product__r.ProductCode <> "48120",
Product__r.ProductCode <> "48121",
Product__r.ProductCode <> "53916"
)
&&
CU_Code__c="A362"
&&
RecordType.DeveloperName="CP_Product_Performance_Assurance"
&&
Assurance_Issue__c=TRUE
Try this formula:-
OR(AND(NOT(CONTAINS("36726:40631:36724:36722:41518:42662:34482:33207:33208:33206:25723:
:54359:54361:54358:54357:21335:74350:74348:35214:17958:42891:39283:42890",Product__r.ProductCode
)),CU_Code__c="A352",RecordType.DeveloperName="CP_Product_Performance_Assurance",Assurance_Issue__c=TRUE),
AND(NOT(CONTAINS("48120:48121:53916",Product__r.ProductCode)),CU_Code__c="A362",
RecordType.DeveloperName="CP_Product_Performance_Assurance",
Assurance_Issue__c=TRUE))