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

Popular posts from this blog

php - Android app custom user registration and login with cookie using facebook sdk -

django - Access session in user model .save() -

php - .htaccess Multiple Rewrite Rules / Prioritizing -