Concatenate fields

[Kuroshi]

I want to have a result that will concatenate the Name field if they have the same 'Title' and 'GroupName'. Is that possible using calculations or is there any solution?

[Barbie]

Hi @Batchini,

I think the best way to achieve this is using triggered action since you want to concatenate all values in one field based on a criteria. Fortunately, I tried to achieve this kind of workflow before. You can refer to this Trigger:

I hope this works on your end. 

 

- Barbie

[Barbie]

In addition, here's an article and video link for more info about Triggered actions: 

https://howto.caspio.com/tables-and-views/triggered-actions/
http://youtube.com/watch?v=ZdkQOvLX4ok

[BaySunshine]

Hi @Batchini,

You can use calculated value or field if you want to concatenate the fields from the same record. Can you give an example so I can provide you a better solution?

Regards,

[Queso]

Hi... just wanted to help. I think this is possible using formula with a CASE statement.  You may try the following:

CASE WHEN [@field:Title] = [@field:Group_Name]

THEN [@field:First_Name] + ' ' + [@field:Last_Name]

ELSE

' '

END

 

Here is the result:

You can change the output depending on what you need to concatenate. 

[autonumber]

Just to add to trickson's answer, you can also check this article that shows the list of formulas that you can use in Caspio. It provides a sample that you can use as a guide.

https://howto.caspio.com/function-reference/