List2 ( RelatedField )

Non-Truncating Aggregate List function

Average rating: 3.3 (123 votes) Log in to vote

mfrapp
.
http://127.0.0.1

Sample input:

List2 ( InvoiceItems::Comment)

for 5 related records, the third record has a empty comment field

Sample output:

Comment1¶
Comment2¶
¶
Comment4¶
Comment5¶

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

Case(
not IsValid (RelatedField) ; "?" ;
Let ([
$$__id_lst2_y2w5x89q__[1] = If ( IsEmpty ( $$__id_lst2_y2w5x89q__[1] ) ; 1 ; GetAsNumber ( $$__id_lst2_y2w5x89q__[1] ) + 1 );
$$__id_lst2_y2w5x89q__[2] = IsValid( GetNthRecord ( RelatedField ; $$__id_lst2_y2w5x89q__[1] ));
$$__id_lst2_y2w5x89q__[3] = $$__id_lst2_y2w5x89q__[3] & If ( $$__id_lst2_y2w5x89q__[2] ; GetNthRecord ( RelatedField ; $$__id_lst2_y2w5x89q__[1] ) & ¶ ; "" ) //output
]; If( $$__id_lst2_y2w5x89q__[2] ; List2( RelatedField ) ; Let ([ _return = $$__id_lst2_y2w5x89q__[3] ; $$__id_lst2_y2w5x89q__[1] = "" ; $$__id_lst2_y2w5x89q__[2] = "" ; $$__id_lst2_y2w5x89q__[3] = "" ]; _return ) ) ) //cleanup and return results
)

Will return a number of values equal to the related records count.

This function behaves like the FileMaker function List() but will not truncate the result if one the field is empty.

Comments

		JF, Montreal Dec 3, 2014
Thank you, I was looking a way to fix that problem.

		carolq, huntinton beach, ca Sep 9, 2015
Ditto...just want I needed.

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

List2 ( RelatedField )

Comments

Support this website.

Support this website.