General

Re: Dynamic Multi-select List Box - writing values to repeating table OR separate text fields (1 value per field)

justinf10000 — Tue, 11 Aug 2015 20:29:59 GMT

Sorry to revive an old thread, but im trying to do exactly this. I can't really tell what the solution was from reading the thread.

Can anyone help with this?

Re: Dynamic Multi-select List Box - writing values to repeating table OR separate text fields (1 value per field)

A.Brown — Thu, 12 Sep 2013 01:55:41 GMT

Yes! That is precisely what I was trying to do! I am so grateful for your help, I never would have figured that out! I can't thank you enough!

Now to just figure out how to apply the same concept in my much longer version... But, I think, thanks to your video tutorials on XPath and your example, I should be okay from here :)

Re: Dynamic Multi-select List Box - writing values to repeating table OR separate text fields (1 value per field)

Hilary Stoupa — Thu, 12 Sep 2013 00:26:09 GMT

Save the attached form locally and then right click and select design - from there you can look at it and preview. What I did was change the section where you were wanting to display just the work groups for the CSR - it is all bound to the SharePoint List data source now. I added some XPath conditions to hide things so that the CSR name is only displayed one time and the work groups for the CSR are displayed in a cell next to the CSR name - take a look & let me know if this was what you were trying to do.

Re: Dynamic Multi-select List Box - writing values to repeating table OR separate text fields (1 value per field)

A.Brown — Wed, 11 Sep 2013 21:01:51 GMT

Thank you so much! I surely appreciate any time you would be willing to lend to my issue.

I've come up with a workaround for in the meantime that will at least partially work, but it really takes away from the overall functionality and use of the form. Instead of using a repeating section or table to contain the name and nested table, I set up individual sections and simply hid the unused ones. This is annoying because I have to manually create each section and will have to limit users to how many selections they can make per form, which they won't like. I am also back to having the user manually choose the names to perform the workgroup lookup on with a drop-down, which isn't too terribly awful, it's just not as quick and easy as the way I would rather do it.

Looking forward to seeing if anyone can help with getting my original idea to work before I deploy; it would go over much better with my audience!

Re: Dynamic Multi-select List Box - writing values to repeating table OR separate text fields (1 value per field)

Hilary Stoupa — Wed, 11 Sep 2013 20:07:00 GMT

Thanks for the sample - I get what you are trying to do now. I'll see if I can come up with some ideas - may be late today before I have a chance, though. :)

Re: Dynamic Multi-select List Box - writing values to repeating table OR separate text fields (1 value per field)

A.Brown — Wed, 11 Sep 2013 19:27:59 GMT

Thank you for your response, Hilary!

Here is a simplified version with some sample data included.

Re: Dynamic Multi-select List Box - writing values to repeating table OR separate text fields (1 value per field)

Hilary Stoupa — Wed, 11 Sep 2013 18:52:34 GMT

Do you mind attaching your sample form to a reply? Under the options tab... I'm having a little trouble understanding the scenario, and I think seeing your form would help me get it.

Re: Dynamic Multi-select List Box - writing values to repeating table OR separate text fields (1 value per field)

A.Brown — Wed, 11 Sep 2013 01:03:08 GMT

Turns out getting the selections to a repeating table was quite easy. All I had to do was drag the repeating field to another section and choose repeating table. (I'm always trying to make things more complicated than necessary...aye.)

What I am really stuck with is the look-up part once I have retrieved those values.

I want to use the same secondary data source that populated the list box as a repeating table within that repeating table, and filter or hide rows where the IDs do not match. I have googled and searched this forum for days, and am not having any luck with anything but almost-solutions.

I have found how to have the repeating table within the repeating table populate on one entry, but not on more than one, but only was able to do that when I was having the user populate the first field manually.

Here is a simplified version of what I am trying to do:

My fields:

My other thought if I cannot get the nested repeated table part down was to try to write the values from the MSLB to a series of text fields where I would simply hide any un-used text fields.

I was able to create a single text box and use a double eval with concat to find the selected values, and thought from there I could find a way to parce out each individual entry to its own text box, but I just don't have enough working knowledge of text functions to get very far down that road, either. I have a feeling I'm simply trying to take on a bit too much with my limited knowledge, but, well, that's kind of my style....

Dynamic Multi-select List Box - writing values to repeating table OR separate text fields (1 value per field)

A.Brown — Tue, 10 Sep 2013 17:03:01 GMT

Hello,

I have found many posts in this forum that are almost what I am trying to do, but so far I am unable to apply what I have read to my challenge, and I am stuck. I am hoping someone can help!

I have a multi-select list box populated by a secondary data source, filtered by a user's selection in another field. Utlimately, I need to perform a look-up elsewhere on each item the user selects from the multi-select list box. My thoughts for doing this are to write the selected values to a repeating table or another set of fields and then perform the look-up from that field (the look-up is a repeating table, retrieiving an unknown number of results based on the value.)

How can I retrieve the selected values from the list box to have them populate to another set of fields? I have figured out how to do this when I have a static source for the list box options, but in my scenario, the number of options could vary from 2 to 20 or more.

I hope my question makes sense. Please let me know if I can further clarify. I am relatively new to InfoPath, and particularly new to trying to use any type of coding with InfoPath, but I've struggled through a few scenarious successfully so far.