Netsuite - Saved Search - String All True Results of Case Formula -
Netsuite - Saved Search - String All True Results of Case Formula -
hoping can help me out netsuite question, , apologize in advance if i’m misusing lingo.
i creating item based saved search , 1 of formula (text) result fields can have multiple true values when apply case formula. i’m combine true results of formula 1 comma separated string, instead of new item row each true value.
sku contact type 123 john s owner 123 jane s clerk 123 jack s clerk
formula (text) - custom label field name = contact name
case when {type} = ‘clerk’ {contact} end
currently results generate item (sku) row each case of clerk:
sku contact name 123 jane s 123 jack s
i’m looking results single string
sku contact name 123 jane s, jack s
i know case function noted above not string results itself; intended utilize grouping , max summary types, 1 contact name result.
any solutions or work arounds?
thanks
there grouping functionality available saved search results, don't think trying possible.
if grouping results sku, 1 line per sku concenating contact names different line results don't think possible.
case netsuite
Comments
Post a Comment