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 - Show more from this author
pme Familienservice GmbH
https://www.familienservice.de

Sample input:

PortalFilter ("Gregor Beuster Berlin Developer"; "gre ber dev")

Sample output:

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

/**
22.03.2022 Gregor Beuster

- TextToFilter -> (concatenated) field(s) "behind" portal relationship
- FilterField -> field (on same layout) to put in search terms
- not case sensitive
- use function in portal setup dialog "filter"
- use trigger (OnObjectKeystroke -> Char(10) or Char(13) = "enter key") on "FilterField" to commit and refresh window to see results

**/

Let(

[

$wordList = Lower(Substitute ( FilterField; " "; "¶"));
$wordListCount = ValueCount ( $wordList );
$searchText=TextToFilter

];

Case(

$wordListCount >0;

While ( [ 

index = 1;
match = 0

] ; index  ≤ $wordListCount; 

[ 
match = match + Case(Position ( $searchText; GetValue ( $wordList; index); 1; 1)>0;1;0);
index = index+1
] ; 

match=$wordListCount);

"1")

)

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, SPS May 10, 2022
Brilliant function. Works very well, thank you.

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

PortalFilter ( TextToFilter ; FilterField )

Comments

Support this website.

Support this website.