You need to sign in to do that
Don't have an account?
Charlie Chaplin 2017
Validation rule help for Lookup and Picklist field
Validation rule for lookup field and picklist value based on record typeWe have custom object ABCD. Which is present on Account object as related list
When a user creates a new record on this custom object.
this new record is assinged to a queue. XYZ
Newly created record have
Owner as lookup field
Review Type as Picklist Field
Want i want to do is when a new record has been create based on a particular Record Type.
User should not be able to edit the record till he change the Owner. Once that's done.
Review Type picklist value should be changed before make any further changes to the record.
Here is the rule what i have
AND
(
RecordType.Name = "Supplemental",
ISCHANGED(OwnerId),
(ISBLANK(TEXT( Review_Type__c)))
)
When a user creates a new record on this custom object.
this new record is assinged to a queue. XYZ
Newly created record have
Owner as lookup field
Review Type as Picklist Field
Want i want to do is when a new record has been create based on a particular Record Type.
User should not be able to edit the record till he change the Owner. Once that's done.
Review Type picklist value should be changed before make any further changes to the record.
Here is the rule what i have
AND
(
RecordType.Name = "Supplemental",
ISCHANGED(OwnerId),
(ISBLANK(TEXT( Review_Type__c)))
)
Lakshman
Try this, should work: