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
Select the field of your database that you would like to fill with a random number sequence.

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

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

- 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
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)".