Use NS_CONCAT to list multiple roles assigned to e...
# ask-stanley-ai
l
Use NS_CONCAT to list multiple roles assigned to employees via search formula
c
AI 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. ******
Slack 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
Please provide your feedback on this answer.