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.

Calculation of a field within a found set

Featured Replies

I want to be able to take a found set and within that set sum a number located within a field of all the record of that set. Is this possible? Do I need to set up a script to do this?null

Two ways to accomplish this.

You can use Summary fields. They operate on the current set of records, be that the found set while in browse mode, or a sub-summary set while in preview mode.

You can also use the normal calculation aggregate functions on a related set of records.

If you found set is based on a really complicated find, then the summary field will probably serve you best, although you may need to use some GetSummary() functions to get exactly the summarizations that you want.

If you find is simple, such as counting and totalling the invoices for a client, then the aggregate functions through a relationship is a better way to go.

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.