Multiple cascading dropdown lists working together

Home Forums Cascading dropdowns Multiple cascading dropdown lists working together

Viewing 5 reply threads
  • Author
    Posts
    • #8663
      cnibert
      Participant

        Is it possible to make two separate lists work off of one another? I have two lists, the first one uses the user’s domain address to pull up all of the divisions and cost centers associated with that domain. The second list needs to look at the domain that was selected from the first list, and then propagate a field for software options related to each domain.

        The reason I’m trying to use two separate lists is because with these options the list will be pretty huge as I’d have to have so many redundant lines in there to account for everything.

        Here’s my debug info at the moment, it says number of items returned is 2 which is right, but the Software dropdown is still a single line of text for some reason. Also the CompanyEmailDomain is from the “Parent” list in this case:

        
        
        [SPJS Cascading dropdowns v3.523]
        Function called with these arguments:
        lookupList:SoftwareCompanies
        lookupListBaseUrl:{currentSite}
        lookupListFields:Title,Software
        thisListFields:CompanyEmailDomain,Software
        dropDownDefaultvalue:
        hideEmptyDropdowns:false
        autoselectSingleOption:true
        clearInvalidSelection:true
        debug:true
        numberOfDropdowns:2
        Populating this field
        Software
        CAML query
        <Where><Eq><FieldRef Name='Title' /><Value Type='Text'>domain.com</Value></Eq></Where><OrderBy><FieldRef Name='Software' Ascending='TRUE'/></OrderBy>
        Looking for values in this field
        Software
        Number of items returned
        2
        • This topic was modified 9 years, 1 month ago by cnibert.
      • #8735
        Alexander Bautz
        Keymaster

          Hi,
          Sorry, but this is not possible with SPJS-casc. You can however make it work if you use the spjs-lookup solution, but it will need some custom coding to make one filter the other.

          If you haven’t already found another solution, I might be able to help you with an example sometime later this week. Let me know if you need my help.

          Alexander

        • #11084
          Eduardo Gutierrez
          Participant

            Alexander, we are trying to do something like that in our case we have to create an account structure like this 404.45.404.7345.0000.00.052000
            for this accout we have to choose every segment using a lookup field for each on of them
            406 is the company code
            45 is the business unit code
            404 is the site code
            7345 is the cost center code
            0000 is the interco site code (used by default)
            00 is the interco businee unit code (used by default)
            05200 is the count code (used by default)
            and finally, we need to to restrict the cost center by authenticate user
            the company code is use to define the filter for the businee unit list and site list; and the combination of these must be the filter for the center cost list plus the autheticate user permission over the cost center, this means the user only can see the cost center available for each one of them.
            You may accomplish this with javascript or some other technology? wait for your comments.

            Best Regards!

            Eduardo

            Attachments:
          • #11124
            Alexander Bautz
            Keymaster

              Hi,
              First you must have the data source in the same site collection for this to work.

              The cascading dropdown solution cannot take additional filters (other than the default filter that is built in to find all subsequent options), but you can add more filters by using the “spjs-lookup” solution – chaining together the dropdowns “manually”. Take a look at this post to see if you might be able to use this approach: https://spjsblog.com/forums/topic/combing-spjs-lookup-with-cascading-dropdowns/

              I’m not sure I fully understand the access restrictions to the cost center. Is the “Cost center” a list in the same site collection? Are you using item level security on these items?

              Alexander

            • #11160
              Eduardo Gutierrez
              Participant

                Hi Alexander,
                The cost center field should change depending on the user and type of combination of previous fields This functionality can be done with Javascript?

                Regards!

                Eduardo

              • #11183
                Alexander Bautz
                Keymaster

                  Hi,
                  I’m not 100% sure I understand, but have you set up the first three levels as a cascading dropdown, and only lack the lats step to filter the cost center?

                  If so, what filter criteria would be used to query for the cost center – is it the value from the third dropdown combined with the logged in user?

                  How do you plan to user the current user as a filter – does the cost center have a people or group field where the user or a group the user is member of is selected?

                  Alexander

              Viewing 5 reply threads
              • You must be logged in to reply to this topic.