Partager via

Use Rules and Filters to Create Cascading Dropdowns in Forms

  • Article

Hi, my name is Anson Hidajat and I’m a program manager on the InfoPath team. In this week's “5 for forms” video demo, I will show how you can use rules and filters to create cascading dropdown lists in a tennis tournament bracket application. Get Microsoft Silverlight

Enjoy and please send us your feedback!

Comments

  • Anonymous
    October 25, 2010
    Thanks for the video, I was able to re-create, however, once I choose my first drop down and then try to change that value, nothing happens, it doesn't update the other fields...any idea why?

  • Anonymous
    March 22, 2011
    The comment has been removed

  • Anonymous
    May 26, 2011
    Hello Anson Anyone else having a problem with audio. Other video/audio files work. No sound for your tutorial. Thank you. Lanny

  • Anonymous
    September 01, 2011
    Good video. It would help if you slow it down a bit son viewers would not have to keep clicking back to a section to see the how to.

  • Anonymous
    September 20, 2011
    Hello Anson, nice demo of cascading. It also looks so flashy! I' m working on a cascading dropdown but it turns into a performance horror. Each field takes 13 seconds to update!! And I have ten of them :-( I changed a standard list form with Infopath 2010 to crate a custom Action list. Among other fields, it contains 10 cascading dropdownfields (all linked together). The data for these fields are retrieved from a secondary dataconnection (a SharePointlist named Inventory). This list consist of the same fields as my form as lookupfields to other lists (like location, stationstype or systemtitle). To show readable names in my dropdowns instead of ID's, I have dataconnections to the other lists (location, stationtype, systemtitle) and use filter these with ID's stored in Inventory. Here's an example of the xpath filter I use to show the systemtitle: Datasource: Systemtitle Filter: ID = Formula: xdXDocument:GetDOM("Inventory")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Systemtitle[ ../d:Locationcode = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Locationcode and ../d:Stationtype = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Stationtype and ../d:Functie = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Function Have you any idea what the perfomance issue can be? Thanx in advance Arthur

  • Anonymous
    November 02, 2011
    The comment has been removed

  • Anonymous
    February 10, 2012
    Does this work for Sharepoint 2007 Infopath forms as well?

  • Anonymous
    February 11, 2012
    Hi Kurt, Yes - this will work for 2007 Form Templates as well. Scott

  • Anonymous
    July 11, 2012
    Is there a step by step post that show you how create a list that the rules and filters pull from. novice here.  ps silverlight audio is not working in our domain.

  • Anonymous
    November 27, 2013
    can I get a copy of this form .. :)

  • Anonymous
    January 30, 2014
    gj, i'd listen about "randomize picks" also