How to use ns_concat function saved search formula

The ns_concat() function loops through each instance of a summarized field, and returns an array of values that are comma-delimited. The result is then casted into a string.

  • Navigate to Lists > Search > Saved Searches > New
  • Click Results
  • Select Formula(Text)
  • Select summary type

Formula

  • ns_concat({company})

For Example:

  • NS_CONCAT(CASE WHEN {type} = ‘Invoice’ THEN {number} ELSE NULL END)

Leave a comment

Your email address will not be published. Required fields are marked *