Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.3   7.4   7.5   8.0   8.1   8.2   8.3   8.4   8.5   8.6    Statistic  


Creates the cross product from two lists.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
List 6.1 Yes Yes Yes Yes Yes
MBS( "QuickList.CrossProduct"; List1; List2 { ; Prefix; Midfix; Postfix; Flags } )   More


Parameter Description Example value
List1 The reference to the first quicklist. $List1
List2 The reference to the second quicklist. $List2
Prefix Optional
The prefix to use
Midfix Optional
The middle to use.
This text is put between texts from both lists.
Postfix Optional
The postfix to use
Flags Optional
Pass 1 to return result as new QuickList.
This new list must be freed later using QuickList.Free function. Pass 0 (Default) to modify the list in the List1 parameter.
Add 2 for a diagonal cross, so we combine each element of first list with the same element index from the second list.


Returns list or error.


Creates the cross product from two lists.
Optionally adds prefix, postfix and midfix.
Returns empty list if one of the lists are empty!


Try in a Let statement:

list1 = MBS("QuickList.New"; "Hello¶World");
list2 = MBS("QuickList.New"; "1¶2");
e = MBS("QuickList.CrossProduct"; list1; list2);
r = MBS("QuickList.GetList"; list1);
d = MBS("QuickList.Free"; list1);
d = MBS("QuickList.Free"; list2)
]; r)

See also

Blog Entries

Created 4th March 2016, last changed 17th March 2016

QuickList.Count   -   QuickList.DeCombine

Feedback: Report problem or ask question.

MBS FileMaker Plugins