SPServices - Cascade Feature Not Functioning

May 21, 2013 at 5:26 PM
Hi -

Thanks for taking a look at my situation...

Previously used InfoPath solution to successfully develop cascading dropdown fields for Office 365 SharePoint 2013 list. Now I need to develop the same functionality for the library. Unfortunately InfoPath is no longer an option for library new item & edit forms...

Found several blogs suggesting addition of jquery to list edit form. Thought I would see if I could duplicate on sample lists prior to converting to library with no luck. The edit form - "city" field does not populate when a "country" is selected. (None) response remains in the city dropdown. Here is the detail -

I can confirm that jQuery and SPServices is working fine by following http://sympmarc.com/2011/07/08/adding-jqueryspservices-to-a-sharepoint-page-step-one-always/.

I have set up Cities list containing Title & Country fields. Country is a lookup column to the Country list.

On the Vacation Plans list - edit form I have Country & City lookup columns looking back to their perspective lists.

Code snippet inserted in Vacations Plans - Edit Item form after <asp:Content ContentPlaceHolderId="PlaceHolderMain" runat="server">. (Using SP Designer 2013 to insert code)
<script type="text/javascript" src="../../Scripts/jquery-1.9.1.js"></script>
<script type="text/javascript" src="../../Scripts/jquery.SPServices-2013.01.min.js"></script>
<script type="text/javascript">
            relationshipList: "Cities",
            relationshipListParentColumn: "Country",
            relationshipListChildColumn: "Title",
            parentColumn: "Country",
            childColumn: "City",
            debug: true
Reference Images:
May 21, 2013 at 6:25 PM
SPServices won't work with jQuery 1.9.1, as noted on the home page. There's a bug in that version of jQuery with XML.