fd_ValueList ( Field )

Creates a valuelist from a field of the current found set

Average rating: 5.0 (1 vote) Log in to vote

flusheDData - Show more from this author
n/a
http://www.udias.com

Sample input:

fd_ValueLIst ( MyTable::MyField )
where
MyField has
Alpha in the first record
Bravo in the second record
Charlie in the third record

Sample output:

Alpha
Bravo
Charlie

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

////////////////////////////////////////////////////////////////////
//Creates a value list from from field of the current found set
//Tail recursive function
//12/09/2022 flusheDData
////////////////////////////////////////////////////////////////////
Let ( 
	[ 
	$i = $i + 1 ; 
	$item= GetNthRecord ( Field ; $i ) ; 
	$result = $result & 
	Case ( 
		not PatternCount ( ¶ & $result & ¶ ; ¶ & $item & ¶ ) ; 
		Case ( 
			not IsEmpty ( $result ) ; 
			¶ 
		) & 
		GetNthRecord ( Field; $i ) 
	) 
	] ; 
	Case ( 
		$i < Get ( FoundCount ) ; 
		fd_ValueList ( Field ) ; 
		Let ( 
			[ 
			_result = $result ; 
			$i = "" ; 
			$result = "" ; 
			$item = "" 
			] ; 
			_result 
		) 
	) 
)

This tail recursive function creates a value list (unique values) from a given field of the current found set.
Pleasse note that this tail recursive function is limited to 40000 values.
The values order is the one of the current found set.

Comments

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

fd_ValueList ( Field )

Comments

Support this website.

Support this website.