Levi Pruss
08/04/2025, 2:00 PMCeligo AI
08/04/2025, 2:00 PMAI generated answer (using internal Slack threads):To list multiple roles assigned to employees via a search formula, you can use the NS_CONCAT function in a saved search. NS_CONCAT is a NetSuite function that concatenates multiple values into a single string. Here's a general example of how you can use NS_CONCAT to concatenate roles: 1. Create a new Employee Saved Search. 2. In the Criteria tab, add any necessary filters. 3. In the Results tab, add a new field with the following settings: - Summary Type: Group - Field: Role 4. Add another new field with the following settings: - Summary Type: Maximum - Formula: Text - Formula:
NS_CONCAT({role})
5. Save and run the search.
This will give you a list of employees along with a concatenated list of their roles.
Please note that the actual field names and values may vary based on your NetSuite setup, so you may need to adjust the formula accordingly.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
08/04/2025, 2:00 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.819901645
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.818977
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.811622679
Celigo AI
08/04/2025, 2:00 PM