On a saved search, I've got the following formula ...
# suitescript
m
On a saved search, I've got the following formula but end result is trailing commas when the referenced fields are null - is the join function breaking the case statement? This works properly when those fields (all or some) are populated CASE WHEN {custentity_alt_email_2} = null THEN null ELSE {custentity_alt_email_2} END || CASE WHEN {custentityalt_email_3} = null THEN null ELSE ','||{custentityalt_email_3} END || CASE WHEN {custentity_alternate_email_4} = null THEN null ELSE ','||{custentity_alternate_email_4} END || CASE WHEN {custentity_alternate_email_5} = null THEN null ELSE ','||{custentity_alternate_email_5} END