Customize

Fetch Values from Another App

Summary

Fetch values from another app by using the field value in this app as a key.

How to use

Consider using Kintone’s standard Lookup feature first for similar actions.

This action is useful when you need to accomplish something beyond the standard features of Kintone.

  • You can combine it with “Conditions” to copy a field only in specific situations.
  • When multiple records match the key, this action will copy from the most recent entry.
  • This action permits simultaneous copying for each row in the table.

Parameters

Set Key Field of Source App, Source App, Key Field of Source App, Mapping, and When there are multiple records.

Search for records in the source app where the “Key Value Field of This App” matches the “Key Field of Source App” and copy them to this app based on field mapping.

Key Value Field of This App

Select the key value field from this app.

This parameter accepts the following field types:

  • Text
  • Number
  • Calculated
  • Link
  • Date
  • Time
  • Date and time
  • Lookup (Text)
  • Lookup (Number)
  • Record number

If you select a field inside a table, all rows of that table will be copied. For exceptions: See (*1)

*1: If you set a Condition that only applies to some table rows (such as the Condition “When Fields Value Changed”), the value will be set only for those affected by that Condition.

Source App

Select the source app.

Key Field of Source App

Select the key field from the source app.

This parameter accepts the following field types:

  • Text
  • Number
  • Calculated
  • Link
  • Date
  • Time
  • Date and time
  • Lookup (Text)
  • Lookup (Number)
  • Record number

The field of this app that becomes the key value, and the records matching the values of that field will serve as the source records.

Fields in tables cannot be selected.

Mapping

Establish a mapping from the source app to the fields of the currently customized app.

In the expressions used in this mapping, the fields referenced will be from the source app, not the fields of the app being customized.

When you choose fields from the table to be the “Key Value Field of This App,” the destination field (the field you want to copy to) can only be another field within the same table.

However, if you select a field outside of the table as the “Key Value Field of This App,” you cannot map it to fields within the table.

When there are multiple records

Choose an action to take when multiple records match the “Key Value Field of This App” with the “Key Field of Source App.”

  • Make an Error: Set an error message to the field.
  • Select one with the minimum record number: Among multiple matches, the one with the smallest record number will be selected as the source record.
  • Select one with the maximum record number: Among multiple matches, the one with the largest record number will be selected as the source record.

Compatibility with krewSheet

The action is supported only under the following conditions:

However, there are the following restrictions:

  • The results cannot be assigned to a field that was retrieved through a Lookup.
  • The following field types can be set only at the timing of record saving (e.g. “Before Record Saved Excluding Deleted"): If you want to gain more technical knowledge, refer to the krewSheet documentation .
    • Fields not included in the krewSheet view’s columns
    • Fields set to read-only in krewSheet
    • Rich text field

Restrictions

You can use this action on any of the following screens: If used on other screens, it will result in an error during app execution.

  • New record screen
  • Edit record screen
  • Inline editing mode on PC (after clicking the pencil icon to enter editing mode)

However, in the inline editing mode of the record list screen, it is not possible to copy at the timing of “When Record Edit Page Displayed.” You can use it at the timing of “When Record Edit Page Displayed” in the Edit record screen.