function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
sdetweilsdetweil 

large dependent picklist issue

as we migrate to SFDC from our legacy systemm I have to decide how to deal with a large dependant picklist.

 

the controlling field has 1027 selectable values, and there are 5,000 total dependent values over the 1027 primary values.

 

SF dependant picklist controlling field only supports 300 values..

 

has anyone made a solution that supports larger amounts of data..

 

I know I can attempt to redesign the data, but we have a number of business processes that would also need to be revised.

and that work is scheduled in a subsequent release after migration..

 

ideas welcomed..

 

Sam

 

TrimbleAgTrimbleAg

Honestly, I think your out of luck, thats the setting on them and dont see how you can alter that with any coding...

 

   

I think it could be time to revisit your selections and see how you can break them out into categories. A new system, time for a new method ;-)

 

Pat 

 
sdetweilsdetweil

thanks.. I was wondering if there was a way to create my OWN dependant picklist with custom objects and apex, javascript coding..

 

if anyone had done that
Tom DJTom DJ

You can do it if you create your own Visual Force page and use "apex:SelectOptions" and "apex:SelectOption" tags.   The controlling field will need to have an "apex:actionSupport" tag with "rerender" attribute set to the ID of the dependent picklist. or id of the pageBlock containing the dependent picklist.

 

Example code in VF page

 

 

       <apex:pageBlock id="blocktorerender" >
               <apex:selectList id="controllingpicklist" value="{!UserSelectedControllingOption}" >
                   <apex:selectOptions value="{!TheControllingSelectOptions}"/>
                	<apex:actionSupport event="onchange" rerender="blocktorerender"/>
               </apex:selectList>

               <apex:selectList id="dependentpicklist" value="{!UserSelectedDependentOption}" >
                   <apex:selectOptions value="{!TheDependentSelectOptions}"/>
               </apex:selectList>
       
        </apex:pageBlock>

 

 

Example Controller code

 

public class myController {
    public String  UserSelectedControllingOption {get;set;}
    public String  UserDependentControllingOption {get;set;}
    
    myController() {
             UserSelectedControllingOption = 'myDefaultControllingOption";
             UserSelectedDependentOption = 'myDefaultDependentOption";
    }
    
    public List<SelectOption> getTheControllingSelectOptions() {
        List<SelectOption> options = new List<SelectOption>();
        options.add(new SelectOption('US','US'));
        options.add(new SelectOption('CANADA','Canada'));
        options.add(new SelectOption('MEXICO','Mexico'));

        return options;
    }

    public List<SelectOption> getTheDependent SelectOptions() {
        List<SelectOption> options = new List<SelectOption>();

        // add dependent select options to list based on the value of  UserSelectedControllingOption
        
        return options;
    }

 

 

Good luck,

 

Tom DJ