Controls

Re: writing values from a multiple-selection list box to another control

Hilary Stoupa — Fri, 12 Jul 2019 15:58:49 GMT

The extra stuff was an XPath filter - basically - "If this field is not blank, I want it" :) I like this site for learning XPath: http://zvon.org/xxl/XPathTutorial/Output/examples.html and I also have a blog post that shows a tip for using InfoPath to help learn XPath: https://www.infopathdev.com/blogs/hilary/archive/2012/05/31/use-infopath-to-teach-yourself-xpath.aspx

Re: writing values from a multiple-selection list box to another control

noram — Fri, 12 Jul 2019 15:48:27 GMT

I have no idea what that extra stuff means but it worked perfectly. Do you have any recommendations on some kind of guide or how to basics on writing these kinds of formulas?

Thank you!

Re: writing values from a multiple-selection list box to another control

Hilary Stoupa — Thu, 11 Jul 2019 22:16:47 GMT

Yup, multiple section list boxes have a default blank item. You have to add a filter to your field: substring(eval(eval(field19[. != ''], 'concat(", ", .)'), "..") , 2)

Re: writing values from a multiple-selection list box to another control

noram — Thu, 11 Jul 2019 21:40:06 GMT

I opened what you have, and I have exactly the same formula (except the field obviously). The difference is I'm using a multiple selection list box instead of a repeating table that you enter info into. Do you think this makes a difference? Also my list is coming from a SharePoint List. I am still getting the comma in front of the first item in the list. It shows up as: , Apples, Oranges, Bananas, Peaches

Re: writing values from a multiple-selection list box to another control

Hilary Stoupa — Thu, 11 Jul 2019 21:03:12 GMT

Here's a sample. Save the file locally, right click, select design and preview. Enter rows in the repeating table and add data to the field to see the comma delimited expression below.

Re: writing values from a multiple-selection list box to another control

noram — Thu, 11 Jul 2019 20:51:42 GMT

That removed the comma at the end, but not the one at the beginning. I'm really new to writing these formulas, I keep messing with it I just can't seem to get it.

Much appreciated!!

Re: writing values from a multiple-selection list box to another control

Hilary Stoupa — Thu, 11 Jul 2019 20:24:50 GMT

You can use a substring formula and swap the comma and the node. substring(eval(eval(field19, 'concat(", ", .)'), "..") , 2) I think will do it.

Re: writing values from a multiple-selection list box to another control

noram — Thu, 11 Jul 2019 20:19:19 GMT

Hi - I know this particular message is very old, but my attention was caught by

"I also did some touchups to prevent extraneous semicolons at the beginning and end of the list."

My rule is working fine, but I have the annoying commas before and after the items. I do want them separated by commas, but I hate how it looks at the beginning and end. How did you accomplish this or does anyone else know how to "pretty" it up?

eval(eval(field19, 'concat(., ", ")'), "..") is what I have from a multiple selection list into a calculated value control.

Thanks!

Re: writing values from a multiple-selection list box to another control

TOE_CHEESE — Wed, 03 Jul 2019 21:57:18 GMT

Thanks Hilary. That's what I needed.

Re: writing values from a multiple-selection list box to another control

Hilary Stoupa — Wed, 03 Jul 2019 20:05:01 GMT

See attached.

Re: writing values from a multiple-selection list box to another control

TOE_CHEESE — Wed, 03 Jul 2019 19:56:27 GMT

Okay, I've attached what I got so far. I can make multiple days from the list and click on the button Add to List Textbox and that works. I would like to be able to select one or more days from my list, select a date and add them to my list in the format Mon: 2019-07-03, Tue: 2019-07-03, etc. I would then like to be able to change my selections and the date, and add those items to the list.

Re: writing values from a multiple-selection list box to another control

Hilary Stoupa — Wed, 03 Jul 2019 19:15:02 GMT

Probably. :) Where is the date value? Can you attach your form (or a sample) and I can give you a hand.... Under the Options tab in a reply.

Re: writing values from a multiple-selection list box to another control

TOE_CHEESE — Wed, 03 Jul 2019 18:59:23 GMT

I know this is an old post but since it is related to my challenge I thought I'd add to it. I can get multiple selections concatenated into another field (textbox). My challenge is that I want each selection concatenated with a date value and then concatenated into a text box. Does anyone have a solution for that?

Thanks,

Re: writing values from a multiple-selection list box to another control

Hilary Stoupa — Wed, 01 Feb 2017 15:45:36 GMT

Oh good, glad that worked. Yeah, I've had a real issue w/ multi-selects and often find I can use a rule where a default won't work, esp. if this is for something where the field doesn't need to update real-time. :)

Re: writing values from a multiple-selection list box to another control

Catharine — Wed, 01 Feb 2017 13:05:19 GMT

Hi Hilary,

As ever - a super hero ! Yes when I add nothing happens - but when I delete it populates. I have moved the double eval into a set value rule, and that seems to work ok.

Thank you for your advice

Catharine.