Brian Dunning's FileMaker Custom Functions

ListFunction ( start ; end ; function )

Recursive function calculator

  Average rating: 4.5 (33 votes) Log in to vote

Bruce Robertson   Bruce Robertson

Share on Facebook Share on Twitter

  Sample input:
ListFunction( 1; get(foundCount); "[n] & \" - \" & getNthRecord(Company; [n])" )
  Sample output:
1 - ABC Inc.
2 - DEF Inc.
3 - MoreCo
4 - OtherCompany

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

Inspired by Custom List by Agnes Barouh.
A recursive function calculator that processes FUNCTION for values from START to END. You must supply function in quoted form with [n] as the placeholder. You can build simple lists or complete HTML pivot tables using this technique.

You could for instance build a text invoice with header and then a ListFunction calc for the line items. Check the web site for examples.
MODIFIED: 10/23/07 to eliminate extra returns which occurred in some cases

 

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.