Zyllio Documentation English
Pages
Tutoriels
Formulas
The formula editor is a powerful tool within our No-Code platform that allows you to create custom formulas. These formulas can integrate text, functions, and enable the display of dynamic data such as variables, calculations, table data, images, and more.
Accessing the Editor
Certain component and action properties support formulas, typically when the property expects text. For example, the Text property of the Label Text component.
Click on the menu to the right of the property to view all available options. Here, the Text property can be populated from:
Select Formula to access the formula editor.
Formula Editor
The formula editor allows you to combine text with contextual data. To do this, simply enter the text and drag and drop the required functions.
For example: “You have ordered [Count rows] products.” Here, [Count rows] represents a dynamic data point (the result of a function) that calculates the number of rows from a table.
Fonctions
Categorie
Description
Examples
Condition
Allows displaying text if a condition is true
IF THEN
IF THEN_ELSE
Number
Displays, generates, and calculates a number
AMOUNT
CALCULATE
RANDOM
Date
Allows displaying a simple date, calculating a duration between two dates, and performing date calculations
Current date & time
Duration from today
Add
Substract
Text
Allows transforming a text, searching for, and replacing a pattern in a text
Text
Lowercase
Uppercase
Capitalize
Concatenate
Substring
Replace
Split
Data
Displays the result of an aggregation on tables
Count rows
Maximum in rows
Minimum in rows
Average in rows
Sum in rows
Image
Displays an image. The path must be complete (absolute)
Image
Geolocation
Displays the distance between the GPS position or between two positions
Distance from position
Distance
Payment
Displays a cart and details
Print Cart
Cart amount
JSON
Allows searching for information in a JSON message
JSON Query
There are no rows in this table
Formats
Format
Description
Examples
Text
Formats the data as text
Please scan your barcode
Whole number
Formats the data as an integer. Decimal numbers are truncated (ignored).
2.2 => 2
077 => 77
123.45 => 123
Number
Formats the data as a decimal number. The format supports a specific number of decimals and a unit.
If the specified symbol is a dollar ($), the dollar symbol appears before the number.
1.2 => 1.20 €
12.23567 => 12 km
34.3654 => 4452.3 °
12.32 => $12.32
Currency
Formats the data as an amount with currency. The number is displayed with 2 decimal places.
0.2 => 0.20€
5.0 => $5.00
Distance
Formats the data as a distance
The most appropriate unit is used automatically.
5.2 => 5.2 m
85200 => 85.2 km
Duration
Formats the data as a duration
The most appropriate unit is used automatically or can be manually selected.
5.2 => 5.2 s
600 => 5 m
Rich text
Displays HTML code
i
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.