Multi-select cascade to multi-choice

Home Forums Cascading dropdowns Multi-select cascade to multi-choice

Viewing 2 reply threads
  • Author
    Posts
    • #16269
      chgrnet
      Participant

        I love your cascades, they are easy to setup and use.

        I have a need to have selections in a cascade be filter selections in a list/datasheet view. I know that a multi-line of text field does not do that, but is there a way, if I created a new (hidden) multi-choice field, to output the data from the cascade multi-line of text to the (hidden) multi-choice? The “hidden” multi-choice field would only ever be updated when the form is updated (EditForm.aspx) and the cascade changes.

      • #16283
        Alexander Bautz
        Keymaster

          Sorry, but I’m not sure how this will work out – it seems kind of cumbersome. How would you pass the filters to the datasheed view?

          Alexander

          • #16286
            chgrnet
            Participant

              When in a datasheet or list view, when you use a lookup or choice/multi-choice you can use the title row to filter items in the list. Because your cascades for multi are a multi-text, this is not available. I do need this filter ability, so I was wondering if there was a way to write code to another field that could allow a paste into a multi-choice field (in the background). Your fields display like this:
              Item 1;
              Item 2;
              Item 3;

              To paste into a multi-choice, they need to be formatted like this:
              ;#Item 1;#Item 2;#Item 3;#

              If I can format the data like above, and put it in another field (it can be a multi-line text), then I could get it into a multi-choice, and what I need to do can be done. This transfer would happen in the background and the field would be hidden on the form, but I would show it on the list or datasheet view.

              I understand if my ask does not make sense, and it may not be possible, and that is fine. I really wanted to use your cascades, but I have to be able to filter the data from a list or datasheet view and right now, it won’t work.

          • #16405
            Alexander Bautz
            Keymaster

              Sorry for the late reply. Unfortunately I don’t think this world work that well because you would have to maintain a multiselect field with all possible options you could select in the cascading dropdown.

              I’m guessing you are better off using the built in multilookup field in SharePoint.

              Alexander

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