Triggered actions how to concatenate a text(64000) field with other fields?

[CapNcook]

Hi All,

We have a simple CMS and we want to concatenate a text(255) field and text(64,000) field via trigger. Is there a way to do that? it seems like we are getting an error when we attempt to do so. 

[ianGPT]

Hi @CapNcook you can use the following setup to concatenate a 64k field to a text244 field. But please note if the placeholder field exceeds the character it can hold it would result in truncation.

[CoopperBackpack]

Hello @CapNcook, @ianGPT, 

FYI: with this workaround, the concatenated string is always truncated so it never exceeds 3995 characters (as far as I tested this).

For example, Text 255 stores a string that consists of 100 characters, and Text 64000  stores a string that consists of 5000 characters. The concatenated string length is 3995 characters. 

Another option is to use a variable to store the Text 64000 value.  In this case, the string in the variable isn`t truncated when exceeds 3995 characters. 

[NiceDuck]

The error will occur if the system sees that the contamination you have set has exceeded the capacity of the destination. It makes the concatenation of text 64000 fields a hassle.  @ianGPT works thought its odd since it would also work even if you push the number in the characters 70000