Customize

Update Lookup Fields of Another App

Summary

Update the value in the lookup fields of another app.

Records with the specified value in the Lookup field will be updated. Records targeted to updates will be re-retrieved with the same value in the Lookup field. If a copy of the field is set in the Lookup field, the value in the field will be re-copied with the current value.

It is acceptable for multiple records to be updated.

This action is similar to “Update Lookup Fields,” but while “Update Lookup Fields” selects the target Lookup field from the currently customized app, “Update Lookup Fields of Another App” allows you to select the Lookup fields from other apps.

How to use

A common example of this action is when a customized app serves as a master app, such as a Product Database. When its content is edited, all other apps that reference the master app must also be updated.

For example:

  • The customization focuses on the Product Database.
  • The “Product Code” field in the Quote app retrieves information from the Product Database, including the product’s price and other details.

In such cases, it is necessary to “Update Lookup Fields of Another App.”

  • App: Quote App
  • Lookup Field: Product Code
  • Lookup Value: “= Product Code” (This formula sets the value of the Product Code field in the Product Database.)

This will update all records in the Quote app that reference the current Product Database accordingly.

All target records will be updated; therefore, you cannot use “Update Lookup Fields of Another App” to filter the update target, such as only updating “unissued quotes.”

Parameters

Set App, Lookup Field, and Lookup Value.

App

Select the app with the Lookup field to update.

Lookup Field

Select the Lookup field to update. Only the Lookup field can be selected.

You cannot select fields that are inside tables.

Lookup Value

Specify the value to determine which records should be updated. Records within the specified app that contain this value in the Lookup field can be updated.

Compatibility with krewSheet

This action does not support krewSheet.

Precautions

  • Please note that if a user configured in the Kintone connection settings does not have the necessary access rights for the Datasource app of the Lookup field, they will be unable to select it.

Restrictions

The field that the Lookup field refers to must have “Prevent duplicate values” turned on in the Kintone field settings.

You cannot update the Lookup field in the table.