ListField_FoundSet ( field )

Lists each value in a specific field for the current found set by using the While() function

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:

ListField_FoundSet( PrimaryKey )

Sample output:

JOB-99986956-38DD-4B99-93B6-E27B68DF01F8
JOB-99986956-38DD-4B99-93B6-E27B68DF01F8
JOB-73AA49E8-C86A-4F96-AEA4-0936049BC436
JOB-F033C55F-D77D-4682-9563-2EE2360B297D
JOB-3E49E771-D74D-43BD-8EB0-5FCA9744406E
JOB-2D8C2A12-B7F8-4ABA-B209-1CF51047DE98
JOB-71735AD8-D35D-4A1D-8B31-B0198E58D664
JOB-95B6C004-8028-43AC-83EC-58E2CCC519E4
JOB-95B6C004-8028-43AC-83EC-58E2CCC519E4
JOB-95B6C004-8028-43AC-83EC-58E2CCC519E4

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

)

Version 1, 2023-03-31
A modern take on older custom functions that use tail recursion.
This one uses the While() function instead, so it requires FileMaker 18 or later.

Comments

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

ListField_FoundSet ( field )

Comments

Support this website.

Support this website.