Checkbox calculation

[roc1125]

I created a checkbox (called region1)with a bunch of fields "1", "2", "3", and "all". Does anyone know how to create a calculation for the field so that when I click on all,1, 2, and 3 will all be selected.

[comment]

Try auto-entering (with replacing existing value) =

Case ( 

IsEmpty ( FilterValues ( "all" ; region1 ) ) ; region1 ;

"1¶2¶3"

)

This can be smartened up by using ValueListItems() instead of hard-coding the values in the formula.

[roc1125]

Thank you. I'm pretty new to file maker what do you mean about the valuelist?

[comment]

I mean that you could use the ValueListItems() function to return a list of all the items to be checked. This way you can modify the value list without needing to adjust the calculation.