A READER ASKS: FileMaker Random Return Values Without Repeats

From Dwayne Wright PMP
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Is there a way to be sure the random number generated won't repeat over a set of, say, 3,000 calculations? Right now I have it set to seven digits, but is there a way to be 100% certain there will be no repeats?

I did a quick search on briandunning.com for a custom function that might do the trick because you would need some sort of recursion. Custom functions are the only way to have a calculation loop, unless you are setting the value with a script. I did find one that looks quite promising and I hope you are using FileMaker Advanced (necessary to add your own custom functions to your FileMaker files).

The custom function is NoRepDigit and was posted by Daniele Raybaudi, ACI (www.aci.it) and here is the direct link to the post ...

More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2009 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.