1

I created Three Lists :

  • Countries {Title}
  • Regions {Title,Country(Lookup link with Title of Countries List)} and
  • States {State,Region Name(Lookup link with Title of Regions List), Country Name (Lookup link with Title of Countries List)}

In the States List , I added Script Editor Web Part to Newform.aspx , but it didn't filter The Regions Name with Selecting Country Name this is The Script That Embed With Page :

<script language="javascript" type="text/javascript" src="../../jquery-1.8.2.js"></script>
<script language="javascript" type="text/javascript" src="../../jquery.SPServices-0.7.2.min.js"></script>
<script language="javascript" type="text/javascript">
$(document).ready(function() {

     $().SPServices.SPCascadeDropdowns({

    relationshipList: "Regions",
    relationshipListParentColumn: "Country",
    relationshipListChildColumn: "Title",
    relationshipListSortColumn: "ID",
    parentColumn: "Country_x0020_Name",
    childColumn: "Region_x0020_Name",
    debug: true
      });
});
5
  • parentColumn and childColumn should be display names, not internal names: Country Name and Region Name
    – Erin L
    Commented Aug 10, 2016 at 15:11
  • Thank You , it worked fine , but i have another issue ,,, when i try to make the Country Name as Require , filtering doesn't work why ? Commented Aug 10, 2016 at 15:18
  • Try using the newest version of SPServices: v. 2014.02. According to Marc, the required field issue is fixed in this version: sympmarc.com/tag/codeplex
    – Erin L
    Commented Aug 10, 2016 at 15:25
  • another thing , assume that i have two static countries (USA,CANADA) , Can i do This Filtering Without Creating Country List Commented Aug 10, 2016 at 15:28
  • Not using SPCascadeDropdowns. It would be possible with JSOM, but I don't think it would be worth the effort.
    – Erin L
    Commented Aug 10, 2016 at 15:29

1 Answer 1

3

parentColumn and childColumn should be display names, not internal names: Country Name and Region Name

Your Answer

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

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