If a record in the specified app matches the key, update it. If not, add a new record. Specify the key value for searching the records to be updated using the fields in 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 designated 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 or Add Record Providing the Key With Field” or “Update or Add Record Providing the Key Value” instead of this “Update or Add 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.
Fields in tables cannot be selected.
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 acceptable for the app to be the same as the customized app or the app used for record registration; alternatively, it can specify a different app from both.
This record can contain multiple lines. If there are multiple lines, the process of “searching for the record to be updated 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 target record as a key from the fields of the “source record.”
The records of the “Target App” where the “Key Field on Target App” matches the “Key Value Field on Source Record” will be updated based on the “mapping”.
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, write in the format “Field code = value.”
For detailed descriptions of this parameter, please refer to How to Define Field Mappings.
If a field code is specified in the expression during mapping, that field will become a field of the “Source Records.” 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. If there is a record that matches the key, @out refers to that record. If there are no records matching the key, @out will be empty.
If a record matching the key exists, it will attempt to overwrite that record, but update conflicts will be checked at that time.
In the similar “Update or Add Record Providing the Key With Field”, whether to check for update conflicts can be selected in the settings, but in this “Update or Add Record Providing the Key With Field”, it is not possible to avoid checking for conflicts.
On the other hand, if there are no records that match the key, meaning a new record is being created, conflicts are not checked.
As a result, if two people perform the action at the same time, there is a possibility that two new records with the same content will be created. If you want to avoid this, it is strongly recommended to turn on “Prevent duplicate values” for the key field in the Kintone app settings.
If the Target App is set to send Webhook notifications under the condition of “Add Records,” notifications will be sent when this action adds records as a result of the execution.
If the result of “doing things” is an update of an existing record instead of adding a record, no Webhook notification will occur.