July 8, 200916 yr Newbies 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.
July 8, 200916 yr 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.
July 9, 200916 yr Author Newbies Thank you. I'm pretty new to file maker what do you mean about the valuelist?
July 9, 200916 yr 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.
Create an account or sign in to comment