- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual

The **Random Number** function (RANDOM_NUMBER) generates a random number between the minimum and maximum value.

The **Random String** function has two required parameter:

Allowed Inputs: field value or a number

Either use the use the Query Builder to choose a field that contains a number to use or type a value to enter a number.

Allowed Inputs: field value or a number

Either use the use the Query Builder to choose a field that contains a number or use type a value to enter a number.

The output of the **Random Number** function returns a random number. The chances of two iterations of the **Random Number** function generating the same number more than once is based on the size of the range allowed. A minimum value of 0 and a maximum value of 1 would produce a 1 in 2 chance of getting the same value because there are only 2 possible values.

If you want a specific number of digits set the minimum and maximum values accordingly. For example if a length of 6 digits is required enter 100000 as min and 999999 as max and the function will always get a 6 digit number.

RANDOM_NUMBER(1,100) would result in a random number. Possibly “33”.

Copyright WorkXpress, 2023