◉How to install Plug in
◉Sample Plug in package
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.
**The setting page automatically switches to Chinese, Japanese and English according to the language set by the login user.
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.
Sets whether or not to allow field of computed row to be editable. Check when editing is impossible.
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
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"
●The plug in function can be used only in the standard course.
● 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.
●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.