locked
Cascading dropdown in sharepoint 2007 RRS feed

  • Question

  • I have a requirement like cascading dropdownlist for eg: 2 dropdowns (country and state) if I select United States in the country drop down it should display all the states in United States in the state dropdown list.

    Can any one help me, how to state with or else send me the relevant links.

    Thanks in advance
    Tuesday, April 8, 2008 7:06 AM

Answers

All replies

  • Tuesday, April 8, 2008 12:23 PM
  • Download this from Codeplex solved the issue for me

    http://customfieldcontrols.codeplex.com/

    • Marked as answer by G Vijai Kumar Wednesday, September 30, 2009 1:51 PM
    Monday, April 6, 2009 9:50 AM
    • Marked as answer by G Vijai Kumar Wednesday, September 30, 2009 1:51 PM
    Monday, April 6, 2009 10:52 AM
  • Anna, the link that u have given does not work.
    cool
    Tuesday, April 21, 2009 12:25 PM
  • You can refer following link if the above does not work.

    http://blog.12thwave.com/?p=7

    http://www.sharepointsnippets.com/post/2008/11/SharePoint-Cascading-Dropdown---Unlimited-siblings.aspx

    You can also download code from the same
    Tuesday, April 21, 2009 12:34 PM
  • The above mentioned code is not working for "Edit in Datasheet" mode. It just show the fields as read only in Datasheet. Do you have any solution which works for both Edit Properties and Edit in Datasheet.

    However it's also not working in Document Information Panel. But i am just looking for "Edit in Datasheet" mode. Anybody solved this issue?

    Thanks!!
    Wednesday, August 12, 2009 2:41 PM
  • One more possible solution http://www.sharepointdrive.com/blog/Lists/Posts/Post.aspx?ID=8
    Wednesday, September 30, 2009 1:28 PM
  • We've made the jQuery Library for SharePoint Web Services available on Codeplex.  With it, setting up cascading dropdowns is a snap.  For your example above, it would look something like this:

    <script language="javascript" type="text/javascript" src="../../jQuery%20Libraries/jquery-1.3.2.js"></script>
    <script language="javascript" type="text/javascript" src="../../jQuery%20Libraries/jquery.SPServices-0.3.1.min.js"></script>
    <script language="javascript" type="text/javascript">
      $(document).ready(function() {
        $().SPServices.SPCascadeDropdowns({
          relationshipList: "States",
          relationshipListParentColumn: "Country",
          relationshipListChildColumn: "Title",
          parentColumn: "Country",
          childColumn: "State"
        });
      });
    </script>
    

    M.
    Marc D Anderson - Sympraxis Consulting LLC - Marc D Anderson's Blog - @sympmarc
    • Proposed as answer by SanthoshSan Wednesday, January 20, 2010 10:01 AM
    • Marked as answer by Mike Walsh FIN Monday, June 20, 2011 1:40 PM
    Wednesday, September 30, 2009 2:01 PM