Concatenate In The Calculated Field

[Elena]

Hello,

 

Is there a way to perform concatenation in the calculated field instead of a JScript?

 

I was issuing this syntax and it is not working on the calculated field.

 

CONCATENATE([@field:First_Name],[@field:Last_Name]))

 

Please help.

 

[casGary]

Hi Elena,

In JavaScript it is the concat() method, but not concatenate().

have a look http://www.w3schools.com/jsref/jsref_concat_string.asp

Hope it helps.

[casGary]

Calculated field is ment to do some math calculations, if you need to concatenate strings, virtual fields should work better.

[Elena]

oh that JS string worked. Thank you.

[cheonsa]

Hi,

 

I know it's late. But, as per update, you can perform concatenation using calculated field without using JavaScript.

You just have to perform a basic calculation just like this:  

 

Regards,

kristina

[MayMusic]

As a quick tip in most of the cases, you need to use single quote in SQL syntax in Caspio

[NailDyanC]

Hi, just to add and update this post. For functions that you can use in your calculation or formulas, you may go directly to this link: https://howto.caspio.com/function-reference/