Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
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.