Hi, I have a layout with many calculations on it. Some with
calculations on calculations, so things get a little slow sometimes,
especially when resizing the window. Any suggestions on how to include
a 'calculate now' function that can perform all calculations only when
required? I realise that you can script the calculations, but this
puts all the calculations in the script and not in the calculation
defined with the field. Is there a way to just 'suspend' all field
calculations until required? Thanks. I use Filemaker 8.5. Mark.

In article <1185679912.289694.168710 [at] j4g2000prf.googlegroups.com>,
mgfilemaker <mgoyeah [at] hotmail.com> wrote:

> Hi, I have a layout with many calculations on it. Some with
> calculations on calculations, so things get a little slow sometimes,
> especially when resizing the window. Any suggestions on how to include
> a 'calculate now' function that can perform all calculations only when
> required? I realise that you can script the calculations, but this
> puts all the calculations in the script and not in the calculation
> defined with the field. Is there a way to just 'suspend' all field
> calculations until required? Thanks. I use Filemaker 8.5. Mark.

Take the fields you don't need off the Layout. Put them on another
Layout and go there when needed.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

On Jul 28, 9:31 pm, mgfilemaker <mgoy... [at] hotmail.com> wrote:
> Hi, I have a layout with many calculations on it. Some with
> calculations on calculations, so things get a little slow sometimes,
> especially when resizing the window. Any suggestions on how to include
> a 'calculate now' function that can perform all calculations only when
> required? I realise that you can script the calculations, but this
> puts all the calculations in the script and not in the calculation
> defined with the field. Is there a way to just 'suspend' all field
> calculations until required? Thanks. I use Filemaker 8.5. Mark.

Create a number field named Trigger. Change all the calculated fields
to non-calclulation fields of the appropriate type (text, date,
number, etc). Create a calculation for each field:

Let(
onTrigger = Field::Trigger;
yourCalculationGoesHere)

and put the calculation in the auto-enter calculation box in the
field's definition. Set the auto-enter to always replace.

When the field Trigger changes, the calculation will update. Create a
script that Set Fields the Trigger field and attach that to your
"Calculate Now" button.

G

Thanks guys, the advice has been very helpful.