Formula index

The reference is grouped by the kind of result you want. Every function entry includes its supported signature, required inputs or context, return value, a practical use, and an example.

Reference	Functions	Typical jobs
Conversion	7	Parse imported values and format client-facing output.
Text	25	Join, inspect, split, pad, clean, and encode text.
Date	31	Calendar calculations, periods, weeks, and workdays.
Time	4	Create and inspect times of day.
Timestamp	2	Current moments and exact UTC timestamps.
Numeric	18	Trigonometry, logarithms, finance, constants, and randomness.
Rounding	3	Round numbers, durations, and times by a significance.
Aggregation	4	Count, total, and select minimum or maximum values.
Null handling	2	Detect or replace missing values.
Duration	13	Build, measure, and calculate elapsed amounts.
Location	4	Build coordinates and calculate distance.
Special	16	Conditions, files, device data, hashing, and responses.
Session	15	Current database, record, user, role, browser, and URL data.
Ask and Parameter	2	Define and evaluate user-supplied parameters.
Operators	15	Arithmetic, comparison, concatenation, and boolean logic.

Function names are case-sensitive. The reference uses optional inside square brackets and ... for repeatable arguments; do not type those markers into a formula.

Last modified on September 7, 2026

Dsync guides

Configuration

Formula language

Formula reference