Check box auto-checked if ...

[stokesy]

How can I make a checkbox that is auto-checked based on another field having been filled out (and conversely, not checked if that other field is empty)? Any help would be appreciated.

[Lee Smith]

Are you going to want to enter anything in the checkbox manually?

[stokesy]

NO. I just want this box in one layout to automatically be checked when another layout is filled out. I've chosen a field from the second layout to be the indicater.

(This is a job tracking dbase: one layout is the job detail form and the other layout is the estimating form. Not all jobs require estimates and I want to be able to tell from the detail view whether or not an estimate was filled out.)

[Lee Smith]

Using the field name "Estimate" for your other field,

use this case in the checkbox field.

Case ( not IsEmpty( Estimate) ; 1; "")

which can be shorten to

Case ( not IsEmpty( Estimate) ; 1)

Will leave your field blank if estimate is blank, and checked if there is data.

If you want to reverse this, remove the 'not" after case.

Lee

[stokesy]

Thanks, but where exactly do I put the code? Sorry to be so dense.

[Lee Smith]

change the existing field that you current have formated as a Checkbox from [color:blue] text field, to a[color:blue] Calculation , with a[color:blue] number result.

Here is a quick sample of what I mean, notice that I have included the two different calcs for comparison.

Lee

CkBoxFlag.fp7.zip

Edited February 3, 2006 by Guest

[stokesy]

I sure appreciate your help but it doesn't seem to be working for me. I changed the field type to Calculation, and put in the following in Options:

Case ( not IsEmpty( Date estimate) ; 1; "")

using the list to place the Date estimate text so there's no mistake in typing.

I copied and pasted from your example.

[Lee Smith]

Can you post mock up or a striped down copy of your files with the direction to the two fields involved?

[stokesy]

OK I've made a mini-version. The Job Detail layout has the checkbox for Estimate Attached. The Estimate layout has the field for Date estimate.

How do I add an attachment?

[stokesy]

I found it.

_Clone.fp7.zip

[Lee Smith]

You didn't say you wanted the words "Estimate Attached" to print also.

You need to change the calculation (you don't need a checkbox here if you don't want it)

Case ( not IsEmpty( Date estimate) ; "Estimate Attached"; "")

Lee

[stokesy]

Great! Works like a charm. Thank you so much for your help. I DO like the checkbox effect here, rather than either the words appearing or not appearing.

Thanks again.