Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Concat Formula - Adding Space between 2 custom fields
Hi,
We use quite a lot of Matrix Options (around 20 different fields) from Size, Units, Color, Length, Size and Units, Size & Unit, Size/Units etc - All Matrix options fields have around 1000 plus options in their individual lists.
so basically I am trying to CONCATENATE all these different options into ONE field in a SAVED SEARCH. I've never needed this until now, where I need to check around 2000 items if they have the correct UOM but don't know how to add a space in between the fields - for example CONCAT({isonline},{isinactive}).
I tried adding , ' ', and ," ", -- CONCAT({isonline},' ',{isinactive}) // CONCAT({isonline}," ",{isinactive})
0