Blockspot Blocks Documentation

User-friendly reference for Blockspot's no-code formula blocks.

Date & Time

TODAY

Returns: Date

Returns today's date in the selected timezone.

Formula example

TODAY(0;0;0;"UTC")

Inputs

➡️ HOUR
➡️ MINUTE
➡️ SECOND
➡️ TIMEZONE

DATE

Returns: Date

Builds a Date/DateTime from a date string and time parts (hour/minute/second) in a timezone.

Formula example

DATE("2025-12-22";0;0;0;"UTC")

Inputs

➡️ DATE
➡️ HOUR
➡️ MINUTE
➡️ SECOND
➡️ TIMEZONE

DATE_IS

Returns: Boolean

Checks whether a date falls into a given period/range (e.g., week, this month) using a locale.

Formula example

DATE_IS(dt:end_date ; THIS_WEEK ; "en-GB")

Inputs

➡️ DATE
➡️ PERIOD THIS_WEEK THIS_WEEK_SO_FAR LAST_WEEK NEXT_WEEK THIS_MONTH THIS_MONTH_SO_FAR LAST_MONTH NEXT_MONTH THIS_QUARTER THIS_QUARTER_SO_FAR LAST_QUARTER NEXT_QUARTER THIS_YEAR THIS_YEAR_SO_FAR LAST_YEAR NEXT_YEAR LAST_7_DAYS LAST_14_DAYS LAST_30_DAYS LAST_60_DAYS LAST_90_DAYS LAST_180_DAYS LAST_365_DAYS
➡️ LOCALE

DATE_DIFF

Returns: Number

Computes the difference between two dates in a chosen unit.

Formula example

DATE_DIFF(DAY ; dt:start_date ; dt:end_date)

Inputs

➡️ UNIT HOUR DAY MONTH YEAR
➡️ DATE1
➡️ DATE2

DATE_FORMAT

Returns: String

Formats a date into a text representation using a format pattern and locale/timezone.

Formula example

DATE_FORMAT("Y-m-d h:i:s" ; dt:start_date)

Inputs

➡️ FORMAT "Y-m-d"" "Y-m-d h:i:s" "d/m/Y" "d/m/Y h:i:s"
➡️ DATE

NOW

Returns: Date

Returns the current date & time in the selected timezone.

Formula example

NOW("UTC")

UI label: NOW Timezone

Inputs

➡️ TIMEZONE

YEAR, MONTH, DAY_OF_MONTH, DAY_OF_WEEK, DAY_OF_YEAR, HOUR_OF_DAY, MINUTE_OF_HOUR

Returns: Number

Extracts a part of a date (year, month, day, hour, …).

Inputs

➡️ PART Year Month Day of month Day of week Day of year Hour of day Minute of hour
➡️ DATE

*DATE PICKER

Returns: String

Lets you pick a fixed date value.

Formula example

none

Inputs

No inputs.

SHIFT_DATE

Returns: Date

Shifts a date forward/backward by a number of units (days/weeks/months/years).

Formula example

SHIFT_DATE(1 ; -(2) ; 3; dt:end_date)

Inputs

➡️ DAY_SIGN_MODIFIER add substract
➡️ DAY_EXPRESSION
➡️ MONTH_SIGN_MODIFIER add substract
➡️ MONTH_EXPRESSION
➡️ YEAR_SIGN_MODIFIER add substract
➡️ YEAR_EXPRESSION
➡️ DATE

SHIFT_WEEKDAY

Returns: Date

Moves a date to a chosen weekday, either forward or backward. The strict option controls whether the current date can be returned, and occurrence lets you move to the 1st, 2nd, etc. matching weekday.

Formula example

SHIFT_WEEKDAY("NEXT";1;1;dt:start_date;"en-US";TRUE())

UI label: Local

Inputs

➡️ DATE
➡️ DIRECTION Next Previous
➡️ OCCURENCE
➡️ DAY MONDAY=1 TUESDAY=2 ... SUNDAY=7
➡️ LOCALE
➡️ STRICT True False

TODAY

Returns: Date

Returns today's date at midnight in the selected timezone.

Formula example

TODAY("Europe/Paris")

Inputs

➡️ TIMEZONE

Errors

TRY

Returns: Mixed-value

Attempts an expression and returns a fallback value or raise a new error if it raises an error.

Formula example

TRY(n:count / 0;IF(n:count > 1500 ; 1 ; 0))

Inputs

➡️ EXPRESSION
➡️ FALLBACK VALUE / ERROR

THROW

Returns: None

