The selected values in a check box formatted field are stored as a list of values separated by carriage returns. If we just replace the returns with commas, we'll have your list:
Thus a calculation field such as:
Substitute ( CheckBoxField ; ¶ ; ", " )
Should give you your comma separated list.
Fabulous works like a charm Thank you!.
since I am using this in my iphone and limited space how would I take to the next step which is
When say check box 1 named "cost" is checked a more detailed description can be looked up ? I would love to abbreviate my value list descriptions and have more information inserted in the calculation field. I tried using a value list from another field but this gives me the full description next to the check box.
Thanks for direction.
Someone may chime in with a better idea, but I think you'd need either a separate calculation for each value or you'd have to separate your check box group in to separate fields--possibly in a related table so that you can use a portal to display them in a group. Then you could set up a lookedup value setting on the portal records to copy the full description over from yet another related table.
The list function can then pull your individual selections back into a combined list.
List ( PortalTable::DescriptionField ) would compute the same list format as our original check box field and this expression:
Substitute ( List ( PortalTable::DescriptionField ) ; ¶ ; ", " )
Will subsitute commas for returns.