[SalesForce] Is it possible to re-render select options for a SelectList based on selected options for other SelectList controls on the same page

I am trying to figure out how I would dynamically update the SelectOptions for multiple SelectLists on the same visualforce page.

I have a page where the user selects contacts that are associated with a previously selected account (step one of a wizard control). I have 5 SelectList controls on this page.

What I would like to have happen is when the user selects a contact in the first selectlist control, I update the selectoptions for the other controls to remove that contact as a select option (so the user can't select the same contact in multiple selectlists on the page).

I've been playing with the apex:actionFunction and the reRender attribute, but I can't seem to get this working.

Can anyone show me if it is possible to do what I've described above? Or provide an example of how you would accomplish this (assuming it's possible)?

Thank you!

Best Answer

You can accomplish this by adding an ActionSupport to each of the SelectOptions

<apex:pageBlockSection >
     <apex:actionRegion >
    <apex:selectList value="{!conid}" size="1" >
      <apex:selectOptions value="{!Cons}" />
      <apex:actionSupport action="{!updateCONLIST}" event="onchange" reRender="pBlock" />
     </apex:selectList>
    <apex:selectList value="{!conid2}" size="1" id="pBlock" >
        <apex:selectOptions value="{!Cons2}" />
    <apex:actionSupport action="{!updateCONLIST}" event="onchange" reRender="rBlock" />
        </apex:selectList>
    <apex:selectList value="{!conid3}" size="1" id="rBlock" >
        <apex:selectOptions value="{!Cons3}" />
    </apex:selectList>
         </apex:actionRegion>
</apex:pageBlockSection>

Depending on how long your SOQL might take to run, you could also include an ActionStatus to show a "please wait" type of message each time it is rerendering (and updating your dependent lists).

Related Solutions

[SalesForce] Visualforce SelectList value not setting on Rerender

No need to set the userType as a param on the action function....since the action function and the select list is within the same form section, userType will automatically get set. Also, you can set actionFunction's action="{!null}". It wants an action in there, but all we're really saying is "do the post and rerender the screen". Also note that field validation will occur before the sets...so if you had an input field set to required within the same form tags, your process would fail with no feedback (unless you had a pageMessages tag within the rerendered section)

[SalesForce] Apex form load select list based on selected item in previous select list

This appears to work depending on which objects are selected in the first list. My guess at this point is that there is some permissions issue where my user doesn't have access to the fields on all objects when accessed via -

Map<String,Schema.SObjectType> gd = Schema.getGlobalDescribe();  
Schema.SObjectType sobjType = gd.get(myobj.ObjectName);

Updated with full solution:

I added a filter to my code that builds the Object list in the first dropdown. For each object type I try to describe it and if that returns null I don't add it as an option. Now whatever object I select the field dropdown is dynamically updated with the associated fields.

I think this solution will work for me. There may be a better answer to select the filtered list of objects using the describe methods?

public List<SelectOption> getSobjectFields()   
{  
    List<SelectOption> fields = new List<SelectOption>(); 

    Schema.SObjectType sobjType = gd.get(myobj.ObjectName);  
    if (sobjType != null) {
    Schema.DescribeSObjectResult r = sobjType.getDescribe();  
    Map<String,Schema.SObjectField> M = r.fields.getMap();  

    for(String fieldName : M.keyset())  
        {  
            Schema.SObjectField field = M.get(fieldName);                                                      
            Schema.DescribeFieldResult fieldDesc = field.getDescribe();  
            fields.add(new SelectOption(fieldName.toLowerCase(),fieldName.toLowerCase())); 
        }  
    }


    return fields;  
}      

public List<SelectOption> getObjectNames()
{
   List<Schema.SObjectType> gdo = Schema.getGlobalDescribe().Values(); 
   List<SelectOption> options = new List<SelectOption>();

   for(Schema.SObjectType f : gdo)
   {
       Schema.SObjectType sobjType = gd.get(f.getDescribe().getLabel());  
       if (sobjType != null) {
          options.add(new        SelectOption(f.getDescribe().getLabel(),f.getDescribe().getLabel()));
       }
   }
   return options;

}

Best Answer

Related Solutions

[SalesForce] Visualforce SelectList value not setting on Rerender

[SalesForce] Apex form load select list based on selected item in previous select list

Related Topic