Brian Dunning's FileMaker Custom Functions

shuffleList ( listToShuffle )

Standalone, quick & dirty list sort order randomizer using recursion.

  Average rating: 4.4 (37 votes) Log in to vote

Jan Bardi   Jan Bardi

Share on Facebook Share on Twitter

  Sample input:
shuffleList ( "1¶2¶2¶")
  Sample output:
"1¶2¶2¶" or "2¶1¶2¶" or "2¶2¶1¶"

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

Recursively generates a randomly re-sorted value list of the input list. Duplicate values are not de-duplicated (inputting "1¶2¶1" can return "2¶1¶1" but not "2¶1"). The usual FileMaker recursion limits apply - the function fails when the input list length approaches or exceeds 10000 values - FMPro's recursion limit is 10000 iterations. It relies on FMPro's "random" function for the randomisation - in FileMaker we trust...

Syntax: shuffleList ( listToShuffle )

In: listToShuffle - the return delimited list to randomly re-sort

Return type: Text (a return delimited list with the same values, but now in a randomly mixed sort order)

shuffleList ( "1¶2¶2¶") ---> "1¶2¶2¶" or "2¶1¶2¶" or "2¶2¶1¶"




Jessica Reitz   Jessica Reitz, Tulsa, OK
Jun 16, 2016
I used this to create a database that generates Bingo Cards.. Any kind of Bingo, any number of cards, with the push of a button.
How sweet is this function?! Thank You!!!!

Log in to post comments.


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

Under construction. Email me your wish list for improvements.