How to add concatenated list box fied

[#1]

Hi ,

I have a list box where I need to add a concatenated filed. At the moment its allowing me to specify only one filed ?

I understand that I can change the script SQL and add a new field. Rather than doing that way is there an easy workaround ?

Thanks in advance

Buminda

[sushil353 · Accepted solution]

Hi,

in the Field drop down goto > Expression and there you can write =Field1&Field2

HTH

Sushil

[Anonymous]

Hi,

in expression tab you can concatenate the fields with  this &(symbol).

like....filed1 & filed2

and you can name it as single filed in title.

[#4]

Thanks Sushil, this worked.

[#5]

Thanks , yes this helped me.