Brian Dunning's FileMaker Custom Functions

PortalFilter ( TextToFilter ; FilterField )

Can be used to filter portal rows based on any number of terms/words put into a filter field.

  Average rating: 5.0 (3 votes) Log in to vote

Gregor Beuster   Gregor Beuster - Show more from this author
pme Familienservice GmbH
https://www.familienservice.de

Share on Facebook Share on Twitter

  Sample input:
PortalFilter ("Gregor Beuster Berlin Developer"; "gre ber dev")
  Sample output:
1

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Function can be used to easily build a dynamically filtered portal. It loops (using While() function) through the provided terms in a filter field and returns "true" for every portal rows matching ALL search terms. Highly efficient matching due to use of Position() instead of PatternCount().

 

Comments

spstudios   spstudios
May 10, 2022
Brilliant function. Works very well, thank you.
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 18 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: