Hi all

Just taken the plunge and got Filemaker 8.5.

For the past hour or so I've been trying to find out how to create a Boolean
field (such a type of file type does not seem to be available) and create a
single check box, where a tick means a value of true and no tick means
false.

Unfortunately, this what I thought would be, simple to achieve task seems
impossible. Where I'm I going wrong?

--
Jeff Wright
Please don't reply direct to jeff (AT) jeffwright (DOT) demon.co.uk
Due to Spam, Spam Spam and more Spam I do not read or answer using this
address

In article <ek573e$74s$1$8300dec7 (AT) news (DOT) demon.co.uk>, "Jeff Wright"
<jeff (AT) jeffwright (DOT) demon.co.uk> wrote:

FileMaker doesn't have "Boolean" fields as such, but it is fairly easy
to recreate them.

First you need to define a Value List. Since you only need one value
you can use whatever you want the text next to the checkbox to say:
"On", "Yes", etc.

You can then create a Text field and put it on the Layout (you could
use a Number field and a value list of "1"). Click on it and choose
Field Format from the Format menu. Here you can set the field to be a
Checkbox using the Value List you defined above. Click OK to close the
window and you're all done. You may need to make the field wider to see
the text and you may need to play with the line and fill colours of the
field to actually see the checkbox (a checkbox using a white line
colour on top of a white background is basically invisible).

You can of course shrink the width of the field to hid the text label
and then use a separate Text box to type in any label you like. This
way you can use the same Value List for as many "Boolean" fields as you
may need instead of definiing mulitple Value Lists.

The field will now display something like:

[] Yes

When the checkbox is "off" the Text field will be empty and when the
checkbox is "on" the Text field will contain the value of "Yes". This
means that in scripts and Calculation fields you can test whether the
checkbox is on or off by:

off: IsEmpty(CheckboxField)

on: CheckBoxField = "Yes"









Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)