calculated auto entry fields

[birchtree]

Hello

I can't figure out how to delay the calculation in one field until two other referenced fields are filled in. The check off delaying calculation if any referenced fields are empty doesn't seem to work. It doesn't make any difference check it off or not.

Also does Filemaker allow for more then one level of undo or can it be prevented from saving every modification?

[mitchn]

Your best bet is to set the calculation as part of a script. In the script you can set up a step that would holt or exit the script if one or as may fields you specify are empty.

If("is empty, Filed1")

Exit Script

Else

Set Field(Calc Field,Calculation)

End If

good luck

[LiveOak]

Another option is to use two fields for the field to be delayed, an entry field (number or text) and a calculated field. Stack the calculation field on top of the entry field, format the calculation field to not allow entry, and fill the calculation field with a solid color so the entry field does not show through. As an example:

Field A (number)

Field B (number)

Field C (number)

DisplayField C (calculation, number) =

If (notIsEmpty(FieldA) and notIsEmpty(FieldB) and notIsEmpty(FieldC), FieldA + FieldB + FieldC, "")

The result in Field C will give the appearance of not showing up until FieldA and FieldB and FieldC are filled in.

If you tab between field, make sure to put FieldC in the tab order and leave DisplayFieldC out.

-bd

[BobWeaver]

Here's what works for me. Suppose you want your autoenter function to concatenate the parts of a person's name to make their full name. The autoenter function would be:

Case(

IsEmpty(FirstName),"",

IsEmpty(MiddleInitial),"",

IsEmpty(LastName),"",

FirstName & " " & MiddleInitial & ". " & LastName

)

Remember though, you can't allow any of these fields to be optional; they must all contain a value or the function won't evaluate.