Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
9.5
10.0
10.1
10.2
10.3
10.4
10.5
11.0
11.1
11.2
Statistic
FMM
Blog
Count matching entries in list.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
List | 10.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameter | Description | Example | Flags |
---|---|---|---|
List | The list to process. | "Hello" ¶ "" ¶ "World" | |
Operator | The compare operator. Can be =, !=, <, >, <=, >=, ≤, ≥ or ≠. |
"≥" | |
Value | The value to check against. | ||
Mode | Available in MBS FileMaker Plugin 10.3 or newer. Pass 1 for numeric comparison. Default is 0 for text comparison. |
0 | Optional |
Returns number or error.
Count values ≥3:
MBS( "List.CountValuesMatching"; "1¶2¶3¶4"; ">="; 3 )
Example result: 2
Count values <4:
MBS( "List.CountValuesMatching"; "1¶2¶3¶4"; "<"; 4 )
Count values below 100 numerically:
MBS("List.CountValuesMatching";"10¶20¶300¶40";"<";100; 1)
Example result: 3
Created 5th April 2020, last changed 23th June 2020
List.CountValues - List.CrossProduct
Feedback: Report problem or ask question.