Concatonating Text with Drop down box values - InfoPath Dev
in

InfoPath Dev

Concatonating Text with Drop down box values

Last post 10-19-2012 03:17 PM by Ladyblitz. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 10-19-2012 01:45 PM

    • Ladyblitz
    • Not Ranked
      Female
    • Joined on 10-19-2012
    • Gilbert, AZ
    • Posts 4

    Concatonating Text with Drop down box values

    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!

  • 10-19-2012 02:20 PM In reply to

    Re: Concatonating Text with Drop down box values

    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. :-)

    Hilary Stoupa

  • 10-19-2012 03:17 PM In reply to

    • Ladyblitz
    • Not Ranked
      Female
    • Joined on 10-19-2012
    • Gilbert, AZ
    • Posts 4

    Re: Concatonating Text with Drop down box values

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

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.