locked
Multiple Cascading Drop Down Lists - Browser RRS feed

  • Question

  • Hi

    We have a requirement to implement quite a complex cascading drop down list solution. I am aware that there are numerous articles on how to do this however I would like to confirm if it is possible to achieve the following:

    1. A drop down list with multiple selections for field A. User selects field A.
    2. Field B is automatically populated based on field A which was selected above.
    3. A filtered drop down list appears for field C. This filtered drop down list is based on field A & B which was previously selected. User selects field C.
    4. Field D is automatically populated based on field C which was selected above.
    5. Field E is automatically populated based on field C which was selected above.
    6. Field F is automatically populated based on field C which was selected above.

    My programming skills are very limited and how I would ideally like to connect the form to a list in SharePoint so that the values can be easily maintained. We are using a browser form and would appreciate any ideas or suggestions on how to create the above functionality. Just out of interest, The custom drop down list for field C will probably have 100 values and overall we have about 5000 records which need to be autopopulated and filtered.

    Thanks for any help
    Tony

     

    Thursday, May 12, 2011 10:39 AM

Answers

  • Hi Tony,

    I've done something similar but it wasn't a browser based form since filtering is not supported for browser forms. In my case, the form is used internally within the organization. Everyone has Microsoft Office Suite that includes InfoPath. So, creating a client based form wasn't an issue.

    To do this in browser based, you'll need to get into coding. Here are couple of references. You may find more online.

    http://blogs.msdn.com/b/infopath/archive/2006/10/12/cascading-dropdowns-in-browser-forms.aspx

    http://www.bizsupportonline.net/browserforms/filter-cascade-drop-down-infopath-sharepoint-browser-form-owssvr-dll.htm

     

    Hope that helps...

     


    Pman
    http://www.pmansLab.com/
    • Marked as answer by Emir Liu Friday, May 20, 2011 2:46 AM
    Saturday, May 14, 2011 4:00 PM
  • Tony, you aren't a developer, but this requirement was given to you?  That's not a good thing, because filtering is not supported in 2007 browser forms, so you're going to have to completely write your own method to do it.  PL gave you some resources, but these aren't even using native InfoPath functionality - these are code-based methods to circumvent the inability to filter in browser forms, so you're going to have to write and maintain code for this to work, and you're going to have to be extremely careful with making sure you do not kill the performance of the form with those 5000 records.

    You're going to have to use parameterized queries so that you never pull in 5000 items - not even 2000 - and even if you pull in a few thousand, you are going to have to clear out that huge list whenever possible so that the rest of the form performs decently.  If you pull in a ton of data, then it doesn't only affect the initial download, but rather it also causes every single postback to take longer (i.e. when you have any rule, formatting, or validation on any other field in the view).

    Otherwise, the 1-6 list you gave should be doable.


    SharePoint Architect || Microsoft MVP || My Blog
    Planet Technologies || SharePoint Task Force
    • Marked as answer by Emir Liu Friday, May 20, 2011 2:46 AM
    Monday, May 16, 2011 5:48 AM

All replies

  • Hi Tony,

    I've done something similar but it wasn't a browser based form since filtering is not supported for browser forms. In my case, the form is used internally within the organization. Everyone has Microsoft Office Suite that includes InfoPath. So, creating a client based form wasn't an issue.

    To do this in browser based, you'll need to get into coding. Here are couple of references. You may find more online.

    http://blogs.msdn.com/b/infopath/archive/2006/10/12/cascading-dropdowns-in-browser-forms.aspx

    http://www.bizsupportonline.net/browserforms/filter-cascade-drop-down-infopath-sharepoint-browser-form-owssvr-dll.htm

     

    Hope that helps...

     


    Pman
    http://www.pmansLab.com/
    • Marked as answer by Emir Liu Friday, May 20, 2011 2:46 AM
    Saturday, May 14, 2011 4:00 PM
  • Tony, you aren't a developer, but this requirement was given to you?  That's not a good thing, because filtering is not supported in 2007 browser forms, so you're going to have to completely write your own method to do it.  PL gave you some resources, but these aren't even using native InfoPath functionality - these are code-based methods to circumvent the inability to filter in browser forms, so you're going to have to write and maintain code for this to work, and you're going to have to be extremely careful with making sure you do not kill the performance of the form with those 5000 records.

    You're going to have to use parameterized queries so that you never pull in 5000 items - not even 2000 - and even if you pull in a few thousand, you are going to have to clear out that huge list whenever possible so that the rest of the form performs decently.  If you pull in a ton of data, then it doesn't only affect the initial download, but rather it also causes every single postback to take longer (i.e. when you have any rule, formatting, or validation on any other field in the view).

    Otherwise, the 1-6 list you gave should be doable.


    SharePoint Architect || Microsoft MVP || My Blog
    Planet Technologies || SharePoint Task Force
    • Marked as answer by Emir Liu Friday, May 20, 2011 2:46 AM
    Monday, May 16, 2011 5:48 AM