Re: Concatonating Text with Drop down box values

Ladyblitz — Fri, 19 Oct 2012 22:17:23 GMT

Thank you!! I've been tearing my hair out today to figure that out. I appreciate the quick response!

Re: Concatonating Text with Drop down box values

Hilary Stoupa — Fri, 19 Oct 2012 21:20:36 GMT

You have commas before the fields (that I'm guessing you used the field picker for) but not after...

concat("some text", fieldname, " some more text")

Comma before and after the field. :-)

Concatonating Text with Drop down box values

Ladyblitz — Fri, 19 Oct 2012 20:45:48 GMT

Hi All,

I'm just getting started with Infopath 2007 and I haven't been able to find an answer to this question elsewhere. I'm trying to populate a text box with text combined with the values from several drop down fields that are previously selected in the form.

I want the result to be something along the lines of:

Here is my text and I am [field1] and then I need [field2] and then there is [field3].

I have tried several iterations of an expression for this and I get errors everytime that a comma is expected.

concat("Based on your selection we recommend to use our standard architecture infrastructure in our Enterprise Architecture reference libary. This pattern applies to ",[field1]" Desktop Application with ",[field2]" supporting ",[field3]" transaction volume and ",[field4]" disaster recovery goal.")

I can't figure out what I'm doing wrong and any help would be greatly appreciated!

Thank you!

Newbie Questions

Re: Concatonating Text with Drop down box values

Re: Concatonating Text with Drop down box values

Concatonating Text with Drop down box values