Update the records that match the specified key. The key value for searching the records to be updated is specified by the fields of the specified record.
First, obtain the record that has the key value and serves as the basis for the mapping in some way. For example, you can use “Retrieve Records by Providing Conditions in Query.” This record is specified as the “Source Record.”
The records of the “Target App” where the “Key Value Field on Source Record” matches the “Key Field on Target App” will be updated based on the “mapping”.
If you want to use the record you are currently editing as a record with a key value, please use “Update Record Providing the Key With Field” or “Update Record Providing the Key Value” instead of this “Update Record Providing the Another Record Field.”
Set Target App, Key Field on Target App, Source Record, Key Value Field on Source Record, and Mapping.
Select the app to update the record.
Choose the field to be used as the key to update the records from the target app.
This parameter does not accept fields that are inside tables.
This parameter accepts the following field types:
Select the action that has the key value and retrieves the record that serves as the basis for the mapping.
There are no specific restrictions regarding the source app for obtaining the records. It is fine if it is the same as the app being customized or the app being updated, and conversely, it can also specify an app that is different from both.
This record can contain multiple lines. If there are multiple lines, the process of “searching for the target record that matches the key and updating it” is repeated for each line. Conversely, if the number of records is zero, it will not result in an error, but since there are no targets for updating, no processing will be performed.
Specify the field to compare with the update target record as the key from the fields of the “Source Record”.
The records of the “Target App” whose “Key Field on Target App” matches the “Key Value Field on Source Record” will be targeted for the update process.
If you select a field in the table, processing will be performed for each row of the table.
This parameter accepts the following field types:
Enter the information to be registered in the records.
For each field you want to register, write in the form “Field code = value to be set.”
For detailed descriptions of this parameter, please refer to How to Define Field Mappings.
If a field code is specified in the expression of this mapping, that field will become a field of the “Source Record.” This is not a field of the record currently being edited on the screen. If you want to refer to the record currently being edited on the screen, use @this.
You can use @out in this mapping. It refers to the records that match the key.
Select from “Check” or “Do NOT check”.
Selecting “check” checks whether the updated record conflicts with updates from other users, and 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.
This Do does not trigger webhook notifications in the target app.