Newbie Questions

Re: Multiple values in one text field

micky_maccaff — Thu, 15 Feb 2007 12:08:23 GMT

:-)

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.

Re: Multiple values in one text field

Shilpa Pitta — Thu, 15 Feb 2007 11:54:32 GMT

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

Hope this helps!

Re: Multiple values in one text field

micky_maccaff — Thu, 15 Feb 2007 11:30:43 GMT

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

Re: Multiple values in one text field

Shilpa Pitta — Thu, 15 Feb 2007 11:08:53 GMT

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

Hope this helps!

Multiple values in one text field

micky_maccaff — Thu, 15 Feb 2007 10:55:02 GMT

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.