Concatenate 2 form variables

  • 22 October 2014
  • 4 replies
  • 372 views

Badge +4

Hi,

 

Is there a way we can concatenate 2 form variables please. One form variable is a String and another a numeric (I can make that a string too). However, I could not find any option to concatenate both of them to give me a single string. Any leads on how to achieve this please. Thanks

 

Sam


4 replies

Userlevel 5
Badge +12

You could use a calculated field to easily achieve this.  Simply build the formula to be something like {Var1}{Var2} and they will be concatenated.  There are other ways to do it, but this way will be visual on the form itself.

Badge +4

Hi mmatsako,

your suggestion worked perfectly. thanks a lot. appreciate it.

Badge +7

For some reason, I could not get Mike's way to work. What did work for me:

Var1 + " - " + Var2

Did this in order to have values separated by a " - "

Badge +9

This is the one that worked for me too. I wanted them to be concatenated without any dashes or spaces, so I just added a calculated field on the form and used the named controls. 

Var1+Var2

Reply