Calc field from checkbox list

[jss44]

I've come across some responses to this, but nothing that has really helped yet, so I apologize if you've seen this before.

I have a field that has a value list (a, b, c, d, e), and want to perform an auto calculation in a 2nd field that displays text based on the results of the first field. For example, if someone checks a, c, and d, the results in field 2 would be:

You checked a

You checked c

You checked d

I can't seem to figure out how to do this. Simple if/thens or case functions will only return one of the results.

I'd prefer not to write a script, but am fine doing so, if necessary.

Any ideas or references would be greatly appreciated! Thanks!

[mr_vodka]

Try using a PatternCount

PatternCount ( ¶ & YourField & ¶, ¶ & "a" & ¶ )

My other suggestion (and preference) is to create 5 number fields and use them as checkboxes with a flag value list of 1.

Then the calc becomes less clunky.

Case ( a and c, "A and C", b and x, "B ad C" ) etc.

[comment]

How about:

Case (

not IsEmpty ( field ) ,

"You checked " & Substitute ( field , "¶" , "¶You checked " )

)

[mr_vodka]

Oh I didnt see that this was just a display of what was checked. I thought that there was further logic that needed to be processed with Case.