Brian Dunning's FileMaker Custom Functions

RandomValue ( thelist )

Returns a single random value from the value list that is entered.

  Average rating: 4.2 (32 votes) Log in to vote

Jonathan Ray   Jonathan Ray
Richard Carlton Consulting
http://www.rcconsulting.com, http://www.data4life.net

Share on Facebook Share on Twitter

  Sample input:
RandomValue ( "Bill
Richard
Jay
John
Mary")
  Sample output:
John

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

Returns a single random value from the value list that is entered.

Function is handy when a random value is needed over a relationship using the List function in the "thelist" parameter.

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.