Raises/returns an error value that can be caught by TRY.

Formula example

THROW(\"Divide by 0\")

Inputs

➡️ ERROR MESSAGE

Logic

BETWEEN

Returns: Boolean

Checks whether a value is inside a range (inclusive).

Formula example

BETWEEN(3,0,3)

Inputs

➡️ EXPRESSION
➡️ MIN
➡️ MAX

STR_EQ, STR_NEQ, STR_CONTAINS, STR_DOESNOTCONTAIN, STR_STARTSWITH, STR_ENSDWITH

Returns: Boolean

Compares two strings using the selected operator.

Formula example

STR_ENSDWITH("KEYBOARD" ; "BOARD")

Inputs

➡️ STRING
➡️ OPERATOR = <> Contains Does not contain Starts with Ends with
➡️ STRING

BETWEEN

Returns: Boolean

Checks whether a date is inside a range (inclusive).

Formula example

BETWEEN(NOW("UTC") ; dt:start_date ; dt:end_date)

Inputs

➡️ DATE
➡️ MIN DATE
➡️ MAX DATE

IFELIF

Returns: Mixed-value

Defines a IF / ELSE IF block with default value.

Formula example

IFELIF( "Water"; [{ OR(STR_EQ(s:season ; "WINTER");STR_EQ(s:request ; "DRINK")) : "Hot Coffee"} ; { OR(STR_EQ(s:season ; "SUMMER");STR_EQ(s:request ; "DRINK")) : "Rosé Wine"}] )

Inputs

➡️ CONDITION & RETURN VALUE
➡️ DEFAULT VALUE

SWITCH

Returns: Mixed-value

Defines a case branch used inside a SWITCH block.

Formula example

SWITCH(s:product_category;"UNKNOWN FAMILY"; [{ "TV" : "AUDIO/VIDEO"} ; { "PC" : "IT"} ; { "KEYBOARD" : "IT"}])

Inputs

➡️ VALUE
➡️ COMPARE VALUE
➡️ RETURN VALUE
➡️ DEFAULT VALUE

DATE_EQ, DATE_NEQ, DATE_LT, DATE_LTE, DATE_GT, DATE_GTE

Returns: Boolean

Compares two dates using the selected operator .

Formula example

DATE_EQ(dt:start_date ; dt:end_date)

UI label: Date

Inputs

➡️ DATE
➡️ OPERATOR = <> < <= > >=
➡️ DATE

IF

Returns: Mixed_value

Returns one of two values depending on a condition (IF condition THEN value ELSE value).

Formula example

IF(0 = 0 ; "A" ; "B")

Inputs

➡️ CONDITION
➡️ THEN
➡️ ELSE

ISTRUE, ISFALSE

Returns: Boolean

Checks whether a boolean is TRUE or FALSE.

Formula example

ISTRUE(TRUE())

Inputs

➡️ BOOLEAN

NOT

Returns: Boolean

Inverts a boolean value (TRUE becomes FALSE, FALSE becomes TRUE).

Formula example

NOT(TRUE())

Inputs

➡️ BOOLEAN

=, <>, <, <=,>, >=

Returns: Boolean

Compares two numbers using the selected operator (>, <,=, etc.).

Formula example

0 = 0

Inputs

➡️ NUMBER
➡️ OPERATOR = <> < <= > >=
➡️ NUMBER

OR / AND / XOR

Returns: Boolean

Logical operator : OR / AND / XOR

UI label: Delimiter : %1

Inputs

➡️ OPERATOR OR AND XOR
➡️ LIST OF BOOLEAN VALUES

Math

+ - / /i * %

Returns: Number

Performs arithmetic operations [ + , - , / , /i (integer division) , * , % (modulo) ] between numbers.

Inputs

➡️ NUMBER
➡️ OPERATOR + - / /i * %
➡️ NUMBER

COMMERCIAL_ROUND

Returns: Number

Rounds a number using commercial rounding rules, based on a selected rounding direction and price precision.

Formula example

COMMERCIAL_ROUND(n:amount ; [{ 0 , 10 , BOTTOM , TO_9_CENTS , -1 } ; { 10 , 100 , BOTTOM , TO_HALF_EUROS_IN_49_AND_99 , -1 } ; { 100 , 1000 , BOTTOM , TO_9_EUROS , -1 } ; { 1000 , 10000 , UPPER , TO_HALF_EUROS_IN_49_AND_99 , -1 }])

Inputs

➡️ VALUE
➡️ LOWER BOUND VALUE
➡️ UPPER BOUND VALUE
➡️ DIRECTION BOTTOM UPPER NEAREST
➡️ PRECISION TO_10_CENTS TO_9_CENTS TO_HALF_EUROS_IN_49_AND_99 TO_HALF_EUROS_IN_50_AND_00 TO_0_99 TO_THE_EURO TO_9_EUROS TO_10_EUROS TO_49_AND_99_EUROS TO_99_EUROS

( )

Returns: Number

Parenthesis.

Formula example

10 * (1 + 5)

UI label: ( )

Inputs

➡️ NUMBER

POWER

Returns: Number

Raises a number to the power of another number.

Formula example

POWER( 10 ; 3)

UI label: power

Inputs

➡️ BASE
➡️ EXPONANT

RAND

Returns: Number

Generates a random number.

Formula example

RAND(50,150)

Inputs

➡️ MIN_VALUE
➡️ MAX_VALUE

ROUND

Returns: Number

Rounds a number to a specified number of decimal places using a selected rounding mode.

Formula example

ROUND(10.34763;2; DOWN)

Inputs

➡️ VALUE
➡️ DECIMALS
➡️ ROUDING_MODE HALF_DOWN HALF_EVEN HALF_UP DOWN UP CEILING FLOOR

CTEXT

Returns: String

Converts a numeric value into a text representation..

Formula example

CTEXT(10.34563)

Inputs

➡️ NOMBRE

ABS, EVEN, NEG, ODD, SQRT

Returns: Mixed-value

Applies a numeric transformation to a single input value (ABS returns the absolute (positive) value / EVEN return true or false / NEG returns the negated value / ODD return true or false / SQRT returns the square root of the value).

Formula example

ABS(-3)

Inputs

➡️ VALUE

AVG MIN MAX STDEV SUM VARIANCE

Returns: Number

Apply array function MIN / MAX / AVG / SUM / STANDARD DEVIATION / VARIANCE

Formula example

AVG([10;20;30;40])

Inputs

➡️ NUMBERS LIST

Text

STRING_IS

Returns: Boolean

String advanced comparison. Compares two texts using the selected operator. You can specify case and accent sensitive.

Formula example

STRING_IS("AABBCC" ; CONTAINS_ALL_OF ; TRUE() ; FALSE() ; ["aa";"BB"])

Inputs

➡️ STRING COMPARATOR
➡️ OPERATOR IS_EQUAL_TO_ANY_OF IS_NOT_EQUAL_TO_ANY_OF IS_NOT_EQUAL_TO_ALL_OF CONTAINS_ANY_OF CONTAINS_ALL_OF DOESNT_CONTAIN_ANY_OF DOESNT_CONTAIN_ALL_OF STARTS_WITH_ANY_OF ENDS_WITH_ANY_OF
➡️ CASE SENSITIVE TRUE FALSE
➡️ ACCENT SENSITIVE TRUE FALSE
➡️ STRINGS LIST

EXPLODE

Returns: String

Splits a text into a list using a separator, return the element at Position.

Formula example

EXPLODE("Apple,Banana,Pineapple" ; "," ; 1)

Inputs

➡️ STRING
➡️ SEPARATOR
➡️ POSITION

UPPERCASE, LOWER_CASE, CAPITAL_LETTER, CAMEL_CASE

Returns: String

“Applies a text case transformation to the input value.

Formula example

UPPER_CASE("A text string")

Inputs

➡️ STRING

HTML_STRIPTAGS

Returns: String

Removes HTML tags from a text (optionally keeping some tags).

Formula example

HTML_STRIPTAGS("<p>A <b>Bold</B> Text</p>" ; "")

Inputs

➡️ HTML
➡️ EXCEPTION

COUNT_CAR

Returns: Number

Counts the number of characters in a text.

Formula example

COUNT_CAR("A text string")

UI label: Count car

Inputs

➡️ STRING

STR_REPLACE

Returns: String

Replace a string

Formula example

STR_REPLACE("Apple, Banana, Pineapple";"Banana";"Strawberry")

Inputs

➡️ CHAINE
➡️ SEARCH
➡️ REPLACE

STR_EXTRACT

Returns: String

Extracts a portion of text based on a character position and length.

Formula example

STR_EXTRACT("ABCDEF";2;POSITION;2)

Inputs

➡️ STRING
➡️ NUMBER
➡️ START : [ START, END, POSITION], START_INDEX

CNUMBER

Returns: Number

Converts a text value into a number, with optional decimal precision.

Formula example

CNUMBER("22.34435";2)

Inputs

➡️ STRING
➡️ DECIMAL