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!

Improve this question

5 Answers 5

Reset to default
3

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

Improve this answer
1
  • Is SharePoint Server required to create the Term Set?
    – user3380049
    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.

Improve this answer
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.

Improve this answer
-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

Improve this answer
1
  • Single line reply, broken link.
    – Jorge Carvalho
    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.

Improve this answer
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?
    – Ricardo Peres
    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.