Jump 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.

subtotals in a portal

ruthcarlton
in Portals

Featured Replies

I have an sales/inventory system which calculates totals, but now I need to provide a way to view subtotals by tour name in a portal.

The "sales" file creates a record (thru an import) for every item everytime there is an event - they appear in a portal in another file as a spreadsheet to record sales. Each record has a serial # for the item, a date and a tour name. Totals are calculated thru a self-join relationship based on serial#.

I figured a great way to get subtotals by tourname would be with a global and a calulation field in which the serial number appears if the TourName = gTourName, and then have a relationship based on this new field, but Filemaker won't let me have a relationship based on a calculation with a global.

I've thought about using a loop and to set the field, but this file is going to get big quickly and it's going to be very slow.

Any other suggestions?

Create an account or sign in to comment

https://fmforums.com/topic/13387-subtotals-in-a-portal/
Go to topic listing

Important Information

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

I accept

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.