These are some advanced pre-defined functions you can use with your field values in the formula section of the document editor.




Get a random number in the range [0, n). If n is zero, or not provided, it defaults to 1.


n! (factorial of n: "n * (n-1) * (n-2) * … * 2 * 1") Deprecated. Use the ! operator instead.


Get the smallest (minimum) number in the list.


Get the largest (maximum) number in the list.


Hypotenuse, i.e. the square root of the sum of squares of its arguments.

pyt(a, b)

Alias for hypot.

pow(x, y)

Equivalent to x^y. For consistency with JavaScript's Math object.

atan2(y, x)

Arc tangent of x/y. i.e. the angle between (0, 0) and (x, y) in radians.

roundTo(x, n)

Rounds x to n places after the decimal point.

map(f, a)

Array map: Pass each element of a the function f, and return an array of the results.

fold(f, y, a)

Array fold: Fold/reduce array a into a single value, y by setting y = f(y, x, index) for each element x of the array.

filter(f, a)

Array filter: Return an array containing only the values from a where f(x, index) is true.

indexOf(x, a)

Return the first index of string or array a matching the value x, or -1 if not found.

join(sep, a)

Concatenate the elements of a, separated by sep.

if(c, a, b)

Function form of c ? a : b. Note: This always evaluates both a and b, regardless of whether c is true or not. Use c ? a : b instead if there are side effects, or if evaluating the branches could be expensive.

Did this answer your question?