How to summarize value list?
I would like to advice on this solution. I am creating a form for sales calls with a field with 10 multiple values with check boxes.
Doesn't need, Too expensive, Follow Up, etc ... What I would like to happen is as every box is checked the result goes into a text field that can then be exported to excel.
I know I can create single fields and string them together although I haven't been able to figure out how not to show the comma when a result isnt selected. example; Loved & "," & dislikes & "," & follow up.
Preferably would like to have one field with multiple check boxes and a summary of the results in a text field.
I couldn't find any post for this but somehow I feel it must be done all the time.
Thanks for guidance.