SharePoint 2013: Cascade Dropdowns using SPServices

Excellent post without the need to edit Master Pages nor create custom New/Edit forms on the list.

SharePoint

Using Jquery.SPServices, you can achieve cascade dropdown in SharePoint. In Cascade dropdown, upon selection of value from first drop down, other drop down’s value gets filtered.

For example, if you have a requirement to display items based on category selection or you want to display states based on country selection. This type of feature, you can use cascade drop downs.

 Create following custom lists in SharePoint.

ItemCategory List

Cascade1

Items List – This has Category lookup column from ItemCategory.

Cascade2

CascadeDemo List – This has ItemCategory and Item lookup columns from ItemCategory and Items list.

Cascade3

Cascade4

In new item of CascadeDemo list, when selecting ‘Stationary” value from item category drop down, it should display only “Pencil” and “Notebook” in item drop down not all the items from list.

Here, you need to download jquery-1.11.0.min.js from http://www.jquery.com site and jquery.SPServices.min.js from http://spservices.codeplex.com/ site or you can use direct reference from online.

  •  Navigate to your…

View original post 207 more words

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s