ShuffleValues ( List )
Re-orders a list of values, returning them in a random sequence.
Average rating: 4.1 (34 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This is a relatively straightforward recursive function designed to receive a list (values separated by carriage returns) and return it in a random order.
The function includes a closing condition which serves the purpose of ensuring that the returned list does not have an added trailing CR. For consistency with FileMaker 7s other Xvalues functions (all of which add a trailing CR if one isn't already present), this could be left off if desired.
Note that as the returned order is random it is *possible* that the list may be returned in the same order - though the probability of this reduces radically as the number of items on the list increases (eg with a list of only two items the probability that they will be returned with their order unchanged is 0.5, with three items the probability reduces to 0.17 and with four it is approx 0.04)
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.