Brian Dunning's FileMaker Custom Functions

RandomInteger ( start ; stop )

Generates a signed random integer value.

  Average rating: 4.4 (31 votes) Log in to vote

Kalle Samuelsson   Kalle Samuelsson
Premium System

Share on Facebook Share on Twitter

  Sample input:
RandomInteger ( 1; 5 )
RandomInteger ( -5; -1 )
RandomInteger ( -5; 5 )
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

This function generates a random signed interger value (or acctually as big a number as FMP allows it to be) streching across zero if a negative start-param and positiv stop-param is givven.
The value returned will be inside or equal to the start and stop params sent to the function. The stop-param must always be larger then the start param!

I commonly use this function as an addition to script step "GoToRecord[ NumberByCalculation ]" wich make a easy way of selecting a random record. The function call would the look like this:

RandomInteger( 1 ; get(foundcount) )

Simple but effective, enjoy!



Eli   Eli, California
Sep 28, 2016
Excellent! Thank you very much
Magnus   Magnus, Göteborg
Apr 5, 2017
Just what I needed. Thanks mate!

Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: