Job Runner

Convert from the Gregorian Calendar to the Japanese Emperor Reign

Overview

Convert a string or date to the Japanese Emperor Regnal year and input it into the specified field.

Usage

If you want to set the converted Era and Japanese Calendar Years in the field, create that field in the App and choose that field under Where to Put Era and Where to Put Japanese Calendar Years.

If you want to put the converted era name and Japanese calendar year as one String such as ‘2018’ instead of registering them separately in individual fields, you can do the following.

  1. “Where to Put Era” and “Where to Put Japanese Calendar Years” are left out without setting them.
  2. Add a new Action that runs the Do “Set field Value”, and input the formula below into the “Value” parameter.
= $1.era & $1.year & "year"
  • The digit in the “$1” string must match the Action Number of the Action which runs “Calculate Age”. For example, if the Action Number is “3”, change the string to “$3”.
  • $1.era represents the era part such as “Heisei” and $1.year represents the years part.

If either Where to Put Era or Where to Put Japanese Calendar Years is specified, the record will be reserved for storage if the field value is changed from its original value by performing this To Do action. Modified records are not saved immediately, but are saved automatically after all actions in the job are finished. Use Save Modified Record if you want to save the Modified record at a different time.

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

Parameters

Set the record, Date of Conversion, Where to Put Era, and Where to Put Japanese Calendar Years.

Record

Select the Action you used to import the target records.

If a multi-line record is included, it is processed for each record. If there are no records, nothing is done.

If more than one record is included, only the results of the action for the last row remain.

Date of Conversion

Select the field with the Date recorded in the year.

You can choose from the following field types:

  • Text
  • Date
  • Date and time
  • Created datetime
  • Updated datetime

This parameter does not accept fields that are inside tables.

If you choose a Text field, the value must be set in the correct Date format.

Where to Put Era

Select the field where you want to set the era name. This parameter is optional.

You can only select a Text.

This parameter does not accept fields that are inside tables.

If you leave this parameter empty, the calculated age will not be exported. However, other Actions will still be able to access the calculated age value.

Where to Put Japanese Calendar Years

Select the field where you want to set the Japanese calendar year. This parameter is optional.

You can select a Text or a Number field.

This parameter does not accept fields that are inside tables.

The first year of the era name will be “1” instead of “1st year”.

If you leave this parameter empty, the calculated age will not be exported. However, other Actions will still be able to access the calculated age value.

Restrictions

  • The range of era names supported is from Meiji to Reiwa. It was not supported before Keio.