GetNthRecordFiltered ( primary_fieldname ; controlvalue_fieldname, recordNumStart ; recordNumEnd ; filterValue )
This function enables you to select a set of related records of a single field based on a value of a second field that is filtered by a keyword.
Average rating: 4.1 (39 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Use this function to obtain a list of values based from a field based on the filtering of another field. In the example listed in the sample input we have a field called locationName which holds a list of eatery locations. In the FoodServed field in the same table as the locationName field we have store the values of the food items served at the location.
The function loops through the return values of the related field and only returns the locationNames of the records that contain the filterValue in the FoodServed field.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.