Ask Search:
Kerri BabbittKerri Babbitt 

Lock field once another field is populated

Hello all. I'm looking to lock the account name field for editing if a custom field (CRM ID) is already populated (unless the person is an administrator). Would this best be accomplished using a validation rule?
 
Best Answer chosen by Kerri Babbitt
Ahilesh RagavanAhilesh Ragavan
Create a Validation rule on Account  like this:
AND(
$Profile.Name <> "System Administrator",
ISCHANGED(Name),
NOT(ISBLANK(CRM_ID__C))
)

 

All Answers

Ahilesh RagavanAhilesh Ragavan
Create a Validation rule on Account  like this:
AND(
$Profile.Name <> "System Administrator",
ISCHANGED(Name),
NOT(ISBLANK(CRM_ID__C))
)

 
This was selected as the best answer
Naveen DhanarajNaveen Dhanaraj
++,
Try This,
AND(
    ISCHANGED(Name),
    NOT(ISBLANK(CRMID__C)),
    $Profile.Name <> "System Administrator"
)

 
Trisha GourleyTrisha Gourley
Is it possible to not allow any changes to fields on the object once the field ie. CRM ID is completed?