If a record in the specified app matches the key, update it. If not, add a new record.
Set Target App, Key Field on Target App, Key Value Field on This App, and Mapping.
Select the app to add or update records.
Select the field that will be the key for retrieving records.
Fields in tables cannot be selected.
This parameter accepts the following field types:
Select a field with a value to compare with the “Key Field on Target App” from the fields of the app you are customizing. Fields in tables can be selected.
When selecting fields in the table, the update or addition process will be executed sequentially for all rows that match the “condition.”
This parameter accepts the following field types:
Enter the information to be registered in the record.
For detailed descriptions of this parameter, please refer to How to Define Field Mappings.
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.
You cannot register values in the following fields:
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.
Conversely, if no records match the key, indicating 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 this Do is an update of an existing record instead of adding a record, no Webhook notification will be sent.