Plugin Mode

Calculate Period Considering Business Days

Summary

Click the button to calculate the number of business days or holidays between two specified dates, and set the result into a field.

Smartphone support

This plugin supports smartphones.

How to use

Specify the master app containing business days or holidays and its date field. Set the start and end dates and the destination field, then click the button to count the days.

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 creation or edit page
  • When you click a button added by this plugin
  • When you edit and change a target field value

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

The page-display and field-change triggers exclude inline editing from the pencil icon on the list page.

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: 営業日数計算

Start date field

Please select the field containing the start date of the period you want to calculate.

The following field types can be selected.

  • Date
  • Date and time

Fields inside tables cannot be selected.

End date field

Please select the field containing the end date of the period you want to calculate. The end date will also be included in the day count.

The following field types can be selected.

  • Date
  • Date and time

Fields inside tables cannot be selected.

Set destination field

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

The following field types can be selected.

  • Text
  • Number
  • Text area
  • Rich text

Fields inside tables cannot be selected.

Business Days/Holidays Master App

Please select either the Business Day Master app or the Holiday Master app. If you select Business Day Master, it will calculate the number of business days; if you select Holiday Master, it will calculate the number of holidays.

Master app date field

Please select a field that represents a business day in the Business Days Master app, or a field that represents a holiday in the Holidays Master app.

The following field types can be selected.

  • Date

Fields inside tables cannot be selected.

Select from the app specified in “Business Days/Holidays Master App”.

Restrictions

A master app containing business days or a master app containing holidays is required.

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

Actions

Conditions