ArrayField_FoundSet ( field )

Returns an array of each value for a specific field in the current found set

Be the first to rate this function Log in to vote

David A Sullivan - Show more from this author
Mandelbrot LLC
http://mandelbrotllc.com

Sample input:

ArrayField_FoundSet( PrimaryKey )

Sample output:

[
"90F8D696-663C-7E47-967F-E50B13375FA4",
"E1336444-B2C4-434C-AE17-7C02E5AF9A43",
"9A0125AD-BB4C-F749-9F00-904ABE3D45F6",
"B7A8826F-6D83-3A41-9AA9-D0AC6B1A70C0",
"9DDF9915-B5AD-9745-9A49-EE6BA310DCAE"
]

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

/*
  __  __                 _      _ _               _     _     _     ____ 
 |  \/  | __ _ _ __   __| | ___| | |__  _ __ ___ | |_  | |   | |   / ___|
 | |\/| |/ _` | '_ \ / _` |/ _ \ | '_ \| '__/ _ \| __| | |   | |  | |    
 | |  | | (_| | | | | (_| |  __/ | |_) | | | (_) | |_  | |___| |__| |___ 
 |_|  |_|\__,_|_| |_|\__,_|\___|_|_.__/|_|  \___/ \__| |_____|_____\____|

*/


"[¶" & 
While ( 

 [
   i = 1 ;
   return = " \"" & GetNthRecord ( field ; 1 ) & "\""
 ] ;

 i < Get ( FoundCount ) ; 

 [ 
   i = i + 1 ;
   return = return & ",¶ \"" & GetNthRecord ( field ; i ) & "\""
 ] ;

 return

)
& "¶]"

a fresh take on a bunch of old custom functions that used tail recursion to do this kind of thing.
uses while(), so you'll need FM 18+ to use it.

Comments

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

ArrayField_FoundSet ( field )

Comments

Support this website.

Support this website.