- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
This shows you the differences between two versions of the page.
expression function - random number [2016/09/14 18:19] |
expression function - random number [2016/09/14 18:19] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Random Number (Expression Function) ====== | ||
+ | ===== Purpose ===== | ||
+ | The **Random Number** function (RANDOM_NUMBER) generates a random number between the minimum and maximum value. | ||
+ | |||
+ | {{:rand_number_inital.png?direct&600|}} | ||
+ | |||
+ | ===== Parameters ===== | ||
+ | The **Random String** function has two required parameter: | ||
+ | |||
+ | ==== Minimum Value ==== | ||
+ | |||
+ | Allowed Inputs: [[Field|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. | ||
+ | |||
+ | ==== Maximum Value ==== | ||
+ | |||
+ | Allowed Inputs: [[Field|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. | ||
+ | |||
+ | ===== Output ===== | ||
+ | |||
+ | 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. | ||
+ | |||
+ | === String Length === | ||
+ | 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. | ||
+ | |||
+ | ===== Example ===== | ||
+ | |||
+ | RANDOM_NUMBER(1,100) would result in a random number. Possibly "33". |