This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I’m having a dumb moment.  Trying to use a WF SetFieldValue action to set the value of a custom text field to a concatenation of two other custom fields on a custom record.  I’ve tried both CONCAT and the || operator.  If my formula is `{custrecord_field1}` I get the value of `custrecord_field1` as expected.  If my formula is `{custrecord_field2}` I get the value of `custrecord_field2` as expected.  However, if my formula is `{custrecord_field1}||{custrecord_field2}` I only get the value of `custrecord_field1`, and if I do `{custrecord_field2}||{custrecord_field1}` I only get the value of `custrecord_field2`.  Am I stupidly missing something obvious here?

`CONCAT({custrecord_field1},{custrecord_field2})` gives nothing at all.

I'm sure I have used those formulas before

Yep, recent example on my end

`CONCAT('ABC' , {custbody_special_approval_text})`

well it’s reassuring that I haven’t forgotten how to NetSuite, at least.  Must be something else going on.