ListFunction ( start ; end ; function )

Recursive function calculator

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

Bruce Robertson - Show more from this author

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)

/* 
ListFunction ( start ; end ; function)
evaluate FUNCTION using values from start to end
supply your function in quoted form with [n] as the placeholder
example
ListFunction( 1; 12; "[n]" )
returns numbers 1 thru 12 in list format
*/

Let([
StartNum = GetAsNumber( RightValues(start; 1));
keep = LeftValues( start; ValueCount( Start) -1);
nextNum = StartNum + 1;
myResult = "Let( [StartNum = " & StartNum & "];" & Substitute ( Function ; "[n]" ; "StartNum" ) & ")" ;
myResult = Evaluate( myResult );
myResult = Case( myResult = "?"; ""; myResult);
output =  keep &  myResult ;
output = Case( Right(output; 1) = "¶"; Left( output; Length( output) -1); output);
End = GetAsNumber( end)];

Case (StartNum < End ; 
  ListFunction(  List(output; NextNum) ; End; function ); 
  output
)
)

/* More examples
ListFunction( 1; get(foundCount); "[n] & \" - \" & getNthRecord(Company; [n])"  )
Returns record number and company names from found set
*/

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

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

ListFunction ( start ; end ; function )

Comments

Support this website.

Support this website.