Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

calculated auto entry fields


This topic is 8526 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 8526 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.