Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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() {
        $().SPServices.SPCascadeDropdowns({
            relationshipList: "Business_Owners",
            relationshipListParentColumn: "Apps",
            relationshipListChildColumn: "Title",
            parentColumn: "Application",
            childColumn: "Business Owner",
            debug: true
        });

      $().SPServices.SPCascadeDropdowns({
         relationshipList: "Security_Admins",
         relationshipListParentColumn: "Application",
         relationshipListChildColumn: "Title",
         parentColumn: "Application",
         childColumn: "Security Admin",
         debug: true
      });

          $().SPServices.SPCascadeDropdowns({
         relationshipList: "Security_Level",
         relationshipListParentColumn: "Application",
         relationshipListChildColumn: "Title",
         parentColumn: "Application",
         childColumn: "Security Level",
         debug: true
      });


    });
</script>

I tried applying this HERE with no luck.

share|improve this question
add comment

2 Answers 2

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

Jason

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
add comment

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.

$().SPServices({
    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
add comment

Your Answer

 
discard

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.