Post your filter calc?
-- sent from my iPhone4 --
I'd like to be able to dynamically filter a portal
multiple global fields on a relationship level without including scripting or bogging down the system?
What's it to be? These are two different aproaches.
Anyway, see if the attached sample helps you.
PortalFilter_eos.fmp12.zip 19.4 K
Erolst, you are a genius; I do believe you've cracked it, though I've not yet had an opportunity to study how. I'm on my way into the office to pop the hood on it and check it out, but I wanted to drop you a line in advance to thank you for your kind consideration. I'll circle back to the thread after I've given it a shot!
J, make sure you look at:
1. the relationship that creates the portal (including sorts if any)
2. click on the portal (in layout mode) to get the dialog and check:
a. sort order if any
The Filter calc is what allows you to select different things and make the portal different based on the selections. I tend to also have an "all" button and the calc doesn't "filter" - thus showing you all from the original relationship.
You might wish to ponder the summary field values that can be seen with Filtered Portals:
<http://filemakerhacks.com/2012/09/13/aggregates-in-filtered-portals/> In the article and demo, I show:
changing the filter via the method (although simplied) by selection
duplicating the portal, making it one row only and showing summary fields there.
I'm trying to follow how the portal filter calculation relates to the "active", "inactive", "retired" checkboxes. I'd like to add just that aspect of your sample project to one I am working on. I'm pretty new to filtering calculations so am having a difficult time deciphering how you did that specifically. It looks to relate to maybe a Custom Function and is specifically on the "STATUS" aspect of the calculation. Any additional guidance/direction would be greatly appreciated!