Plugin Mode

Get Maximum or Minimum from Specified Records

Summary

Click the button to retrieve records matching specified conditions, find the “maximum” or “minimum” of a specific field, and set it into a 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 and calculation method. Set the destination field and button label. Click the button in the destination field on a record creation, edit, or details page. On a details page, the page reloads after the result is written.

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 from which you want to retrieve the value.

Search Criteria for Retrieved Records

Set the search criteria for records from which to retrieve the value.

Fields to Retrieve

Please select the field from the target app for which you want to retrieve a value.

The following field types can be selected.

  • Number
  • Calculated
  • Date
  • Time
  • Date and time
  • Record number
  • Created datetime
  • Updated datetime

Fields inside tables cannot be selected.

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

Choosing the Maximum or Minimum

Please select either “maximum” or “minimum”

Available options:

  • maximum
  • minimum

Aggregation Results Settings Field

Please select the field where you want to store the retrieved value.

The following field types can be selected.

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

Fields inside tables cannot be selected.

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

Button label

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

Initial value: 取得結果をセット

Notes

The maximum or minimum is calculated only when at least one record matches the search criteria. If no records match, the destination field remains unchanged.

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

Actions

Conditions