Calc field displaying values of check boxes

[zenboy32]

I have a field called “Diagnosis” The field is check boxes so users can choose all that apply for a given consumer, e.g. “Cerebral Palsy” “Retardation” “Traumatic Brain Injury” etc…

I would like to create a calculation field that will list all checked box values for a record separated by commas to save space on a data sheet layout. “Cerebral Palsy, Retardation, Traumatic Brain Injury” Thank you.

[Vaughan]

As checkboxes are selected, FMP inserts the values into the field in the order of selection with paragraph characters as delimiters.

To get what you want, create a calculation field that uses the Substitute() function to change the paragraph characters into commas.

[zenboy32]

That's great! Thank you for your help!

[zenboy32]

As values are selected by different users, how can I sort the diagnosis values to be displayed in alphabetical order?

[Vaughan]

The value list will sort the items alphabetically. If you want some sort of "each user only sees their own entries" system, then forget it, that's another ball game. MUCH more complicated. I've never done it.

[DykstrL]

Actually Vaughan, I don't thin you are correct about the sorting. Text fields enter the check box values in the order they are checked. They do not sort. If an item is unchecked, the rest of the list slides up - but the list still stays as entered.

Value lists based on values from a field will sort themselves, but the checked values still are entered in the order checked.

[DykstrL]

Actually Vaughan, I don't think you are correct about the sorting. Text fields enter the check box values in the order they are checked. They do not sort. If an item is unchecked, the rest of the list slides up - but the list still stays in the order entered.

Value lists based on values from a field will sort themselves, but the checked values still are entered in the order checked.

[Vaughan]

My original post suggested the use of value lists to display the results. These will be sorted. The checkbox entry field will be in order of selection. The original question was getting the values to display comma delimited.

The only way to make this field display sorted is to run a script that re-arranges the entered values. Complicated and not too elegant, unless you can build an interface that gets the user to run the script every time the field is modified.