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.

Portal Total

IEW
in Portals

Featured Replies

I have a page that contains 3 portals.

 

"Process"  Filtered by "StatusIP="Process"

"Hold" Filtered by "StatusIP="Hold"

"Finalized" Filtered by "StatusIP="Finalized"

 

Each record has a field "TotalQuote"

 

I want to get a total of "TotalQuote" for all records in each portal.

 

Can't seem to get to work, tried using "Summary field".  Any help would be appreciated.

If you have a summary field from the child ( portal ) table then you can create a single-row portal with exact same filter as 'Finalized', resize the portal to just 1 pt larger on all sizes than summary field and place it below 'finalized'.  Repeat with each portal.

 

Summary fields will respond to portal filtering IF they are also filtered the same.  Match summary field table occurrence to same as each portal's table occurrence name.  In FileMaker, context is king.  :yep:

Edited by LaRetta

  • Author

Thank you LaRetta that did the trick. 

Create an account or sign in to comment

https://fmforums.com/topic/88025-portal-total/
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.