Plugin Mode

Get the Oldest or Newest Record

Summary

Click the button to retrieve records matching specified conditions. Then, from the record with the oldest or newest value in a specific field, set the value of any field.

Smartphone support

This plugin does not support smartphones. Use it on a computer.

How to use

Specify the app and search criteria, then choose the field used to determine the newest or oldest record. Select which value to retrieve from that record and where to store it.

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, edit, or details 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.

Apps Eligible for Acquisition

Please select the app you want to download.

Search Criteria for Retrieved Records

Please enter the search criteria for the records you want to retrieve. *You can specify the sort order, but this plugin will ignore it.

Fields Subject to Evaluation

Please select the field to use for determining whether the app to be retrieved is the most recent or the oldest. If no field is specified, the determination will be based on the record’s update date and time. Additionally, if there are multiple records that qualify as the most recent or the oldest, the determination will be based on their record numbers. This setting is optional.

The following field types cannot be selected.

  • Check box
  • Multi-choice
  • Attachment
  • User selection
  • Department selection
  • Group selection
  • Assignee
  • Table
  • Related records
  • Field group
  • Label
  • Blank space
  • Border

Fields inside tables cannot be selected.

Select from the app specified in “Apps Eligible for Acquisition”.

Choose “Newest” or “Oldest”

Please select “Newest” or “Oldest.”

Available options:

  • Newest
  • Oldest

Retrieval Results Settings Field

Please select the field for which you want to set the retrieval results.

The following field types cannot be selected.

  • Calculated
  • Attachment
  • Record number
  • Record ID
  • Revision
  • Created by
  • Created datetime
  • Updated by
  • Updated datetime
  • Status
  • Assignee
  • Table
  • Related records
  • Field group
  • Label
  • Blank space
  • Border

Button Label

Enter a button label that makes its purpose clear to users.

Initial value: 取得結果をセット

Source Field

Please select the source field.

The following field types cannot be selected.

  • Check box
  • Multi-choice
  • Attachment
  • User selection
  • Department selection
  • Group selection
  • Assignee
  • Table
  • Related records
  • Field group
  • Label
  • Blank space
  • Border

Fields inside tables cannot be selected.

Select from the app specified in “Apps Eligible for Acquisition”.

Restrictions

Operation is not guaranteed in apps where the field codes of the Record number or Updated datetime fields have been changed.

With a comparison field selected, Newest returns the first record in descending order and Oldest the first in ascending order. However, when the field is omitted, the current definition returns the oldest Updated datetime for Newest and the newest for Oldest, reversing the option meanings. Ties are resolved by record number in the same sort direction.

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

Actions

Conditions