Re: Multi Select Output to Text Field

RaYvA — Thu, 20 Mar 2014 13:50:51 GMT

Hi Robb, if you were to promote that field to the SharePoint list it would fill with only the selected items showing.

If you want it in another field, then you have to get a little tricky (although I don't think there is a way to get it with line breaks).

Using a default value for your text field of: substring(eval(eval(YOURFIELDNAME[. != ""], 'concat("; ", .)'), ".."), 3) would always update the field whenever items are ticked or unticked and would then display the ticked items with semicolons in between, so in you case Bob; Mike. Essentially the formula evaluates your multi select field for any item that is ticked, the [. != ""] is the filter - which is doesn't equal nothing, and concatenates them together with the '; ' in between.

If you have trouble entering the above expression, switch to 'Edit Xpath (advanced) in the Fx dialog and then the expression is: substring(xdMath:Eval(xdMath:Eval(../my:YOURFIELDNAME[. != ""], 'concat("; ", .)'), ".."), 3)

Make sure you have the 'Refresh value when formula is recalculated' the on the Data tab of the et box.

Hope this helps.

Multi Select Output to Text Field

Robb2k15 — Tue, 18 Mar 2014 21:00:33 GMT

Hello! I am fairly new to InfoPath and unfortunately I am building a rather robust change control form inside of SharePoint 2010 and I am using InfoPath 2013 designer. I have a multi select (check mark) box with 100+ items. When someone marks a check I want it to input to an adjacent text box.

Example:

List

(Check) Bob

Dave

(Check) Mike

Output to Field

Bob

Mike

I've found ways to make it show up, but it seems buggy. I've tried a value rule, but if you check something new it over writes the previous, and if you uncheck it, it doesn't go away. If you can help, please explain as if you were writing to an idiot, because I'm rather slow and I don't know much on programming as I am a SharePoint Admin (OPS side).

Thanks!

Newbie Questions

Re: Multi Select Output to Text Field

Multi Select Output to Text Field