FileMaker Pro Custom Functions

/* NoRepDigit custom function Author: Daniele Raybaudi Format: NoRepDigit ( hightDigit ; digitCount ) Params: hightDigit - number (max 9) digitCount - number (max 9) Result: returns a random number of "digitCount" digits with all different digits from 1 to "hightDigit" (produce in modalità random un numero di lunghezza: "digitCount" con cifre tutte diverse tra 1 e "hightDigit"); two examples (due esempi): NoRepDigit ( 5 ; 5 ) may return (può produrre): 12345; NoRepDigit ( 8 ; 5 ) may return (può produrre): 23781. "digitCount" can't ever be highter than "hightDigit" ("digitCount" non deve mai essere superiore a "hightDigit") the number returned has no zero inside (il numero creato non conterrà alcun zero). */ Let ([ num = Int ( Random * hightDigit ) + 1 ; next = digitCount - 1 ; result = num & Case ( next ; NoRepDigit ( hightDigit ; next ) ; "" ) ]; Case ( digitCount > 9 or hightDigit > 9 or digitCount > hightDigit ; "error" ; Length ( Filter ( result ; num ) ) > 1; NoRepDigit ( hightDigit ; digitCount ) ;// repeat the loop if the new digit isn't different (ricomincia da capo se una cifra si ripete) result ) )
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.