I have a number field that I would like to auto enter either (2, 3, or 9) at random every time a new record is created.

Please help!

Thanks

Matt

 

I tried to do a sequenced auto enter but filemaker simply counts up from 1 and I can't specify the 3 numbers.

 

Thanks

 

Something like this may work:

 

Choose ( Mod ( Truncate ( Random * 100 ; 0 ) ; 3 )  ; 2 ; 3 ; 9 )

 

Put it in the auto-enter calculation dialog.

Choose ( Floor ( Random * 3 ); 2; 3; 9 )

I like John's calculation.

 

This is mine ( less semicolons to write for many numbers ):

 

Middle ( 239 ; Ceiling ( Random * 3 ) ; 1 )