Concatenate multiple fields

I would like to create a workflow to concatenate 3 diferent fields, the first and second ones are list/record’s type, and the third and last one is a text field. The problem is that the first and second fiels are not recognized at the formula and must be converted, and the formula doesn’t work. Does anybody could help me with the correct formula to convert the first and second fields and concatenate all fields? Note: I’m using the simple formula: concat(field1,field2,field3) and it’s not working.

Rookie Asked on October 22, 2021 in SuiteFlow.
Add Comment
3 Answer(s)

Hi, CONCAT only takes two  values. You could try either nesting the CONCAT functions

CONCAT({field1}, CONCAT({field2}, {field3}))

or more simply using the concatenation operator “||”
{field1}||{field2}||{field3}

Beginner Answered on October 27, 2021.
Add Comment

Thanks!

Rookie Answered on October 27, 2021.
Add Comment

Hello Guys,

You can use this format to combine ‘Text’ and {data base fields} .

 

CONCAT(‘Field text1 ‘, CONCAT({Field1}, CONCAT(‘Field Text2’: ‘,{Field2})))

Rookie Answered on November 12, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor