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!

3

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

  • Is SharePoint Server required to create the Term Set? – user3380049 Dec 15 '14 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

  • Single line reply, broken link. – Jorge Carvalho Aug 4 '15 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.

We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.

  • Please don't add the same answer to multipel questions, Ricardo. Ref: sharepoint.stackexchange.com/a/116310/6382 – Benny Skogberg Sep 25 '14 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 '14 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 '14 at 8:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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