Calculation formula plug in

Outline

◉Overview

◉How to install Plug in

◉Sample Plug in package

◉Notes

Overview

This is the extension plug in for automatic calculation of kintone.

By installing this plug in, it is possible to perform various calculations that are not included in standard functions.

Settings screen(Example)

**The setting page automatically switches to Chinese, Japanese and English according to the language set by the login user.

Editing screen(Example)

When using the round function, the number of digits to be rounded will be determined according to the value of the trigger item (On this screen, it is "Exchange rate").

How to install Plug in

STEP1 : Add the plug in to the app

Add plug in from app management page. (For more details, you can follow here.)

STEP2 : Set up the Plug in

① On the app management page, click "Plug in".

 

② Click the gear icon of the plug in.

 

③ Set items.

●To be Calculated  

The calculation result is displayed in this field.

●Editability

Sets whether or not to allow field of computed row to be editable. Check when editing is impossible.

●Formula

 Enter the formula. You can enter formulas and functions that the eval function can handle. If the field code is included in the formula, use ## field code ##. For example, to calculate the A field + B field, if the result is rounded to hold 2 bits and displayed in the C field, Select field C in "To be Calculated" dropdown box and enter it in "Formula". Math.round (## A field code ## + ## B field code ## * 100) / 100

●Trigger

Specify when the value of the field changes when the calculation is executed.

Shift + mouse click : Range selection

Ctrl + mouse click : Multiple selection

④ Click [Save].

 

⑤ To set the plug in, click [Update App] on the [Settings] page.

STEP3 : Using the Plug in

Add a new record and check the fields on the edit page and list page.

Also check whether the trigger fields work. If the calculation is incorrect, please check that the formula you entered is correct.

* Since the data in the table can not be edited on the record list page, processing is not performed even if you set an item in the table as uneditable or set as an trigger item.

Sample plug in package

Please open this page(cybozu developer network china).

And then you can download the package of plug in from "Calc.Plugin.zip"

Notes

●The plug in function can be used only in the standard course.

●in the case of app already customized by JavaScript, processing may conflict and an error may occur.In that case, please stop using the plug in with the corresponding app.

● Smartphones are not supported

● The setting page automatically switches to Chinese, Japanese and English depending on the language set by the login user.

●This sample program does not guarantee that operation is absolutely correct.

●Technical support for this sample program is not provided. 

●JavaScript functions can be used for calculation formulas.

●This plug in, you can use the eval function to handle risky formulas. For example, you can enter some code that can call an external service API or loop code that calls the kintone API or other potentially dangerous code that could cause serious events such as paralysis or information disclosure.

Please note that on the premise that there is the above risk. Cybozu doesn't take any responsibility or liability for any damage or loss caused through this service.

Cybozu, Inc.

Tokyo Nihombashi Tower 27F 2-7-1 Nihombashi, Chuo-ku, Tokyo, Japan 103-6028

Instagram!

New Articles!