SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've got a cascading dropdown question. I'm trying to accomplish this with using SPServices , but I'm running into difficulty when two of the fields should just auto populate. Here's an example:

App:                 User:                    Admin:                   level:
x                     bob                      joe                      3,8,9
y                     carol                    anna                     2,3,1
j                     frank                    lynn                     7,9,0

so, if the user selects: "x" it should auto populate "bob" and "joe"..... level will stay a selector.

Any help?? Should I go about this totally different?

Here's an example of how it should work, but with fields from a sharepoint list : Example

Here is the script that I'm currently using.

<script language="javascript" type="text/javascript" src="../../../../SiteCollectionDocuments/jquery.SPServices-0.5.8.js"></script>
<script language="javascript" type="text/javascript">
    $(document).ready(function() {
            relationshipList: "Business_Owners",
            relationshipListParentColumn: "Apps",
            relationshipListChildColumn: "Title",
            parentColumn: "Application",
            childColumn: "Business Owner",
            debug: true

         relationshipList: "Security_Admins",
         relationshipListParentColumn: "Application",
         relationshipListChildColumn: "Title",
         parentColumn: "Application",
         childColumn: "Security Admin",
         debug: true

         relationshipList: "Security_Level",
         relationshipListParentColumn: "Application",
         relationshipListChildColumn: "Title",
         parentColumn: "Application",
         childColumn: "Security Level",
         debug: true


I tried applying this HERE with no luck.

share|improve this question

I don't think the cascade drop downs is what you want in this case. Cascade drop downs just filters available choices and is a bridge between missing OOTB Sharepoint features and InfoPath.

I'd tackle it with a function that calls GetListItems to fetch the data from the list since you aren't looking to really filter the data choices, but populate existing fields based off a selection in another field.

Here's a snippet that I'm using to prepopulate a field (on presave). You could bind it to a blur or onchange function of your initial drop down list.

    operation: "GetListItems",
    async: false,
    listName: "Labs",
    CAMLQuery: "<Query><Where><Eq><FieldRef Name='Lab_x0020_Location'/><Value Type='Text'>" + $("input[title$='Lab']").val() + "</Value></Eq></Where></Query>",
    completefunc: function (xData, Status) {
      $(xData.responseXML).find("[nodeName='z:row']").each(function() {
   $("input[title='Lab ID']").val($(this).attr("ows_LabID"));
    }); //close each
  } //close complete
}); //close SPServices
share|improve this answer

have you looked through the SPService documentation, and through the discussion threads? what you describe seems straight forward. put together a sample of the code, and then we can walk you through it. spservice cascading dropdown


share|improve this answer
SPService documentation was the first place I looked. – spd09 Mar 2 '11 at 18:43
I added my script in the post. Thanks! – spd09 Mar 2 '11 at 18:47
are you adding this in a CEWP? Where are you adding the references to jQuery and SPServices? What errors are you getting? – user2519 Mar 2 '11 at 19:13

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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