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.

Calculate Number of Portal Rows After Filtering

Featured Replies

First, I'm using FileMaker Pro 11 Advanced on a Mac platform

 

I've created a calculation that returns the number of rows that appear in my portal, but it only shows the number of rows before the portal filter is applied. My calculation is this:

 

Count ( Child::MatchField ) 

 

I've managed to do this on other layouts by creating a match field that encompasses all the criteria for the records that I want to appear in the portal. However, this particular portal iis filtered by variable information that basically allows me to narrow my results to more specific data. For example: In the Parent table, I have one record and in the Child table I have 20 records that match the criteria for the relationship which is:

 

Parent::PrimaryMatch = Child::PrimaryMatch

 

The portal filter returns any or all of the following matches:

 

Parent::Value1 = Child::SecondaryMatch or 

Parent::Value2 = Child::SecondaryMatch or

Parent::Value3 = Child::SecondaryMatch

 

Which returns only 8 records.

 

How do I get the Portal Row Count to only show 8 instead of 20?

 

Create a summary field in the portal table as Count of primaryID. On your layout, create a one-row portal with the same filter as your other portal, and place the related summary field in the portal. This will display the count of portal records.

 

To use this number within a calculation, give the field an object name in Inspector, Position tab and use GetLayoutObjectAttribute ( "objectName" ; "content" ).

  • Author

Trying that now. 

 

Thanks!

  • Author

It worked like a charm. I knew there would be a simple solution!

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.