Differences

This shows you the differences between two versions of the page.

Link to this comparison view

expression function - random number [2016/09/14 14: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"​.
expression function - random number.txt ยท Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2019