Help wanted: toggling yes/no field

[alterbentzion]

I'm trying to design some simplified forms which can fit into small windows. One of the things I'd like to do is create toggling checkboxes or radio buttons for yes/no fields, so that I don't have to make room on layouts for both "yes" and "no" checkboxes/buttons. (Those of you familiar with MS Access know what I mean.) I'm fairly new at scripting, and I just can't figure this thing out.

The value of the yes/no fields are to be used as markers when filtering a mailing list or generating sums, so I've assigned them a numeric value of 0 or 1.

So how do I set up such a checkbox?

I'm attaching a small sample file. If you have the time, please tinker with it and post the results. Thank you very much.

SelectPeople.fp7.zip

[comment]

See if the attached helps (never seen Access, so..)

SelectPeople.fp7.zip

[alterbentzion]

Very cool.

~ I see that you added another value list with just "1" in it, and unchecked "Require member of value list." Why?

~ Should I assume that if the "include" field has a null value, it will be treated like a zero in calculations?

~ How did you get "1" to display as "yes" and "0" as "no?"

Thanks!

[comment]

Validation is not required when the user has no way to enter an invalid value.

There is also a very simple way of having a single checkbox with a value list of 1. I have implemented this in your file first, then took it out, so that's why the VL is still there. In such case you don't need to define a button - but the toggle is between 1 and null, as you point out. This shouldn't matter in a calc, but it can make a difference if you ever need to count the field.

See Format->Number in Layout mode.