birchtree Posted July 1, 2001 Share Posted July 1, 2001 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 More sharing options...
mitchn Posted July 1, 2001 Share Posted July 1, 2001 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 More sharing options...
LiveOak Posted July 1, 2001 Share Posted July 1, 2001 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 More sharing options...
BobWeaver Posted July 3, 2001 Share Posted July 3, 2001 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now