| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
QuickList.IndexOfFirstValueMatching
Finds index of first value matching value.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| List | 10.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "QuickList.IndexOfFirstValueMatching"; ListRef; Operator; Value { ; Mode; StartRow } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| ListRef | The reference to the list returned from QuickList.New function. | $List | |
| Operator | The compare operator. Can be =, !=, <, >, <=, >=, ≤, ≥, ≠, Prefix or Postfix. |
"≥" | |
| Value | The value to compare. | "Test" | |
| Mode | Available in MBS FileMaker Plugin 10.3 or newer. Pass 1 for numeric comparison. Default is 0 for text comparison. |
0 | Optional |
| StartRow | Available in MBS FileMaker Plugin 14.0 or newer. The row to start at. Default is 0. |
0 | Optional |
Result
Returns number or error.
Description
Finds index of first value matching value.This uses text comparison!
Examples
Find index of first value ≥4:
Let([
list = MBS( "QuickList.New"; "1¶2¶3¶4");
count = MBS( "QuickList.IndexOfFirstValueMatching"; list; "≥"; 4 );
r = MBS("QuickList.Release"; list)];
count)
See also
Release notes
- Version 10.4
- Added prefix/postfix operator for List.IndexOfFirstValueMatching, QuickList.IndexOfFirstValueMatching, List.CountValuesMatching and QuickList.CountValuesMatching.
- Version 10.3
- Added numeric mode for List.CountValuesMatching, List.IndexOfFirstValueMatching, QuickList.CountValuesMatching and QuickList.IndexOfFirstValueMatching functions.
- Version 10.2
Blog Entries
- Data structures in MBS Plugin
- MBS FileMaker Plugin, version 10.4pr7
- MBS FileMaker Plugin, version 10.3pr6
- News about the MBS FileMaker Plugin 10.2
- MBS FileMaker Plugin, version 10.2pr2
This function checks for a license.
Created 5th April 2020, last changed 14th December 2023
