Round down the time to the nearest minute. You can reference the result from other actions.
To set the result of the calculation to another field, enter the target field into the parameter “Target Field (Optional)”.
Use formulas when using the results for other actions without setting the results to another field immediately.
When you execute an action to run “Round Down Time”, the result of the calculation is stored internally. You can get the saved results by using a formula, for example “=$1”.
If the value of the “Time” parameter is in a format that does not include a date, the calculation result will be in a format 09:30. Seconds are not included. It is formatted so that it can be set directly in the Time field of Kintone. However, the saved date does not contain any date data, so it cannot be set to a Date and time field.
If the value of the “Time” parameter is in a format that includes a date, it will be calculated including the date, and the result will also be in a format that includes the date. The format of the result will be based on Coordinated Universal Time, such as 2019-09-06T03:16:00.000Z. This format can be set directly to the date and time field of Kintone.
Example: Use the calculated time results in another action, “Add New Record.”
Set Time, Round Down Minute, and Target Field (Optional).
Enter the reference time.
Both formats, including only the time, such as 09:30, and format including both date and time, such as 2019-09-12 09:30, can be specified.
To access the value of a Time field or a Date and time field, use the field code:
Example: =Time_2
insert an equals sign “=” before the field code, as in the example.
To specify the current time, enter
=now()
This will set the current time as the value of this parameter.
Specify the truncation unit in minutes.
You need to set a “round” number that can evenly divide 24 hours (or 1,440 minutes). For example, 10, 15, 30 … etc. can be specified.
Values exceeding one hour, such as 60 or 120, can also be specified.
Negative values cannot be specified.
You cannot specify it in the formula.
Use this parameter to set the results to another field. You can leave this parameter empty to use the calculation result in another action without setting it to any field.
If you select a field inside a table, all rows of that table will be processed. For exceptions: See (*1)
*1: Only the affected rows will be processed if you set a condition that applies only to some table rows (such as “When Fields Value Changed”).
This parameter accepts the following field types:
This action is designed to work seamlessly with krewSheet.
However, the following restrictions apply to the parameter “Target Field (Optional):”
Even if the “Time” parameter contains seconds in a format that does not include a date, the calculation result will not include seconds.