Substitute ( CheckboxField ; ¶ ; ", " )
Thank you very much Phil! If I could bother you for one additional piece of info... how do I write your "Substitute" function to check each of the five separate check box fields? FYI, each box if checked gives a result of 1. e.g. Substitute (CHS; 1 ; "CHS") takes care of one check box but I'm lost on adding the other four fields to this one formula.
I'm still knew to writing formulas correctly in FileMaker. Again thanks!
Well I assumed that you had a single field with multiple check boxes. With individual fields with single value check boxes:
Substitute ( List ( Field1 ; Field2 ; Field3 ; Field4 ; Field5 ) ; ¶ ; ", " )
Thanks Phil! That did the trick!