Home / Tips / Boost! Original Functions

REFERENCE

Boost! Original Functions

In Boost! Action, Boost! Upsert, Boost! Mail and Boost! OAuth Mail, you can put the result of a formula into a field. This page introduces how to write formulas and the functions you can use.

See the functions

Boost! Action ＋ Boost! Upsert ＋ Boost! Mail ＋ Boost! OAuth Mail ＋

HOW TO WRITE

How to write formulas

These are the basic rules for writing formulas.

Use field values

To use a field value, enclose the field code in "%". Enclose fixed strings in double quotation marks (").

Sample: Returns the age, as of the day the process runs, from the date in the Date1 field.

AGE(%Date1%)

Join strings

To join strings or function results, connect them with "+".

Sample: Converts the value of the Numeric1 field to a string and returns it joined after "ABC".

"ABC"+TO_STRING(%Numeric1%)

Use fields with multiple values

The values of fields with multiple values, such as check boxes and user selections, are converted to comma-separated strings before being used in calculations.

Converted values: Field type Converted value

Check box, Multi-choice
Selected values

"sample1,sample2"

User selection, Assignee
User names

"Noboru Sato,Misaki Kato"

Department selection
Department names

"Development Department,Human Resources Department"

Group selection
Group names

"Managers,Leaders"

Created by
Name of the creator

"Creator"

Updated by
Name of the updater

"Modifier"

To copy values to a field of the same type, use the FLAT function.

Field type	Converted value
Check box, Multi-choice	Selected values `"sample1,sample2"`
User selection, Assignee	User names `"Noboru Sato,Misaki Kato"`
Department selection	Department names `"Development Department,Human Resources Department"`
Group selection	Group names `"Managers,Leaders"`
Created by	Name of the creator `"Creator"`
Updated by	Name of the updater `"Modifier"`

Put values into fields with multiple values

To put values into fields with multiple values, such as check boxes and user selections, make the result of the calculation a string in the format for each type.

Values to specify: Field type Value

Check box, Multi-choice
A comma-separated string of values

"sample1,sample2"

User selection
A comma-separated string of login names and display names joined with ":"

"sato:Noboru Sato,kato:Misaki Kato"

Department selection
A comma-separated string of department codes and department names joined with ":"

"dev:Development Department,hr:Human Resources Department"

Group selection
A comma-separated string of group codes and group names joined with ":"

"mgr:Managers,ldr:Leaders"

To copy the values of a field of the same type, use the FLAT function.

Field type	Value
Check box, Multi-choice	A comma-separated string of values `"sample1,sample2"`
User selection	A comma-separated string of login names and display names joined with ":" `"sato:Noboru Sato,kato:Misaki Kato"`
Department selection	A comma-separated string of department codes and department names joined with ":" `"dev:Development Department,hr:Human Resources Department"`
Group selection	A comma-separated string of group codes and group names joined with ":" `"mgr:Managers,ldr:Leaders"`

FUNCTIONS

Functions

The functions you can use in formulas and how to write each of them.

IF

Switches the value returned according to the result of a conditional expression.

Syntax: IF(condition,value if true,value if false)
Parameters: Parameter Description

condition
Specify an expression that compares field values, fixed values or function results with a comparison operator.

value if true
Specify the value (fixed value, function result or calculation) returned when the condition is true.

value if false
Specify the value (fixed value, function result or calculation) returned when the condition is false.
Comparison operators: Operator Description

=
True if the left and right values are equal; false if they are not.

!=
True if the left and right values are not equal; false if they are.

<
True if the left value is less than the right value; false if it is greater than or equal to it.

<=
True if the left value is less than or equal to the right value; false if it is greater.

>
True if the left value is greater than the right value; false if it is less than or equal to it.

>=
True if the left value is greater than or equal to the right value; false if it is less.
Sample: Returns "1" if the Numeric1 field is greater than 100, and "0" otherwise.

IF(%Numeric1%>100,1,0)

Parameter	Description
condition	Specify an expression that compares field values, fixed values or function results with a comparison operator.
value if true	Specify the value (fixed value, function result or calculation) returned when the condition is true.
value if false	Specify the value (fixed value, function result or calculation) returned when the condition is false.

Operator	Description
=	True if the left and right values are equal; false if they are not.
!=	True if the left and right values are not equal; false if they are.
<	True if the left value is less than the right value; false if it is greater than or equal to it.
<=	True if the left value is less than or equal to the right value; false if it is greater.
>	True if the left value is greater than the right value; false if it is less than or equal to it.
>=	True if the left value is greater than or equal to the right value; false if it is less.

LIKE

Used in the condition of the IF function to determine whether a string contains the search string.

Syntax: LIKE(target string,search string)
Parameters: Parameter Description

target string
Specify a field code, a fixed value or a function result.

search string
Specify a field code, a fixed value or a function result. Regular expressions can also be specified.
Sample: Returns "1" if the String1 field contains "ABC", and "0" otherwise.

IF(LIKE(%String1%,"ABC"),1,0)

Parameter	Description
target string	Specify a field code, a fixed value or a function result.
search string	Specify a field code, a fixed value or a function result. Regular expressions can also be specified.

AND

Used in the condition of the IF function to determine whether all conditions are met.

Syntax: AND(condition1,condition2,...)
Sample: Returns "1" if the Numeric1 field is greater than 100 and the String1 field is "ABC", and "0" otherwise.

IF(AND(%Numeric1%>100,%String1%="ABC"),1,0)

OR

Used in the condition of the IF function to determine whether any of the conditions is met.

Syntax: OR(condition1,condition2,...)
Sample: Returns "1" if the Numeric1 field is greater than 100 or the String1 field is "ABC", and "0" otherwise.

IF(OR(%Numeric1%>100,%String1%="ABC"),1,0)

TO_NUMBER

Converts a string to a number.

Syntax: TO_NUMBER(%field code% or function result)
Parameters: Parameter Description

field code or function
Specify the value to convert with a field code or a function result.
Sample: Converts the value of the String1 field to a number and returns the result multiplied by 2.

TO_NUMBER(%String1%)*2

If the value cannot be converted to a number, "0" is returned.

Parameter	Description
field code or function	Specify the value to convert with a field code or a function result.

TO_STRING

Converts a number to a string.

Syntax: TO_STRING(%field code% or function result)
Parameters: Parameter Description

field code or function
Specify the value to convert with a field code or a function result.
Sample: Converts the value of the Numeric1 field to a string and returns it joined after "ABC".

"ABC"+TO_STRING(%Numeric1%)

Parameter	Description
field code or function	Specify the value to convert with a field code or a function result.

TODAY

Returns the date of the day the process runs.

Syntax: TODAY()

NOW

Returns the date and time when the process runs.

Syntax: NOW()
Return value: The value returned depends on the type of the field that receives it.

Field type Value returned

Date
The date when the process runs (e.g., 2026-10-18)

Date and time
The date and time when the process runs

Time
The time when the process runs (e.g., 16:06)

Other
The date and time when the process runs (e.g., 2026-10-18T16:06:00)
Sample: Returns the time when the process runs in the "16:06" format.

DATE_FORMAT(NOW(),"H:i")

Field type	Value returned
Date	The date when the process runs (e.g., 2026-10-18)
Date and time	The date and time when the process runs
Time	The time when the process runs (e.g., 16:06)
Other	The date and time when the process runs (e.g., 2026-10-18T16:06:00)

AGE

Returns the age, as of the day the process runs, from the specified date.

Syntax: AGE(%field code% or function result)
Parameters: Parameter Description

field code or function
Specify the date with a field code or a function result.
Sample: Returns the age, as of the day the process runs, from the date in the Date1 field.

AGE(%Date1%)

AVG

Returns the average of a number field in a table.

Syntax

AVG(%field code%,boolean to limit target rows)

Parameters

Parameter	Description
field code	Specify the field code of a number field in a table.
boolean to limit target rows	In Boost! Action, when fields in a table are specified in the conditions for operation, specify "true" to target only the rows that meet the conditions. This can be omitted.

Sample

Returns the average of the Numeric1 field plus 1.

AVG(%Numeric1%)+1

In Boost! Action, when the value of a radio button in a table is specified in the conditions for operation, returns the average of the Numeric1 field in the rows that meet the conditions plus 1.

AVG(%Numeric1%,true)+1

COMMA

Returns a string of a number with commas every three digits.

Syntax: COMMA(%field code% or function result,decimal places)
Parameters: Parameter Description

field code or function
Specify the number with a field code or a function result.

decimal places
Specify the number of decimal places to show. To show no decimal places, specify "0".
Sample: Returns the value of the Numeric1 field as a comma-separated string.

COMMA(%Numeric1%,0)

Digits below the specified number of decimal places are truncated.

Parameter	Description
field code or function	Specify the number with a field code or a function result.
decimal places	Specify the number of decimal places to show. To show no decimal places, specify "0".

DATE_CALC

Returns the result of adding years, months, days and so on to a date, or subtracting them from it.

Syntax

DATE_CALC(%field code% or function result,"calculation pattern (value unit)")

Parameters

Parameter	Description
field code or function	Specify a date, date and time, or time with a field code or a function result.
calculation pattern (value)	Specify the number to add to the base date. To subtract, specify a negative number. A field code can also be specified instead of a number.
calculation pattern (unit)	After the value, insert a half-width space and specify one of the units below.

Units

Unit	Description
year	Year
month	Month
day	Day
hour	Hour
minute	Minute
second	Second
first-of-year	Start of the year (January 1)
first-of-month	Start of the month (the 1st)
first-of-week	Start of the week (Sunday)

No value is needed for first-of-year, first-of-month and first-of-week.

To calculate with multiple patterns, separate the patterns with commas.

Sample

Returns the date two months before the date in the Date1 field.

DATE_CALC(%Date1%,"-2 month")

Returns the last day of the month to which the date in the Date1 field belongs.

DATE_CALC(%Date1%,"first-of-month,1 month,-1 day")

Returns the date in the Date1 field plus the number of days in the Numeric1 field.

DATE_CALC(%Date1%,"%Numeric1% day")

Returns the date 10 days after the start of the week to which the date in the Date1 field belongs.

DATE_CALC(%Date1%,"first-of-week,10 day")

DATE_DIFF

Returns the period between two dates as a string in the specified display format.

Syntax

DATE_DIFF(%start date field%,%end date field% or "TODAY","display format")

Parameters

Parameter	Description
start date field	Specify the first date of the period with a field code or a function result.
end date field	Specify the last date of the period with a field code or a function result. To get the period up to the day the process runs, specify "TODAY" (in double quotation marks).
display format	Specify a combination of the symbols below.

Display format

Symbol	Description
Y	Elapsed years
M	Remaining months, excluding elapsed years
FM	Total months in the period
D	Remaining days, excluding elapsed months
FD	Total days in the period

Sample

Returns the period from the Date1 field to the Date2 field in the "N years N months" format.

DATE_DIFF(%Date1%,%Date2%,"Y years M months")

Returns the period from the Date1 field to the day the process runs in the "N years N months N days" format.

DATE_DIFF(%Date1%,"TODAY","Y years M months D days")

DATE_FORMAT

Returns a date as a string in the specified display format.

Syntax

DATE_FORMAT(%field code% or function result,"display format")

Parameters

Parameter	Description
field code or function	Specify the date with a field code or a function result.
display format	Specify a combination of the symbols below.

Display format

Symbol	Description
Y	Year (4 digits)
y	Year (2 digits)
m	Month (2 digits)
d	Day (2 digits)
H	Hour (24-hour, 2 digits)
h	Hour (12-hour)
i	Minutes (2 digits)
s	Seconds (2 digits)
w	Day of the week

Sample

Returns the date in the Date1 field in the "2026-10-18" format.

DATE_FORMAT(%Date1%,"Y-m-d")

Returns the time when the process runs in the "16:06" format.

DATE_FORMAT(NOW(),"H:i")

FLAT

Returns the values of user selection, department selection, group selection, assignee, created by and updated by fields as a comma-separated string of "code:name".

Syntax: FLAT(%field code%)
Parameters: Parameter Description

field code
Specify the field code of the field to convert.
Sample: Returns the logged-in user if the User1 field is empty, and the value of the User1 field otherwise.

IF(%User1%="",LOGINUSER(),FLAT(%User1%))

Parameter	Description
field code	Specify the field code of the field to convert.

LOGINUSER

Returns the logged-in user in the "login name:display name" format.

Syntax: LOGINUSER()

LOGINUSER_CODE

Returns the login name of the logged-in user.

Syntax: LOGINUSER_CODE()

LOGINUSER_NAME

Returns the display name of the logged-in user.

Syntax: LOGINUSER_NAME()

LPAD

Returns a string padded on the left with the specified character until it reaches the specified length.

Syntax: LPAD(%field code% or function result,length,"padding character")
Parameters: Parameter Description

field code or function
Specify the original value with a field code or a function result.

length
Specify the number of characters of the result.

padding character
Specify the character used for padding.
Sample: Returns the value of the Numeric1 field padded on the left with "0" to 10 digits.

LPAD(%Numeric1%,10,"0")

Parameter	Description
field code or function	Specify the original value with a field code or a function result.
length	Specify the number of characters of the result.
padding character	Specify the character used for padding.

RPAD

Returns a string padded on the right with the specified character until it reaches the specified length.

Syntax: RPAD(%field code% or function result,length,"padding character")
Parameters: Parameter Description

field code or function
Specify the original value with a field code or a function result.

length
Specify the number of characters of the result.

padding character
Specify the character used for padding.
Sample: Returns the value of the Numeric1 field padded on the right with "0" to 10 digits.

RPAD(%Numeric1%,10,"0")

Parameter	Description
field code or function	Specify the original value with a field code or a function result.
length	Specify the number of characters of the result.
padding character	Specify the character used for padding.

LEFT

Extracts the specified number of characters from the left of a string.

Syntax: LEFT(%field code% or function result,number of characters)
Parameters: Parameter Description

field code or function
Specify the original value with a field code or a function result.

number of characters
Specify the number of characters to extract.
Sample: Returns the first five characters from the left of the value of the String1 field.

LEFT(%String1%,5)

Parameter	Description
field code or function	Specify the original value with a field code or a function result.
number of characters	Specify the number of characters to extract.

RIGHT

Extracts the specified number of characters from the right of a string.

Syntax: RIGHT(%field code% or function result,number of characters)
Parameters: Parameter Description

field code or function
Specify the original value with a field code or a function result.

number of characters
Specify the number of characters to extract.
Sample: Returns the last five characters from the right of the value of the String1 field.

RIGHT(%String1%,5)

Parameter	Description
field code or function	Specify the original value with a field code or a function result.
number of characters	Specify the number of characters to extract.

MID

Extracts the specified number of characters from the specified position of a string.

Syntax: MID(%field code% or function result,start position,number of characters)
Parameters: Parameter Description

field code or function
Specify the original value with a field code or a function result.

start position
Specify the position at which extraction starts. The first character is "1".

number of characters
Specify the number of characters to extract.
Sample: Returns five characters from the third character of the value of the String1 field.

MID(%String1%,3,5)

Parameter	Description
field code or function	Specify the original value with a field code or a function result.
start position	Specify the position at which extraction starts. The first character is "1".
number of characters	Specify the number of characters to extract.

REPLACE

Replaces all occurrences of the search string in a string with the replacement string.

Syntax: REPLACE(%field code% or function result,"search string","replacement string")
Parameters: Parameter Description

field code or function
Specify the original value with a field code or a function result.

search string
Specify the string to replace. Regular expressions can also be specified.

replacement string
Specify the string after replacement.
Sample: Returns the value of the String1 field with "Inc." replaced by "LLC".

REPLACE(%String1%,"Inc.","LLC")

Parameter	Description
field code or function	Specify the original value with a field code or a function result.
search string	Specify the string to replace. Regular expressions can also be specified.
replacement string	Specify the string after replacement.

LEN

Returns the number of characters in a string.

Syntax: LEN(%field code% or function result)
Parameters: Parameter Description

field code or function
Specify the value to count with a field code or a function result.
Sample: Returns the number of characters in the value of the String1 field.

LEN(%String1%)

Parameter	Description
field code or function	Specify the value to count with a field code or a function result.

LENB

Returns the number of bytes in a string.

Syntax: LENB(%field code% or function result)
Parameters: Parameter Description

field code or function
Specify the value to count with a field code or a function result.
Sample: Returns the number of bytes in the value of the String1 field.

LENB(%String1%)

Bytes are counted in UTF-8. Full-width characters are usually 3 bytes each.

Parameter	Description
field code or function	Specify the value to count with a field code or a function result.

LINES

Returns the string of the specified line from a multi-line string.

Syntax: LINES(%field code% or function result,line number)
Parameters: Parameter Description

field code or function
Specify the original value with a field code or a function result.

line number
Specify the line to extract. The first line is "1".
Sample: Returns the third line of the value of the MultiLine1 field.

LINES(%MultiLine1%,3)

Parameter	Description
field code or function	Specify the original value with a field code or a function result.
line number	Specify the line to extract. The first line is "1".

LOOP

Creates the result of a formula for each row of a table and returns them joined with line breaks.

Syntax

LOOP(%field code%,/*formula*/,boolean to limit target rows)

Parameters

Parameter	Description
field code	Specify the field code of the table.
formula	Specify the formula that creates the value for each row, enclosed in "/" and "/". Insert "\\n" where you want a line break.
boolean to limit target rows	In Boost! Action, when fields in a table are specified in the conditions for operation, specify "true" to target only the rows that meet the conditions. This can be omitted.

Sample

Returns a string that joins the values of the String1 field and the Numeric1 field in each row of Table1.

LOOP(%Table1%,/*"Item: "+%String1%+"\\nQuantity: "+TO_STRING(%Numeric1%)+"\\n"*/)

The result is as follows.

Item: Orange
Quantity: 10

Item: Apple
Quantity: 15

Item: Kiwi
Quantity: 5

In Boost! Action, when the value of a radio button in a table is specified in the conditions for operation, returns the joined strings of only the rows that meet the conditions.

LOOP(%Table1%,/*"String: "+%String1%+"\\nNumber: "+TO_STRING(%Numeric1%)+"\\n"*/,true)

If the receiving field is a rich text field, join with "<br>" instead of line breaks.

MATH

Returns the result of a calculation.

Syntax

MATH(calculation)

Parameters

Parameter	Description
formula	Specify the calculation. To use field values, enclose the field codes in "%".

Operators

Operator	Description
+	Addition
-	Subtraction
*	Multiplication
/	Division
**	Exponentiation

Sample

Returns the value of the Numeric1 field plus 2.

MATH(%Numeric1%+2)

Returns the value of the Numeric1 field divided by the value of the Numeric2 field.

MATH(%Numeric1%/%Numeric2%)

MAX

Returns the maximum value of a field in a table.

Syntax

MAX(%field code%,boolean to limit target rows)

Parameters

Parameter	Description
field code	Specify the field code of a number, date, date and time, or time field in a table.
boolean to limit target rows	In Boost! Action, when fields in a table are specified in the conditions for operation, specify "true" to target only the rows that meet the conditions. This can be omitted.

Sample

Returns the maximum value of the Numeric1 field plus 1.

MAX(%Numeric1%)+1

In Boost! Action, when the value of a radio button in a table is specified in the conditions for operation, returns the maximum value of the Numeric1 field in the rows that meet the conditions plus 1.

MAX(%Numeric1%,true)+1

MIN

Returns the minimum value of a field in a table.

Syntax

MIN(%field code%,boolean to limit target rows)

Parameters

Parameter	Description
field code	Specify the field code of a number, date, date and time, or time field in a table.
boolean to limit target rows	In Boost! Action, when fields in a table are specified in the conditions for operation, specify "true" to target only the rows that meet the conditions. This can be omitted.

Sample

Returns the minimum value of the Numeric1 field minus 1.

MIN(%Numeric1%)-1

In Boost! Action, when the value of a radio button in a table is specified in the conditions for operation, returns the minimum value of the Numeric1 field in the rows that meet the conditions minus 1.

MIN(%Numeric1%,true)-1

PREVROW

Returns the value of a field in a table in the previous row.

Syntax

PREVROW(%field code%,boolean to limit target rows)

Parameters

Parameter	Description
field code	Specify the field code of a field in a table.
boolean to limit target rows	In Boost! Action, when fields in a table are specified in the conditions for operation, specify "true" to target only the rows that meet the conditions. This can be omitted.

Sample

Returns the value of the Numeric1 field in the previous row plus 1.

PREVROW(%Numeric1%)+1

In Boost! Action, when the value of a radio button in a table is specified in the conditions for operation, returns the value of the Numeric1 field in the previous row among the rows that meet the conditions plus 1.

PREVROW(%Numeric1%,true)+1

ROWS

Returns the number of rows in a table.

Syntax

ROWS(%field code%,boolean to limit target rows)

Parameters

Parameter	Description
field code	Specify the field code of the table.
boolean to limit target rows	In Boost! Action, when fields in a table are specified in the conditions for operation, specify "true" to target only the rows that meet the conditions. This can be omitted.

Sample

Returns the number of rows in a table.

ROWS(%Table%)

In Boost! Action, when the value of a radio button in a table is specified in the conditions for operation, returns the number of rows that meet the conditions.

ROWS(%Table%,true)

SUM

Returns the total of a number field in a table.

Syntax

SUM(%field code%,boolean to limit target rows)

Parameters

Parameter	Description
field code	Specify the field code of a number field in a table.
boolean to limit target rows	In Boost! Action, when fields in a table are specified in the conditions for operation, specify "true" to target only the rows that meet the conditions. This can be omitted.

Sample

Returns the total of the Numeric1 field plus 1.

SUM(%Numeric1%)+1

In Boost! Action, when the value of a radio button in a table is specified in the conditions for operation, returns the total of the Numeric1 field in the rows that meet the conditions plus 1.

SUM(%Numeric1%,true)+1

TIME_DIFF

Returns the elapsed time between two times as a string in the specified display format.

Syntax

TIME_DIFF(%start time field%,%end time field%,"display format")

Parameters

Parameter	Description
start time field	Specify the start time with the field code of a date and time field or time field, or with a function result.
end time field	Specify the end time with the field code of a date and time field or time field, or with a function result.
display format	Specify a combination of the symbols below.

Display format

Symbol	Description
H	The hours part of the elapsed time
FH	Total hours of the elapsed time
I	The minutes part of the elapsed time
FI	Total minutes of the elapsed time

Sample

Returns the elapsed time from the DateTime1 field to the DateTime2 field in the "N hours N minutes" format.

TIME_DIFF(%DateTime1%,%DateTime2%,"H hours I minutes")

Returns the elapsed time from the Time1 field to the Time2 field in hours.

TIME_DIFF(%Time1%,%Time2%,"FH")

Specify values of the same field type for the start time and the end time.

WEEK_CALC

Returns the day of the week of a date as a number. Sunday is "0" and Saturday is "6".

Syntax: WEEK_CALC(%field code% or function result)
Parameters: Parameter Description

field code or function
Specify the date with a field code or a function result.
Sample: Returns the number of the day of the week of the date in the Date1 field.

WEEK_CALC(%Date1%)