Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Invoice total calculation field - how to make it stored?

Featured Replies

My Filemaker solution has, at its core, a fairly straightforward invoicing structure. There is an Order table, and an Order_Item table for the line items.

The Order table has an Order_Total calculation. At the moment this has a very simple definition: Sum(Order_Item::Cost)

The calculation cannot be stored as it references a related field. This arrangement seems to be affecting the speed of the database as there are lots of other calculation and summary fields which all use Order_Total and therefore, in turn, have to be unstored.

We now have ~22,000 records in the Order table and ~85,000 in Order_Item so I imagine there's a lot of recalculating going on in the background.

Is there a sensible / recommended way to make this calculation storable? I know I could use a script to insert the total, but that would mean a lot of script triggers etc. needing scattered throughout the solution. The total needs to update fairly quickly whilst staff are adding items and building an order, but after that it tends to stay unchanged apart from the occasional amendment.

I've been using auto-enter calculations for some other fields, would that be an option here?

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.