Brian Dunning's FileMaker Custom Functions

GetFoundList ( field ; start ; result )

Returns the current set as a return delimited list. Uses tail recursion.

  Average rating: 3.9 (12 votes) Log in to vote

Joshua Willing   Joshua Willing
Willing Apps

Share on Facebook Share on Twitter

  Sample input:
GetFoundList ( table::id ; 1 ; "" )
  Sample output:
1
2
4
6
8
9
7

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

This function simply returns a return delimited list of the selected field values for the current found set. It is great for gathering a list of ids.

This function should handle found sets under 50,000 records as per Filemaker's recursion limit.

Feedback welcome, especially potential improvements.

 

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.