Multiple values in one text field - InfoPath Dev
in

InfoPath Dev

Multiple values in one text field

Last post 02-15-2007 04:08 AM by micky_maccaff. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 02-15-2007 02:55 AM

    Multiple values in one text field

    Is it possible to put the value of multiple text boxes into 1 text box?

    For Example I have 3 text fields

    Field 1 = Title (Mr, Miss, Mrs, etc)
    Field 2 = Name
    Field 3 = Surname

    I would like to have 1 text box that could store all 3 Fields in it.
    [Field 1, Field 2, Field 3]

    Any help would be great.
  • 02-15-2007 03:08 AM In reply to

    Re: Multiple values in one text field

    Hi,
    Using the concatination function we can insert multiple field values into one field.

    Hope this helps!
    Shilpa
    INFOPATHDEV India
  • 02-15-2007 03:30 AM In reply to

    Re: Multiple values in one text field

    Thanks that works well...

    Just a quick one - how do I get a space in between the values?

    It comes back like "MrNameSurname"

    I want "Mr Name Surname"

    thanks
  • 02-15-2007 03:54 AM In reply to

    Re: Multiple values in one text field

    Hi,
    Use the function in this way-
    concat(field1, " ", field2, " ", field3)

    Hope this helps!
    Shilpa
    INFOPATHDEV India
  • 02-15-2007 04:08 AM In reply to

    Re: Multiple values in one text field

    :-)

    I new I would leave something as simple as a comma out for it not to work.

    Thanks very much for your help, it's working exactly as I wanted it to.

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