Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
CONCAT Not Pulling Data From Column Field
I can't figure this out and even NetSuite support couldn't figure it out on the spot when I called them. Maybe another brain can help:
This is a custom transaction column field of type Text Area. Formula:
CONCAT('Printing Process: ',{custcol_printing_process}) || chr(10) || CONCAT('Ink Coverage: ',{custcol_ink_coverage}) || chr(10) || CONCAT('Color: ',{custcol_color}) || chr(10) || CONCAT('Coating: ',{custcol_coating})
Currently it displays like this.
Printing Process:
Ink Coverage:
Color:
Coating:
It should display something like this.
Printing Process: Gravure
Ink Coverage: 50.0%
Color: Red
Coating: Varnish
When I enter an item, I can see the values for these 4 fields, but CONCAT isn't grabbing the information it seems.