mkListMerge ( mergeString )

Use a formatted string to output several fields from a list of records

Average rating: 3.5 (2 votes) Log in to vote

Michael Kupietz - Show more from this author
Michael Kupietz FileMaker Consulting
https://michaelkupietz.com

Sample input:

mkListMerge("<> is from <>")

(For a table "Data" with fields Name, City:
Name, City:
Adam, Andover
Bert, Boston
Charles, Charleston)

Sample output:

"Adam is from Andover¶
Bert is from Boston¶
Charles is from Charleston"

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

Let (
        [
                $mkReservedCountermkLE = $mkReservedCountermkLE + 1 ;
                evalStringProc =
                    Substitute (
                        mergeString ;
                        [ "<<" ; "\"&getNthRecord(" ] ;
                        [ ">>" ; "," & $mkReservedCountermkLE & ")&\"" ];
                        [ "\<\<" ; "<<" ] ;
                        [ "\>\>" ; ">>"]
                        ) ;
                result =
                    If (
                        IsValid ( Evaluate ( "\"" & evalStringProc & "\"" )  ) ;
                        Evaluate ( "\"" & evalStringProc & "\"" )  &
                            If (
                                evalStringProc≠mergeString ;
                                "¶" & mkListMerge ( mergeString ) ;
                                ""
                                ) ;
                        if($mkReservedCountermkLE>1,"","?")
                        ) &
                    Let ( $mkReservedCountermkLE = "" ; "" )
        ] ;
        result
        )

/* Function uses reserved variable name $mkReservedCountermkLE. Don't use that variable name in your solution. */

This function is like List(), except instead of accepting a single field name, it accepts a string which can contain multiple field names delimited as <>.

If you do not include any valid merge fields, it only outputs the string once.

If you need to use << or >> in the string, escape them as \<\< or \>\>.

Comments

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

mkListMerge ( mergeString )

Comments

Support this website.

Support this website.