I want to be able to have the controlling field of a dependent picklist not show to the users, I am updating this field using workflow.
From Salesforce docs Page layouts Make sure controlling fields exist on any page layout that contains their associated dependent picklist. When the controlling field is not on the same page layout, the dependent picklist shows no available values.
Does anyone know of a good workaround? Not keen to turn this page into Visual Force just for this.
Attribution to: Kris Moyse
Possible Suggestion/Solution #1
Out solution currently is just to accept that the controlling field is visible and editable but to have a validation rule (ISCHANGED) which does not allow it to be changed. This is an option when you set the controlling field value once at creation and it should never again be changed.
You can also make the controlling field readonly for certain profiles under "Security Controls" -> "Field Accessibility". Removing it makes the controlled field readonly :-(
Attribution to: Marc
Possible Suggestion/Solution #2
How about make the controlling field read only on the layout and relegating it to the System Information or a similar section?
Attribution to: techtrekker
Possible Suggestion/Solution #3
If the use case is just updating field A based on Field B why not use a field update workflow and hide field B from the pagelayout??
please correct me if I missed something
Attribution to: Rao
Possible Suggestion/Solution #4
Dependent picklists are handled through Javascript on the page, so if the controlling field isn't available, there's no way to handle that functionality. You must be setting that controlling field some other way than through the UI, but I wonder about the usefulness of not being able to create a new record with a non-null controlling field anyway.
The only way I know of to control picklist values, without Visualforce, is through Record Types, which may or may not be a good solution for you.
Attribution to: Jeremy Nottingham
Possible Suggestion/Solution #5
The controlling field can be made hidden on the page. For example,
So that both controlling field and dependent picklist are on the same page but yet controlling field not visible/available to change for the user.
Attribution to: user2256
Possible Suggestion/Solution #6
If the dependent pick list has single value for selected value of controlling field, You can create a Formula field instead of dependent picklist, and populate it based on controlling field value selected.
Attribution to: Shekar
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/1799