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.

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

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.)

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

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

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, 200620 yr by Guest

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.

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

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?

I found it.

_Clone.fp7.zip

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

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.