In FMP 8.5

I have a table 'a' containing a 'total' field summaryzing several
related records.

Sometimes I need the sum of the 'total' fields from a long quantity of
records from the 'a' table. I save this into a 's.total' calculation
field using the GetSummary function.

When in browse mode I go into the layout containing 's.total' it takes
a long time to get the calculation.

I just need to have the calculation sometimes, so in order to
accelerate it I would like to script a button that shows or hides the
field containing 's.total' into one layout.

I know I could use two identical layouts (except 's.total') and switch
from one to another, but I would prefer something simpler.

I tried hiding 's.total' with a container field to mask the summary
field but the calculation is performed anyway.

Any idea?

Thank you.

You could put a portal around it to hide and show it when desired...but
I have another suggestion that may or may not work for your situation:

Put a global number field on your layout instead of a summary field.
Put a button next to the field so that when you click the button, a Set
Field step updates the global with the correct sum() calc.

Or don't even bother with a global field. Just make the button show a
custom message, where the message is the correct sum() calc.



naiobox (AT) gmail (DOT) com wrote:
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance

Thank you Howard.

I do not understand your portal suggestion, can you explain better?
you mean to mask the summary field with the portal? or to insert the
summary field in a portal? how can I control the portal visualization?

Concerning the calculation into a field solution: I do not like it
because I would need to erase the field content in cases I cannot
control.

Concerning the custom message: it is a good solution, but maybe I
could find something more elegant...



Howard Schlossberg ha escrit: