FileMaker Pro Custom Functions

/* -------------------------------------------------------------------------------- STANDALONE, QUICK & DIRTY LIST RANDOMIZER USING RECURSION This function 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¶" Jan -------------------------------------------------------------------------------- */ Let ( [ listLength = ValueCount ( listToShuffle ) ; randomIndex = Ceiling ( Random * listLength ) ; randomValue = MiddleValues ( listToShuffle ; randomIndex ; 1 ) ; remainderLead = If ( randomIndex > 1 ; LeftValues ( listToShuffle ; randomIndex - 1 ) ; "" ) ; remainderTail = If ( randomIndex < listLength ; RightValues ( listToShuffle ; listLength - randomIndex ) ; "" ) ; remainder = remainderLead & remainderTail ] ; If ( listLength ≤ 1 ; listToShuffle ; randomValue & shuffleList (remainder) ) )
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.