Data Types of Values Referenced in Formulas

Article Number:040500

In kintone, data types vary depending on the types of fields and calculation results. Operators and functions you can use for each data type are also different.
Understanding the data types enables you to make use of fields, operators, and functions in various formulas.

Data Types of Fields

When fields are referenced in a formula, their values are treated as the following data types.

Field Data type
Number Numeric type
Calculated
Date and time
Date
Time
Created datetime
Updated datetime
Lookup (If the lookup source is numeric type)
Text String type
Drop-down
Radio button
Lookup (If the lookup source is string type)
Created by
Updated by
Check box String array type
Multi-choice
A string type field in a table when it is referenced by a field placed outside the table
A numeric type field in a table when it is referenced by a field placed outside the table Numeric array type

Data Types of Calculation Results

The following table shows the data types of values returned by functions and operators in formulas.

Function Data type
SUM Example: SUM(1, 2, 3)
The data type of arguments is either numeric or numeric array, and the data type of the calculation result is numeric.
ROUND Example: ROUND(A*1.1)
The data type of the argument and the calculation result is numeric.
ROUNDUP Example: ROUNDUP(A*1.1)
The data type of the argument and the calculation result is numeric.
ROUNDDOWN Example: ROUNDDOWN(A* 1.1)
The data type of the argument and the calculation result is numeric.
IF Example: IF(A=100,B,C)
The first argument is boolean type. The second and third arguments are any of numeric, string, or boolean type.
The data type of the value returned from the function is the same as that of the calculation result of either the second or third argument.
AND Example: IF(AND(A>10,B>=10),"1","0")
The data type of the arguments and the calculation result is boolean.
OR Example: IF(OR(A>10,B>=10),"1","0")
The data type of the arguments and the calculation result is boolean.
NOT Example: IF(NOT(A>10),"1","0")
The data type of the arguments and the calculation result is boolean.
DATE_FORMAT Example: DATE_FORMAT(1522972800, "YYYY-M-d", "system")
The first argument is numeric type (UNIX time), the second argument is string type (display format), and the third argument is string type (timezone). The data type of the calculation result is string.
YEN Example: YEN(1100.5, 0)
The data type of the arguments is numeric, and the data type of the calculation result is string.
CONTAINS Example: IF(CONTAINS(Workday, "Sunday"), "Working on Sunday", "Not Working on Sunday")
The first argument is string array type, and the second argument is string type. The data type of the calculation result is boolean.
Operator Data type
+, -, *, /, ^ The data type of arguments and the calculation result is numeric.
& The data type of arguments is any of numeric, string, or boolean. The data type of the calculation result is string.
=, !=, <> The data type of arguments is any of numeric, string, or boolean. The data type of the calculation result is boolean.
<, <=, >, >= The data type of arguments is numeric. The data type of the calculation result is boolean.

For details on operators, functions, and their usage, refer to the following pages.