Cascade Dropdown Conflict

May 27, 2015 at 6:44 PM
Hello,

I have a page on which I am trying to use a "Region" drop down to populate two other drop downs.

First, the user chooses a Region. Next the user has to choose one of the Locations in that Region, and one of the managers for that region. The manager selection is independent of the location selection. I am trying to achieve this using the following code:
       $().SPServices.SPCascadeDropdowns({
          relationshipList: "Locations",
          relationshipListParentColumn: "Region",
          relationshipListChildColumn: "LocationName",
          relationshipListSortColumn: "",
          parentColumn: "Region Required Field",
          childColumn: "Location Required Field",
          selectSingleOption: false,        // Added in v0.6.2
          matchOnId: false,         // Added in v0.7.1
          completefunc: null,
          debug: true       
        })   
      
      $().SPServices.SPCascadeDropdowns({
          relationshipList: "Managers",
          relationshipListParentColumn: "Region",
          relationshipListChildColumn: "MgrNameForLookup",
          relationshipListSortColumn: "",
          parentColumn: "Region Required Field",
          childColumn: "ApprovingMgr Required Field",
          selectSingleOption: true,     // Added in v0.6.2
          matchOnId: false,         // Added in v0.7.1
          completefunc: null,
          debug: true         
        })
When the page loads, only the first SPCascadeDropdowns function appears to work. The other does not seem to work.

Both functions work when they are the first function in the code, but neither works as the second function. I'm curious if there is a better way to load these so that they are both able to work at the same time?

Thanks for your help.
May 28, 2015 at 4:02 PM
Again, it seems that this issue was related to the "Required Field" being appended to the field titles. i thought this had been fixed in SPServices, but apparently this issue can still get through. I am using SPServices version 2014.2 on SharePoint 2013.