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
Released Solutions
http://releasedsolutions.net

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
Sabarro

  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.

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.