We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content

Recommended Posts

McScripta    0

I'm using {{FoundCount}} to get count of filtered records in a portal. This works well when just displaying the count on the layout but I'd like to use that figure as output to a field (regardless if this needs to be a calculation field or just number). How do I have a field track count from a portal?

Share this post


Link to post
Share on other sites
comment    1,356

Is your portal filtered on its own? If yes, can the filtering be reproduced by using a relationship only?

In general, portal filtering works on layout-level only, and it's difficult (though not impossible) to get the result at the data level (where calculation fields operate). If you really need it at data level, you probably don't want to accomplish it using layout-level measures, because that will only work on that specific layout, and depend on that layout remaining unchanged.

  • Like 1

Share this post


Link to post
Share on other sites
siroos12    9

I am agreed with comment, use a relationship and then on the parent table, make a calculation field with "Count(field)" function which counts the field from the child table (the one used for relationship, this can be your filtering criteria). If you need more than one filtering criteria, then add more TO of the child table and use a new field for the relationship.

  • Like 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×