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

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

SelectPeople.fp7.zip

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!

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.