3

I am new to SharePoint 2013. What I need to figure out is based on the following situation. I have several school districts with multiple schools within the school district. I would like to create a cascading dropdown that 1st lists the districts and then will automatically populate a list of schools within a particular district when the district is selected. Can someone tell me if this is possible and if so what steps do I take to achieve it?

Thank you!

5 Answers 5

3

I would suggest putting the districts and their schools in a Term Set and use a Managed Metadata column.

1
  • Is SharePoint Server required to create the Term Set? Dec 15, 2014 at 14:56
2

Paul's solution - managed metadata - works well if your list is stable and if you do not need to attach additional properties to each item (e.g. school address, contact, etc.).

An alternate option is to use two SharePoint lists:

  • one for the districts
  • one for the schools, with a lookup column that points to the districts list

Then you can create lists that have two lookup columns (pointing to districts and schools respectively), and use client side code to build the cascading behavior. This might sound complicated, but this is actually the most common way in such situations. Coding the cascading relationship is not trivial, but you can rely on existing solutions, for example:

InfoPath also offers the option to create cascading selections, however be warned that it is being phased out.

1

You can use SPServices Cascaded Dropdown functionality

Or you can modify list forms via InfoPath and achieve cascaded dropdowns, as shown in the following post:
How to create cascading dropdowns in InfoPath
[[The example relates to SharePoint 2010, but its the same for SharePoint 2013.]]

I hope you already know about Lookup columns, and know that Schools list will contain a Lookup column for District list.

-1

You can by SPServices... Please visit the following link for full tutorial http://sharepointkids.blogspot.in/2014/04/two-level-cascading-drop-down-in.html

1
  • Single line reply, broken link. Aug 4, 2015 at 6:17
-1

I have a simple solution without any JavaScript code: Cascading Drop Down Lists in SharePoint. Let me know if it solves your problem.

3
  • Please don't add the same answer to multipel questions, Ricardo. Ref: sharepoint.stackexchange.com/a/116310/6382
    – Benny Skogberg
    Sep 25, 2014 at 4:50
  • Really? And why not, may I ask? Is the answer correct on all the places or is it wrong? Sep 25, 2014 at 7:16
  • Further this is a link only answer, which would be unuseful if the link breaks in the future. Editing the answer and provide the code needed would greatly improve this answer. However, the answer may or may not be technically wrong, it's just not visible here. Please try to specify your answer...
    – Benny Skogberg
    Sep 25, 2014 at 8:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.