 | At-sign functions lambda functionalities... last change: 11.08.2026 14:24 |
List of lambda functions...
Color
Data
Date and time
Financial
Numeric
Other
 | Blue - inserts the code of the blue colour from the application palette... |
| Blue(text) - colours the given text blue from the application palette... |
| Gray - inserts the code of the gray colour from the application palette... |
| Gray(text) - colours the given text gray from the application palette... |
| Green - inserts the code of the green colour from the application palette... |
| Green(text) - colours the given text green from the application palette... |
| Orange - inserts the code of the orange colour from the application palette... |
| Orange(text) - colours the given text orange from the application palette... |
| Purple - inserts the code of the purple colour from the application palette... |
| Purple(text) - colours the given text purple from the application palette... |
| Red - inserts the code of the red colour from the application palette... |
| Red(text) - colours the given text red from the application palette... |
| Teal - inserts the code of the teal colour from the application palette... |
| Teal(text) - colours the given text teal from the application palette... |
| Attribute(identifier,attribute) - returns an attribute of a fragment by its identifier... |
| Content(identifier) - returns the content of a fragment of this information by its identifier... |
| ChildValue(type,property,fallback) - returns a property of the first child of the given type, the third parameter is used when there is no such child... |
| ChildValueLast(type,property,fallback) - the same as ChildValue, but from the last child... |
| Link(id,text) - puts a link to an information into the text: in the application a click shows it, in an exported page it leads to its page. Without the second parameter the title of the information is shown... |
| Parent(identifier) - returns the content of a fragment of the parent by its identifier... |
| Random(type) - returns the id of a randomly chosen information of the given type... |
| Value(id,property) - returns a property of the information with the given id... |
| ValueSumPicker(field,property) - sums a property of the informations chosen in a picker fragment... |
| Date - returns today's date in the dd.mm.yyyy format... |
| Date(date) - returns the given date in the dd.mm.yyyy format, the parameter is milliseconds or a date... |
| Day - returns today's day of the month, always two digits... |
| Day(date) - returns the day of the month of the given date, always two digits... |
| DayOfWeek - returns today's day of the week according to the language... |
| DayOfWeek(date) - returns the day of the week of the given date according to the language... |
| FormattedDate - returns today's date in the yyyy.mm.dd format, which can be compared as text... |
| FormattedDate(date) - returns the given date in the yyyy.mm.dd format, which can be compared as text... |
| FormattedDateTime - returns today's date and time in the yyyy.mm.dd hh:mm format... |
| FormattedDateTime(date) - returns the given date and time in the yyyy.mm.dd hh:mm format... |
| Month - returns the current month as a number, always two digits... |
| Month(date) - returns the month of the given date as a number, always two digits... |
| MonthName - returns the name of the current month according to the language... |
| MonthName(month) - returns the name of the month by its number, according to the language... |
| Time - returns the current time in the hh:mm format... |
| Time(date) - returns the time of the given date in the hh:mm format... |
| Year - returns the current year... |
| Year(date) - returns the year of the given date... |
| Money(number) - returns the number as a monetary value with the currency and separated thousands... |
| MoneyColored(number) - returns the number as a monetary value, negative in red and the rest in green... |
| ValueAsMoney - returns the value of this information as a monetary value... |
| 2digits(number) - formats number so, that it contains minimum of 2 digits... |
| Difference(number1,number2) - subtracts the second number from the first... |
| Divide(number1,number2) - divides the first number by the second, the result has five decimal places, division by zero gives nothing... |
| HoursDifference(date1,date2) - returns the difference between two dates in hours, always positive... |
| IsNotPair(number) - returns 1 when the number is odd, 0 otherwise... |
| IsPair(number) - returns 1 when the number is even, 0 otherwise... |
| Multiply(number1,number2) - multiplies two numbers... |
| Percent(number) - returns the number as a percentage with two decimal places... |
| Round(number) - rounds the number to two decimal places... |
| Summary(number1,number2) - adds two numbers... |
| If(condition;text;else) - returns the first text when the condition is 1, the second one otherwise; the parts are separated by a semicolon, so the text may contain a comma... |
created by dzI/O in cooperation with Claude
(2025-2026)
(2025-2026)