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
      });
});
  • parentColumn and childColumn should be display names, not internal names: Country Name and Region Name – Erin L Aug 10 '16 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 ? – taher mohammad Aug 10 '16 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 Aug 10 '16 at 15:25
  • another thing , assume that i have two static countries (USA,CANADA) , Can i do This Filtering Without Creating Country List – taher mohammad Aug 10 '16 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 Aug 10 '16 at 15:29
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, privacy policy and cookie policy

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