Validation Rule with Multiple Record type

Hello,
Below is the valition rule which i have created. The requirement- whenever the stage is set to as 'Closed Lost' , the loss reason need to be mandatory for the different record types mentioned in the rule.
The rule is not getting triggered and i am able to save opportunity without prompt of the error
Please advice

AND
(ISPICKVAL(StageName, "Closed Lost"),OR ($RecordType.Name = "Lending_Closed",$RecordType.Name = "Non_Lending_Closed",$RecordType.Name = "Non_Lending",RecordType.Name = "Lending"),
ISBLANK(TEXT(Loss_Reason__c)))

Thanks,
BD

August 5, 2020
·
Like
0
·
Follow
0

Best Answer chosen by B D 263

David Zhu 🔥
You may try the following:

AND
(ISPICKVAL(StageName, "Closed Lost"),
OR (RecordType.DeveloperName = "Lending_Closed",
RecordType.DeveloperName = "Non_Lending_Closed",
RecordType.DeveloperName = "Non_Lending",
RecordType.DeveloperName = "Lending"),
ISBLANK(TEXT(Loss_Reason__c)))

August 5, 2020
·
Like
1
·
Dislike
0

This was selected as the best answer

Abhi Vyas
Thanks for your answer (Saving Account)

August 18, 2020
·
Like
0
·
Dislike
0

Fil Kańczuła
Why is RecordType.DeveloperName not available through "insert fields" button --- isn't that weird?

October 28, 2022
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Validation Rule with Multiple Record type

All Answers

You need to sign in to do that.