You need a filtered portal, not a quickfind.
Sarah Severson wrote a good blog post demo'ing the type ahead portal filter technique. It may or may not work inside of a popover though, as portals in popovers sometimes can behave strangely.
Thanks Mike, that's very helpful.
Sara uses the following to filter portal records
PatternCount ( SES_FND__Fund::Nickname ; SES__Session::Filter_Deals_g ) > 0
My understanding is that PaternCount returns a number:- How does this filter portal records?
It returns a number for sure.
Did you miss the “> 0” on the end of the calculation that makes it a true/false indicator?
I didn't miss the ">0" , but I did miss its meaning... which I guess is the same as saying, 'yeah, I missed it'
Forgive me, I guess I'm missing (another) fundamental point here, but I still don't understand how a function, or group of functions that return a Boolean result filters the contents of a portal. I could copy and paste, but I hate to use stuff when I don't understand how it works!
You might check out the following instructional file:
It has several working examples of such portals. One uses Patterncount as described here. Another sets up a "starts with" text match that provides a slightly different take on how one might filter down a portal.
Each working example comes with detailed documentation on how they were set up.
Patterncount() counts the number of occurrences of something in a string.
Patterncount( “this is a test. We are testing” ; “test” ) > 0
2 > 0
So in the end, that sample is a Boolean for true or false depending on if the RESULT of the patterncount() function is greater than zero.
1 of 1 people found this helpful
Thank you for the link Phil.
The veil of mist has been lifted from my eyes - now I understand exactly how the portal filter works! To quote from your document...
" With filtered portals, Filemaker loops through every related record (every record that would appear in the portal if it were not filtered) and evaluates the portal filter expression once for each record in the portals table. If the result is True for a given related record, that record is allowed to appear in the portal. If the result is false, the related record is omitted from the portal...."