July 8, 200917 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, 200917 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, 200917 yr Author Newbies Thank you. I'm pretty new to file maker what do you mean about the valuelist?
July 9, 200917 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