- 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”.