We have a pick list field in Account object. Values of the picklist are X and Y. Now I would like to hide or restrict access to records which have picklist value as X for certain profile called Operations. So this profile users should be able to see only records with picklist value Y but not X.

I have tried different ways but could not get it. Any insights could be helpful.

Thank you.

2 Answers 2

  1. Make Account OWD = Private
  2. Create Account sharing setting i.e,

Based on criteria - Pick list = y --> Assign for group of users/Public Groups/roles.


If you set up two record types you'd effectively be doing the same thing as you're asking. Make only the one RecordType available to the Operations Profile and the other either read-only or no access. You can then simply edit the record type (a picklist) to allow or disallow access to those users. You can find out more about RecordTypes by searching on it in the Salesforce Help.

  • I already have all the records in the org. Now based on picklist value can I restrict the access to specific account records? Jun 2, 2015 at 14:52
  • how many picklist values are you expecting to have?
    – James
    Jun 2, 2015 at 14:53
  • 4 picklist values. Operations profile should be able to see only one picklist value account records. Remaining all the records should be hidden from them. Jun 2, 2015 at 15:00
  • Each account would have a record type on it. Changing the RecordType would change who had access to the record depending on what profile had the recordtype enabled for it.
    – crmprogdev
    Jun 2, 2015 at 15:00
  • Record type sharing setting is done. That is for different values. Now after that I would like to restrict access to accounts based on a pick list field value. Jun 2, 2015 at 15:04

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .