formula to show multiple user notes in one row in ...
# ask-stanley-ai
n
formula to show multiple user notes in one row in a saved search
c
AI generated answer (using internal Slack threads):
To show multiple user notes in one row in a saved search, you can use a formula text field in your saved search. However, it's important to note that NetSuite does not support aggregation of multiple notes into one row directly. Here's a workaround you can use: 1. Create a new Formula (Text) field in your saved search. 2. Use the following formula:
NS_CONCAT({note})
. This formula will concatenate all the notes into one row. Please note that this formula uses the
NS_CONCAT
function, which is a NetSuite specific function used to concatenate rows of data into a single text string. The
{note}
is the field id for the note field. ****** 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.82919544
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.82801187
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.827260137
Please provide your feedback on this answer.