# 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

## 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

#### References

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

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