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.
Best Answer
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.