Expressions (CEL)
Defaults, computed fields, rules, depends_on, dashboard filters and flow conditions are written in a dialect of CEL. The same dialect runs in the kernel, the Python validator and the browser.
yaml
compute: round(value * option('stage', 'probability') / 100)
check: stage != 'lost' || lost_reason != ''
default: posting_date + duration(customer.payment_days)
filter: docstatus == 1 && paid_amount < grand_total
if: app_installed('invoicing')| Item | Meaning |
|---|---|
== != < <= > >= && || ! + - * / %, ? :, in | Operators |
customer.payment_days | Member access through a link loads the linked record (overlay fields too) |
today(), now() | ISO date / datetime in the organisation's timezone |
duration('7d'), duration(n) (n days), date ± duration | Date arithmetic; result is an ISO date |
add_months(date, n), days_between(a, b) | Calendar months (day clamped to the month's end: 2026-01-31 + 1 = 2026-02-28) and whole days from a to b |
distance_m(a, b) | Metres between two geo positions ({lat, lng}), 1e9 when either has none (a radius check fails without a position) |
epoch(t), timestamp(n) | Datetime (or date, midnight UTC) to whole Unix seconds, and back to an RFC 3339 UTC datetime; null stays null (poll cursors) |
round(x), max(…), min(…), size(x), sum(list), list.map(x, expr), list.exists(x, expr), list.all(x, expr) | Numbers and lists |
int(x), double(x), string(x) | Conversions |
option('field', 'attr') | An attribute of the selected option of a select field (e.g. probability) |
app_installed('invoicing') | Whether a module or app is installed |
truncate(s, n), s.contains(t), startsWith, endsWith, matches, trim(), lowerAscii(), upperAscii() | Text |
user.name, user.email, user.roles, user.outlets, event.* | The current user; the triggering event in flows |
org.id, org.code, org.name, org.legal_name, org.npwp, tax.pkp, tax.ppn_rate, tax.dpp_num, tax.dpp_den | The current org and its PPN settings, e.g. tax.pkp ? tax.ppn_rate : 0 |
Dates are ISO strings and compare as strings. Missing values are '' for text, date and link, 0 for numbers and false for checks. String literals inside YAML need both quotes: default: "'new'".
The validator checks every identifier against the model's fields (and linked models' fields) and suggests the closest name when one is wrong.