Multiple cascading dropdown lists working together

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 5 years, 11 months 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.