Checked Value List Items listed horizontally, separated by ","

[innodat]

I'm sure this is an easy one... just can't figure it out:

I have a Contact Type field with check-boxes, fed by a value list. It's check-boxes because a contact can be assigned more than one type.

This poses a problem in list view. I have the Contact Type field as a plain text field, which lists the checked values vertically (cutting off everything but the first one). How can I get it to display the values horizontally, separated by ","?

Thank you so much for your input!

Edited June 27, 2007 by Guest

[ShannonM]

Hi there - not sure if this is the BEST way, but this is how I did it.

Create a new calculation field (that will hold the list of checked values).

The calculation will be:

Substitute(Contact Type; "¶"; ", ")

[innodat]

Oh, great! Sometimes I just don't think "outside of the box" enough. Great use of the substitute function. Thank you.