isFirstRecordWithValue ( sortedBy )
Used to hilite the first record of a given value in a sorted list of records.
Average rating: 4.9 (31 votes) Log in to vote
isFirstRecordWithValue ( getFieldName ( data::Fruit ) )
Records Number: Fruit | Amount
1: Apples | 4
2: Apples | 2
3: Bananas | 3
4: Bananas | 2
5: Bananas | 3
6: Pears | 2
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
You can use this with custom formatting on a sorted list of records to identify the first record in each grouped set to hilight or otherwise distinguish between the groups of values.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.