Brian Dunning's FileMaker Custom Functions

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

Kenneth Durrum   Kenneth Durrum - Show more from this author
Released Solutions

Share on Facebook Share on Twitter

  Sample input:
GetNthRecordFiltered (locationName, FoodServed,1,100,"Pizza")
  Sample output:
Pizza Hut
Johnny's Pizza
Pizza World
Sal's Pizza

  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.



Steve Woods   Steve Woods, Antiquity Software
Nov 19, 2018
I think there is a bug where related values that are a single character get merged with next related value.

In line 25, should be Length(thisVal) > 0 instead of Length(thisVal) > 1 i.e.

If(Length(thisVal) > 0; "¶" ; "") & GetNthRecordFiltered(primary_fieldname;controlvalue_fieldname;nextStart;end;thevalue);

Log in to post comments.


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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: