When building Saved Searches in NetSuite, you may encounter a need to concatenate multiple values into a single field, such as listing item names for a transaction or aggregating emails tied to a contact. That’s where the NSCONCAT function becomes especially useful.
What is NSCONCAT?
NSCONCAT is a group function available in formula fields when using a Summary Type = Group. It concatenates multiple values from a grouped field into a single string.
When to Use It
You might use NSCONCAT when:
- You want to display all item names on an invoice line in a grouped result.
- You’re tracking email addresses associated with a customer or vendor.
- You need a summary view where many-to-one relationships should be collapsed into one readable field.
How to Use It
- Choose Summary Type: In your Saved Search, ensure you’re using
Summary Type = Groupon the field you’re aggregating under. - Add a Formula Field:
- Set Field Type: Text
- Set Summary Type: Maximum or Group
- Formula: NSCONCAT({item}): This returns all item names associated with the grouped record.
Example: List All Items on Sales Orders
You want a list of all items on each Sales Order:
- Search Type: Transaction
- Criteria: Type = Sales Order
- Results:
- Group by Document Number
- Add a formula field: NSCONCAT({item})
- Output: A column showing item names like: Widget A, Widget B, Widget C
Notes & Tips
- NSCONCAT only works with summary/grouped Saved Searches.
- You can’t control separators (e.g. comma, line break) via native syntax—output uses comma by default.
- It works with IDs, text fields, even formulas as long as they resolve to a string-compatible value.