+ Start a Discussion
Vamshi KrishnaVamshi Krishna 

How can I lock the record based on a picklist value except one field (which the user can have complete access)?

I have a form (record) that needs to get locked except for the sys admin once the field changes to "approved" or etc.. The scenario is they have to pay for the form once it is approved. We have a formaula field which acts like a button to a visualforce page for payment. 
-I wrote a validation rule which unlocks the record once it's status changes to certain value.
  AND( 
$Profile.Name <> 'System Administrator', 
$Profile.Name <> 'Agent Manager', 

NOT(ISCHANGED(Status__c)), 
OR( 
ISPICKVAL(Status__c, 'Approved'), 
ISPICKVAL(Status__c, 'Denied'), 
ISPICKVAL(Status__c, 'AM Approved') 

)

How to exclude one field from it? Like formual field"Payment" from it.
Shawn Reichner 29Shawn Reichner 29
Try to add your field to your validation rule like Payment__c = null. This will lock the record when the formula to display the button is not satisfied, or do NOT EQUAL to null if you only want it locked when the button is present.  Does this help or did I misunderstand the question?