Trying to concat two field values together, using Concat I can do this. But now, trying to add : between the two field values and get an error: CONCAT({name}, : ,{displayname})
Using formula (text). Any suggestions
s
Sandii
08/25/2022, 4:50 PM
put the colon in quotes
m
mg2017
08/25/2022, 5:01 PM
That's actually how I initially had it, with quotes. Invalid expression error.
l
Luis
08/25/2022, 7:14 PM
I think you can CONCAT 2 "data" at a time. Your example seems to be 3 separate strings to me. Try nesting 2 CONCATs.
CONCAT(CONCAT({name}, ':'),{displayname})
👍 1
m
mg2017
08/25/2022, 9:10 PM
Perfect, the double concat worked
t
Tristan Day
08/25/2022, 10:00 PM
You can also use the double-pipe to concat (the vertical line: || )