Starting November 20, the site will be set to read-only.
On December 4, 2023,
Apex Code Development (90768)
General Development (55146)
Visualforce Development (37251)
Lightning (18265)
APIs and Integration (17146)
Trailhead (11680)
Formulas & Validation Rules Discussion (11337)
Other Salesforce Applications (8116)
Jobs Board (6655)
Force.com Sites & Site.com (4842)
Mobile (2694)
You need to sign in to do that
Don't have an account?
SFmaverick I have the same problem. I want to lock the picklist field from being edited after the picklist value "Completed" is selected.
Picklist = Drugscreen
"Need To Submit"
"Submitted"
"Completed"
After "Completed" is selected I want to lock the picklist from being edited.
You're welcome, you owe me a beer...
http://beeradvocate.com/beer/profile/863/7971/
Oh yeah, if you want to exempt Admins or any other Profiles from the VR just amend the VR Formula like this
AND(ISCHANGED(Picklist_1__c ),
ISPICKVAL(PRIORVALUE(Picklist_1__c ), "A"),
NOT(ISPICKVAL( Picklist_1__c , "A")),
NOT($Profile.Name = "System Administrator"))
All Answers
Here's one I did that might work for you
AND(
ISCHANGED(Picklist_1__c ),
ISPICKVAL(PRIORVALUE(Picklist_1__c ), "A"),
NOT(ISPICKVAL( Picklist_1__c , "A"))
)
If you want to disable the control instead of validating for changes you can also create a workflow that changes the record type for the object to one that is associated to a different page layout, with the field marked Read Only.
Stevemo's solution is better if you want to stop Admins changing it too
Thanks,
It Worked.
You're welcome, you owe me a beer...
http://beeradvocate.com/beer/profile/863/7971/
Oh yeah, if you want to exempt Admins or any other Profiles from the VR just amend the VR Formula like this
AND(ISCHANGED(Picklist_1__c ),
ISPICKVAL(PRIORVALUE(Picklist_1__c ), "A"),
NOT(ISPICKVAL( Picklist_1__c , "A")),
NOT($Profile.Name = "System Administrator"))