How to Create a Random Number Sequence in FileMaker Pro 11

Written by ellis davidson
  • Share
  • Tweet
  • Share
  • Email

The FileMaker Pro "Random" function allows you to use random numbers in a calculation. It generates a number greater than or equal to zero, and less than one. You can use additional mathematical formulas to generate numbers or integers within a range. The "Replace" command will set a field with a sequence of random numbers that will not change in the future.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

  1. 1

    Select the field of your database that you would like to fill with a random number sequence.

  2. 2

    Choose "Replace Field Contents" from the "Records" menu.

  3. 3

    Click the "Specify" button next to "Replace with calculated result."

  4. 4

    Enter the random number calculation. Use just the word "Random" to generate a number between zero and one (zero is possible, but one is not). If you wish to generate a specific range of random numbers, use a calculation. For example, to generate a random integer between one and six, use "Int(Random * 6) + 1". "Random*6" generates a number between 0 and 5.999; "Int" rounds this down to an integer; "+ 1" shifts the range from 0 to 5, to 1 to 6. Click "OK" to replace the field contents.

  5. 5

    Repeat these steps for each field you wish to use as a random sequence. To simulate two dice, for example, you could use two fields named "Die1" and "Die2," or you could use the single calculation "(Int(Random * 6) + 1) + (Int(Random * 6) + 1)".

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.