{"id":6797,"date":"2026-01-20T17:13:55","date_gmt":"2026-01-20T14:13:55","guid":{"rendered":"https:\/\/help.bothelp.io\/?p=6797"},"modified":"2026-03-27T19:24:17","modified_gmt":"2026-03-27T16:24:17","slug":"dostupnye-funkczii-v-shage-formula","status":"publish","type":"post","link":"https:\/\/help.bothelp.io\/en\/available-functions-in-the-formula-step\/","title":{"rendered":"Available Functions in the \"Formula\" Step"},"content":{"rendered":"

The “Formula” step supports a set of built-in functions for working with numbers, strings, dates, and logical conditions. They help perform calculations, transformations, and checks directly within the scenario, without external systems.<\/p>\n

For clarity, copy the template via the link<\/a> \u2013 click Copy in BotHelp<\/strong>, specify your account domain, and click Save Flow<\/strong>. Within a few minutes, the template will be copied to your account. You can then edit the blocks to suit your needs.<\/p>\n

Mathematical Functions<\/h2>\n

Arithmetic operations are supported: +<\/code>, -<\/code>, *<\/code>, \/<\/code><\/p>\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t
Function<\/strong><\/th>Description<\/strong><\/th>Example<\/strong><\/th>\n<\/tr>\n<\/thead>\n
round(x)<\/td>Rounds a number to the nearest integer (0.5 rounds up).
\nWhen using a numeric field, the function round round({%numeric_field%}, 3) rounds only to 3 decimal places (thousandths). For example, the number 2.123456789 becomes 2.123 after rounding.<\/td>		round(2.5) \u2192 3<\/td>\n<\/tr>\n
int(x)<\/td>Converts a value to an integer.<\/td>int(\"42\") \u2192 42<\/td>\n<\/tr>\n
float(x)<\/td>Converts a string to a floating-point number.<\/td>float(\"12.34\") \u2192 12.34<\/td>\n<\/tr>\n
str(x)<\/td>Converts a value to a text string.<\/td>str(100) \u2192 \"100\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

Let\u2019s look at calculation examples. Variables must be set in advance<\/strong>.<\/p>\n

Create a Formula step.<\/p>\n

“”””Calculate variable values”””
\nclient.A = 2 – 4 # Data type “Number, negative”
\nclient.B = 1.275 + 5 # Data type “Number, decimal”
\nclient.C = 5 * 10 \/ 2 # Data type “Number, integer”
\nclient.D = “10” # Data type “String”
\nclient.E = “10.5” # Data type “String”<\/p>\n

“”””Working with local variables”””
\nlocal1 = 2 # Assigned a local variable
\nlocal2 = 3<\/p>\n

Added local variables into a user variable<\/strong><\/p>\n

client.F = local1 + local2<\/p>\n

“”””Apply mathematical functions”””
\nclient.discount = round(client.B) # Round to nearest integer
\nclient.sum_orders = int(client.D) # Convert string to number
\nclient.life_number = float(client.E) # Convert string to number with decimal
\nclient.forecast = str(client.C) # Convert number to string<\/p>\n

In the Message step, display text to the subscriber<\/p>\n

\u2014 Calculate variable values
\nA = {%A%}
\nB = {%B%}
\nC = {%C%}
\nD = {%D%}
\nE = {%E%}
\n\u2014 Working with local variables
\nF = {%F%}
\n\u2014 Apply mathematical functions
\ndiscount = {%discount%}
\nsum_orders = {%sum_orders%}
\nlife_number = {%life_number%}
\nforecast = {%forecast%}<\/p>\n

Logical and Conditional Functions<\/h2>\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t
Function<\/strong><\/th>Description<\/strong><\/th>Example<\/strong><\/th>\n<\/tr>\n<\/thead>\n
if(condition, then_value, else_value)<\/td>Checks a condition. If it is true, returns then_value; otherwise, returns else_value.<\/td>if(client.age >= 18, \"\u0412\u0437\u0440\u043e\u0441\u043b\u044b\u0439\", \"\u041d\u0435\u0441\u043e\u0432\u0435\u0440\u0448\u0435\u043d\u043d\u043e\u043b\u0435\u0442\u043d\u0438\u0439\")<\/td>\n<\/tr>\n
if(condition, then_value)<\/td>If else_value is not specified, returns an empty string.<\/td>if(is_null(client.phone), \"\u041d\u043e\u043c\u0435\u0440 \u043d\u0435 \u0443\u043a\u0430\u0437\u0430\u043d\")<\/td>\n<\/tr>\n
is_null(var)<\/td>Checks if a variable is empty.<\/td>is_null(client.email) \u2192 True<\/td>\n<\/tr>\n
and, or, not<\/td>Logical operators for combining conditions.<\/td>if(a > 0 and b < 10, \"ok\")<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

Boolean values are supported: True<\/code>, False<\/code>.<\/p>\n

In this example, we calculate the final discount based on previous purchases and the number of completed lessons. Make sure all necessary variables are created in advance<\/strong>.<\/p>\n

#1. Loyalty: 20% discount if purchases > 3<\/p>\n

base_discount = if(client.sum_orders > 3, 20, 0)<\/p>\n

#2. Engagement: 20% for >=10 lessons, 10% for >=5<\/p>\n

engagement_discount = if(client.completed_lessons >= 10, 20, if(client.completed_lessons >= 5, 10, 0))<\/p>\n

#3. Final discount<\/p>\n

client.discount = base_discount + engagement_discount<\/p>\n

In line 2<\/strong> we use the logical if<\/code> condition:<\/p>\n