Concatenate two fields for Insert into Table Column

Queries and Resources
1

I'm trying to insert a record where I'm concatenating the first and last name fields, but I'm only getting the Last name into my column. I've also tried || instead of the + sign. I've also tried double-quotes.

image

I've also tried: CONCAT({{ textLastName.value }}, ", ", {{ textFirstName.value}}) which put this in the name column: CONCAT(Doe, ", ", John)

2

Try doing this in the Changeset value for NAME
{{textLastName.value + ' ' + textFirstName.value}}

3

Thanks, that did it! I did change it to be ', ' for my needs and that still worked. Someday hopefully I'll figure out some of these nuances of this language!

1 Like