Customize

Update Record Providing the Key With Field

Summary

Update the data in an existing record of the specified app. Specify the key value for searching the records to be updated in the fields of the app being customized.

How to use

The records of the “Target App” where the “Key Field on Target App” matches the “Key Value Field on This App” will be updated based on the “mapping”.

It is almost the same as “Update Record Providing the Key Value” but differs because the key value is specified using the field. In particular, use this to perform actions on each table row.

Parameters

Set Target App, Key Field on Target App, Key Value Field on This App, Mapping, and Check Conflict.

Target App

Select the app to update the records.

Key Field on Target App

Choose the field to be used as the key to update the records.

Fields in tables cannot be selected.

This parameter accepts the following field types:

  • Text
  • Number
  • Calculated field
  • Radio button
  • Drop-down
  • Link
  • Date
  • Time
  • Date and time
  • Lookup (Text)
  • Lookup (Number)
  • Record number

Key Value Field on This App

Select a field with a value to compare with the “Key Field on Target App” from the app’s fields to be customized. Fields in tables can be selected.

When selecting fields in the table, the update process will be executed sequentially for all rows that match the “condition.”

This parameter accepts the following field types:

  • Text
  • Number
  • Calculated field
  • Radio button
  • Drop-down
  • Link
  • Date
  • Time
  • Date and time
  • Lookup (Text)
  • Lookup (Number)
  • Record number

Mapping

Enter the information to be registered in the records.

For each field, write in the format “Field code = value.”

For detailed descriptions of this parameter, please refer to How to Define Field Mappings.

You can use @out in this mapping. It refers to the records that match the key.

Check Conflict

Select from “Check” or “Do NOT check”.

Selecting “Check” checks whether the updated record conflicts with updates from other users. If there is a conflict, it will result in an error at runtime. Selecting “Do NOT check” does not perform this check.

Selecting “Check” is recommended if you don’t have enough knowledge.

Webhook Notifications

This Do does not trigger webhook notifications in the target app.