Discussions
Concatanate
Hello-
I have ten custom fields for products that have individual statuses (dropdowns with choices of Launch, Completed, Unsold) to track Launch process. Is there a way to concatenate all of these ten fields that have results = "Launch" to summarize them in a report?
Example:
Customer Launch Completed Unsold
[ABC Company Product1, Product 2 Product3, Product4 Product5
XYZ Company Product1 Product3, Product5 Product2, 4
I can do this in excel, but am more of a novice with sql expressions to make this happen within Netsuite. I have a dashboard request for this information and cannot give this visability with the number of fields we require for our products unless we combine the values.