Documentation › Labels › Variable formulas
Variable formulas
Compute label content with functions: text, numbers, dates and logic.
A formula is text with expressions between {{ }}. Arguments are separated by a semicolon; function names are case-insensitive; operators are & (concat), + − * / and comparisons (= <> < > <= >=).
| Category | Examples of functions |
|---|---|
| Text | LEFT, RIGHT, MID, LEN, UPPER, LOWER, PROPER, TRIM, CONCAT, REPLACE, PADLEFT, PADRIGHT, SPLIT, UNACCENT, ONLYDIGITS… |
| Numbers | ROUND, INT, ABS, MOD, MIN, MAX, VALUE, FORMATNUMBER, CHECKDIGIT (GS1)… |
| Dates | TODAY, NOW, DATEVALUE, FORMATDATE, DAY/MONTH/YEAR, WEEK, JULIAN, ADDDAYS/MONTHS/YEARS, DATEDIFF… |
| Logic | IF, AND, OR, NOT, ISEMPTY, DEFAULT. |
| Example | Result |
|---|---|
{{PADLEFT(SEQ; 6)}} | 000042 |
{{CONCAT(GTIN12; CHECKDIGIT(GTIN12))}} | GTIN-13 with its check digit |
{{FORMATDATE(ADDMONTHS(ProdDate; 18); "dd/MM/yyyy")}} | best-before date |
📘
Complete reference — every function with examples and results: Variable Formulas Reference (PDF).