Hi,

I'm looking for a method to generate random PIN numbers. These PIN numbers will be used to access a secure site.

Question:

How do I create a field that generates a random number (lets say with 5 digits?) For example: 47618

Thanks.

Round(Random * 100000, 0)

The "Random" function generates a number between zero and one. Multiply by 100000 to get a five-digit number, then round to the decimal point.

Don't make it a calc field, but a number field with the calculation auto-entered.

Thanks for the help!