Dismiss Notice

Register now to be one of the first members of this SharePoint Community! Click here it just takes seconds!

Dismiss Notice
Welcome Guest from Country Flag

SPServices Cascading Dropdown help (special circumstance, I have several that work fine)

Discussion in 'Official Microsoft News' started by Microsoft SharePoint, Dec 11, 2015.

Thread Status:
Not open for further replies.
  1. Microsoft SharePoint

    Microsoft SharePoint Guest

    Blog Posts:
    0
    So I'm trying to do this with people fields, but I think I have it setup right, however I say that, yet it's not working.

    I use People fields first, I enter their IDs, it populates their names.

    Then the workflow puts their Display Names and Email Addresses into Single Line of text columns, so I end up with 3 columns. In my mind, this SHOULD work since the people fields are being copy and pasted into Single Line of Text fields that I can reference for my lookups.

    Below is my layout (SLOT = Single Line of Text)

    Here goes:

    List 1 - "SC_VPs" - Vice Presidents

    VP (people field) VP_Name_Text (SLOT) VP_Email (SLOT)

    List 2 - "SC_AVPs" - Assistant Vice Presidents

    AVP (people field) AVP_Name_Text (SLOT) AVP_Email (SLOT) VP (looked up from list 1 VP_Name_Text field)

    List 3 - "SC_AVP_Support" - AVP Support

    AVP_Support (people field) AVP_Support_Name (SLOT) AVP_Support_Email (SLOT) AVP (looked up from list 2 AVP_Name_Text field)

    Master Dropdown list

    VP (lookup from list 1 VP_Name_Text AVP (lookup list 2 AVP_Name_Text) AVP Support (lookup list 3 AVP_Support_Name)

    This is what I've tried and it isn't working:

    <script src="myjavascriptURL" type="text/javascript"></script> <script src="mySPServicesURL" type="text/javascript"></script> <script type="text/javascript"> //Execute the following JavaScript after the page has fully loaded, when it's ".ready" $(document).ready(function(){ $().SPServices.SPCascadeDropdowns({ relationshipList: "SC_AVPs", relationshipListParentColumn: "VP", relationshipListChildColumn: "AVP_Name_Text", parentColumn: "VP", childColumn: "AVP" }); $().SPServices.SPCascadeDropdowns({ relationshipList: "SC_AVP_Support", relationshipListParentColumn: "AVP", relationshipListChildColumn: "AVP_Support_Name", parentColumn: "AVP", childColumn: "AVP_Support" }); }); </script>
    submitted by Grits_N_Gravy_23
    [link]
     
Thread Status:
Not open for further replies.

Share This Page

LiveZilla Live Chat Software