GENERAL USER
Elevate your document automation in Docdown using formulas and functions. Functions allow you to adjust your document's content dynamically based on specific criteria.
Available Functions
These are some advanced pre-defined functions you can use with your field values in the formula section of the document editor.
| Function Name | Description | Parameters | Example Usage |
|---|---|---|---|
|
|
|||
| random(n) | Generates a random number within the range [0, n). | n: upper limit (optional, default=1) |
random(10)
|
| n! | Calculates the factorial of n. | n: number |
5!
|
| min(a,b,…) | Identifies the smallest number in a given list. | a, b, …: list of numbers |
min(3, 7, 1)
|
| max(a,b,…) | Identifies the largest number in a given list. | a, b, …: list of numbers |
max(3, 7, 1)
|
| hypot(a,b) | Calculates the hypotenuse or the square root of the sum of the squares of its arguments. | a, b: sides of a right triangle |
hypot(3, 4)
|
| pyt(a, b) | Alias for hypot, calculates the hypotenuse. | a, b: sides of a right triangle |
pyt(3, 4)
|
| pow(x, y) | Raises x to the power of y. | x: base, y: exponent |
pow(2, 3)
|
| atan2(y, x) | Calculates the arc tangent of x/y, the angle in radians between (0, 0) and (x, y). | y: width, x: height |
atan2(90, 15)
|
| roundTo(x, n) | Rounds x to n decimal places. | x: number to round, n: number of decimal places |
roundTo(3.14159, 2)
|
| map(f, a) | Applies function f to each element in array a, returning an array of the results. | f: function, a: array |
map(f, [1, 2, 3])
|
| fold(f, y, a) | Reduces array a into a single value y by applying function f to each element. | f: function, y: initial value, a: array |
fold(f, 0, [1, 2, 3])
|
| filter(f, a) | Filters array a by function f, returning an array of elements for which f is true. | f: function, a: array |
filter(f, [1, 2, 3, 4])
|
| indexOf(x, a) | Finds the first index of value x in array a; returns -1 if not found. | x: value, a: array |
indexOf('Invoice', ['Report', 'Invoice', 'Memo'])
|
| join(sep, a) | Joins the elements of array a into a string, separated by sep. | sep: separator, a: array |
join("; ", ['Report', 'Invoice', 'Memo'])
|
| if(c, a, b) |
Evaluates condition c; returns a if true, b otherwise. Note: always evaluates both a and b. |
c: condition, a: value if true, b: value if false |
if(x>10, 'High', 'Low')
|