Plugin Mode

Batch Processing for Adding and Subtracting Dates

Summary

Click the button on the list screen to add or subtract a number of days or months to a specified date field’s value in bulk, for the records shown in the list, and save the result into another field.

Smartphone support

This plugin supports smartphones.

How to use

Choose the source date field, calculation unit, amount, destination field, and button label. Use a negative amount to subtract. Click the button on a list page and confirm with OK to calculate dates for the records currently displayed. The results are saved and the list reloads.

When it runs

Depending on the settings, this customization runs at the following times. Any configured conditions are also evaluated.

  • When you open a record list page
  • When you click a button added by this plugin

Click the button added by this customization to run the operation.

Parameters

Enter or select a value for each setting unless it is marked optional.

Button Label

Please enter the label to be placed on the button.

Initial value: 日付の加減算

Date Field

Please select the date field to be included in the calculation.

The following field types can be selected.

  • Date
  • Date and time

Fields inside tables cannot be selected.

Calculated

Choose the unit for the amount to add, such as days or months.

Available options:

  • X Days After
  • X Weeks After
  • X Months After
  • First of Month After X Months
  • End of Month After X Months
  • X Years After

Addition value

Please enter the number to add. If you want to subtract, please enter a negative value.

Initial value: 1

Set destination field

Please select the field where you want to set the calculation result.

The following field types can be selected.

  • Text
  • Text area
  • Rich text
  • Date
  • Date and time

The following actions and conditions are useful when building similar behavior in customization mode.

Actions

Conditions