I'm trying to concat two fields in a workflow usin...
# suitescript
n
I'm trying to concat two fields in a workflow using Set Field Value. The formulas I have tried •
{user.firstname}||" "||{user.lastname}
{user.firstname}+" "+{user.lastname}
I get an ERROR: Invalid Expression
How do you concat these values?
d
use apostrophes instead of quotation marks. so:
{user.firstname}||' '||{user.lastname}
not *note that concatenation in formulas like this uses double pipe
||
not plus sign
j
note*
n
Thanks
d
thank you, that could have been confusing =]
s
another reason to avoid workflows