Auto Enter 1 of 3 numbers

[Matthew R White]

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

 

[David Jondreau]

Something like this may work:

 

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

 

Put it in the auto-enter calculation dialog.

[mr_vodka]

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

[Raybaudi]

I like John's calculation.

 

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

 

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