By setting a formula in an app, you can calculate the sum of multiple values or have a value automatically displayed according to conditions specified in a function.
This page describes the basics of using and setting up formulas.

It is necessary to understand the following three points when using formulas.

Formulas can be used only with Calculated and Text fields.
Use a Calculated field if you want the calculation result to be treated as a numeric value, or use a Text field if you want the result to be treated as a string value.

A field code is a string used for identifying a field. In formulas, field codes are used to refer to other fields.
For details, refer to the following pages.
Overview of field codes
Fields that can/cannot be referenced in formulas

Clicking Insert field code displays a list of the field codes that exist in the app you are using.
Select a field code from the list to have it entered in the Formula input field.

Formulas in kintone support half-width operators (e.g., "+", "-", "*", "/"), as well as functions.
You can use multiple operators and functions together in a single formula.
List of operators and functions

Clicking Insert function displays a list of the functions you can use in kintone.
Select a function from the list to have it entered in the Formula input field.

As an example, this section walks you through setting up a formula that multiplies a unit price and quantity to produce a subtotal.
You will use Number fields for entering numeric values, and a Calculated field for displaying the calculation result.

1. Click the App settings icon (the gear-shaped icon) at the upper right of the View screen.
   

2. On the App settings screen, click the Form tab.

3. Place two Number fields on the app form by dragging the Number field displayed in the list of fields on the left side of the screen and then dropping it onto the area on the right side of the screen.

4. Open the settings screen of the Number field that will be used for entering a unit price. To do so, click the Settings icon (the gear-shaped icon) at the upper right of the Number field, then click Settings.

5. Enter "Unit price" in the Name input field.

6. Enter "Unit_price" in the Field code input field.

7. Click Save.

8. Open the settings screen of the Number field that will be used for entering a quantity. To do so, click the Settings icon (the gear-shaped icon) at the upper right of the Number field, then click Settings.

9. Enter "Quantity" in the Name input field.

10. Enter "Quantity" in the Field code input field.

11. Click Save.

12. Place a "Calculated" field on the app form.

13. Open the settings screen of the Calculated field. From the Settings icon (the gear-shaped icon) at the upper right of the Calculated field, click Settings.

14. Enter "Subtotal" in the Name input field.

15. Enter the following formula in the Formula input field.

    Copy

    The content has been copied.

    Unit_price*Quantity

    

16. Click Save.

17. Click Save form on the upper left side of the screen.

18. If you are creating a new app, click Activate app and click OK on the confirmation dialog.
    If you are changing the settings of an existing app, click Update app and select Update app on the confirmation dialog.

When you enter a unit price and quantity on the screen for adding or editing a record, the calculation result will appear in the "Subtotal" field.

If an error message appears when setting a formula or entering data on a record, refer to the following pages for solutions.

• Formula errors
• FAQ/troubleshooting related to calculation