+ Start a Discussion
udayarangareddy mekalaudayarangareddy mekala 

VALIDATION RULE#1

HI

Team member creates a CONTACT record without trying to ACCOUNT,team member select the hot under the status picklistfield.please tell me how to reslove above one.

THANKS

RANGA
Best Answer chosen by udayarangareddy mekala
goabhigogoabhigo
First of all what is the issue here? Correct me if I am wrong. You want to restrict the user from creating a Contact record without Account field, when the Status picklist = Hot. In other words, if the Account field is blank and the Status = Hot, there should be error message.

Now translate that into validation rule: AND( ISBLANK (Account), ISPICKVAL(Status__c, 'Hot') )

Does this work? Let me know.

--
Abhi.

All Answers

goabhigogoabhigo
First of all what is the issue here? Correct me if I am wrong. You want to restrict the user from creating a Contact record without Account field, when the Status picklist = Hot. In other words, if the Account field is blank and the Status = Hot, there should be error message.

Now translate that into validation rule: AND( ISBLANK (Account), ISPICKVAL(Status__c, 'Hot') )

Does this work? Let me know.

--
Abhi.
This was selected as the best answer
udayarangareddy mekalaudayarangareddy mekala
Thanks Abhi
goabhigogoabhigo
Best Answer is Thanks Abhi??
goabhigogoabhigo
Hahha Uday :)