You need to sign in to do that
Don't have an account?
Anthony DiGangi 5
How to lock down changing of picklist values by profile?
I have a field accessibly by Sales and Sales Ops. Sales should not be able to change the field once they have selected 100% but Sales Ops needs to be able to edit the field and move the percent to 90%. Can you use "Custom Permissions" if so what would the code for the "Validation rule need to be?" The Object is "Opportunity" the field is "Sales Stage" which has a dependent field "Probability."
All Answers
Utilizing the following formula will enable you to fire a VR when someone not in the specified Profile attempts to edit a Opporunity record which has been closed.
AND(
IsClosed,
PRIORVALUE(IsClosed),
$User.ProfileId <>'Profile_ID')
Let me know how I can be of further assistance. If this meets your requirement please hit that BEST ANSWER button! =))
1) The Validation Rule is placed directly on the field which you want the VR to fire on. This your Use Case Click "Stage"
2) Click the New button under Validation Rules section.
3) Enter the Validation Rule details. In your Use Case you only need to list the Profile ID you DONT want the Validation Rule to fire for. You find the Profile ID by clicking on the Profile via the Setup > Manager Users > Profiles > [Click Profile of choice] > find ID in URL of Address Bar.
I think I know what you are trying to accomplish and Keena's response is helpful, but not exactly what you want. I am writing here now so I can keep track of this request while I solve your issue as I would like to know this for my own practice as well. Alternatively, you could probably create a process that causes an opportunity to close once this custom field equals 100% and then use Keena's validation rule to stop anyone but the 'Sales Ops' from editing the entire record.
Do you need the entire Opportunity closed to a Sales profile once that field hits 100% or just that specific field?
Will write back soon with an exact answer.
Thanks,
Shawn
I believe you will definitely need to separate the profiles to restrict one while allowing the other to keep its access. Once you have done this you should be able to create a validation rule that stops all profiles not equal to Sales Ops from edditing the field if it equals 100%. I still need to brush up on validation rules before I can give you the proper code for it, but perhaps this will get you started. Anthony, if you know the code Keena needs to restrict access to a field that equals 100% from all profiles <> 'PROFILE NAME' feel free to jump in here.
Thanks,
Shawn