Plugin Mode

Format date and time

Summary

Convert date or time data to a specified format and set it into a field. You can choose whether this runs when you change a field value, when you save, or both. You can also enable a button on the list screen for bulk conversion.

Smartphone support

This plugin supports smartphones.

How to use

Choose the source date or datetime field and the desired date and time formats. Select a destination field and configure when conversion runs.

When it runs

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

  • When you edit and change a target field value
  • Immediately before saving a record
  • 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.

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.

Conversion execution timing

Please choose whether to perform the conversion during editing or during saving.

Available options:

  • When Editing
  • When Saving

Initial value: When Editing

Batch conversion function

Please choose whether or not to enable the batch conversion function. Enabling the batch conversion function will add a button to the list screen to perform the batch conversion.

Available options:

  • Batch conversion function available
  • Batch conversion function not available

Initial value: Batch conversion function available

Date/DateTime Field

Please select the source field.

The following field types can be selected.

  • Date
  • Date and time

Fields inside tables cannot be selected.

Date Format

Set the format for the converted date.

Available options:

  • 2018-01-25
  • 2018/1/25
  • 2018年1月25日
  • 2018年1月
  • 1月25日
  • 1/25
  • 1/25/2018
  • 25/1/2018
  • 20180125
  • None

Initial value: 1/25/2018

Time Format

Set the format for the converted time.

Available options:

  • 8:05 PM
  • 20:05
  • None

Initial value: 20:05

Set destination field

Please select the field where you want to set the formatted date and time string.

The following field types can be selected.

  • Text
  • Text area
  • Rich text

Notes

During editing or saving, an empty source clears the result fields. Bulk processing applies to records currently displayed on the list page whose source value is filled in. Click the button and confirm to save the results and reload the page.

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

Actions

Conditions