Job Runner

Round Up Field Value

Overview

Round up the value in the specified fields.

Usage

If you perform this Do, the field value is changed from its original value, and records are reserved for saving. Updated records are not saved immediately but automatically after all actions in the job are finished. Use Save Modified Record to save the updated records at a different time.

You will need an API Token with the edit record permission for the app when autosaving. Make sure to Set Kintone API Token in another action and set the API Token for the Kintone app.

Parameters to set

Set Record, Field, and Zero Padding Digits.

Record

Select the Action you used to retrieve the target records.

If multiple records are included, it is processed for each record. If there are no records, nothing is done.

Field

Select the field to round up. Only numeric fields can be selected.

You cannot include fields that are within a table.

If the field’s value is negative, it will be rounded upwards as a number. Note that this behaviour is different from the function roundup. For example:

  • Rounding up a field by -1.23 results in -1
  • The result of roundup(-1.23, 0) is -2

Zero Padding Digit

Enter the number of digits to round up. If you enter a negative number, it will be decimal.

# Specify -2.
111.111 -> 111.12

# Specify 2
110 -> 200