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

produce summary calculation 'on demand'


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

Recommended Posts

Posted

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

Posted

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.

You have the correct version to pull this one off, make a invisible tabbed layout only showing this annoying field on the not default tab. To get it thru on demand, make a script line going to the appropriate tab.

--sd

Posted

Clean and easy solution, it works perfectly

Thank you!

This topic is 6495 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.