{"id":27244,"date":"2024-03-08T15:40:36","date_gmt":"2024-03-08T06:40:36","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=27244"},"modified":"2024-09-20T10:09:11","modified_gmt":"2024-09-20T01:09:11","slug":"update_multiple_records","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/kintone_apps\/update_multiple_records\/","title":{"rendered":"kintone \/ Update multiple records"},"content":{"rendered":"\n

<\/i> Home<\/a> > User guide<\/a> > BOT<\/a> > How to use the BOT editor<\/a> > Extension<\/a> > kintone<\/a> > Update multiple records<\/p>\n\n\n\n

<\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n

App overview<\/h2>\n\n\n\n

Update multiple records in any app.<\/p>\n\n\n\n

<\/div>\n\n\n\n
Extended Feature URL<\/td>cbot-extension:\/\/cloud-bot:kintone:update-records:4<\/td><\/tr>
Provider<\/td>Extension : Cloud BOT official<\/span>
kintone : Cybozu, Inc.<\/a><\/td><\/tr>
External communication<\/td>Yes<\/td><\/tr>
Version<\/td>4<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Screen description<\/h2>\n\n\n\n

Input screen<\/h3>\n\n\n\n

kintone app information settings<\/strong><\/strong><\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

Domain name<\/strong><\/strong><\/p>\n\n\n\n

Specify a domain name.<\/p>\n\n\n\n

Example> c-bot.cybozu.com <\/small><\/p>\n\n\n\n

App ID<\/strong><\/strong><\/strong><\/p>\n\n\n\n

Specify the app ID.<\/p>\n\n\n\n

Example> 6 <\/small><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Guest space ID<\/strong><\/strong><\/strong><\/strong><\/p>\n\n\n\n

Specify the guest space ID. If the specified application belongs to a guest space, it must be entered.<\/p>\n\n\n\n

Example> 3 <\/small><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Authentication method<\/strong><\/strong><\/strong><\/strong><\/strong><\/p>\n\n\n\n

Select the authentication method.<\/p>\n\n\n\n

Password authentication: Authenticate using your login name (user account) and password.
\nAPI Token Authentication: Authenticate using the app's API token.<\/p>\n\n\n\n

* Click here<\/a> for about API Token Generation.
* If multiple API tokens are used, specify them separated by commas. Click here<\/a> for more information<\/small><\/p>\n<\/div>\n<\/div>\n\n\n\n

Input fields settings<\/strong><\/strong><\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

App name<\/strong><\/strong><\/strong><\/strong><\/p>\n\n\n\n

The application name is displayed.<\/p>\n\n\n\n

Input fields<\/strong><\/strong><\/strong><\/strong><\/strong><\/p>\n\n\n\n

Specify the fields of the record to be updated. The number of fields to be updated can be increased or decreased by clicking the Add and Delete buttons.
\n* Click here<\/a> to learn more about field entry rules.<\/small><\/p>\n<\/div>\n<\/div>\n\n\n\n

Update record settings<\/strong><\/strong><\/strong><\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

Key fields<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/p>\n\n\n\n

Specify the field that serves as the key for the target record conditions.
* Click here<\/a> for more information about key field.<\/small><\/p>\n\n\n\n

Key values<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/p>\n\n\n\n

Specify the value for the key field. Records matching this value will be updated.<\/p>\n\n\n\n

Filters<\/strong>(option)<\/p>\n\n\n\n

Records that match the filter will be processed.The number of filter conditions can be increased or decreased by clicking the Add and Delete buttons.
* Click here<\/a> to learn more about filter condition.
* Click here<\/a> for information on input rules for fields and operators.<\/small><\/p>\n<\/div>\n<\/div>\n\n\n\n

Update record settings(Input data)<\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

Value of each field<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/p>\n\n\n\n

Enter a value for each field.<\/p>\n\n\n\n

<\/p>\n<\/div>\n<\/div>\n\n\n\n

Result screen<\/strong><\/strong><\/h3>\n\n\n\n

The update is complete.<\/strong><\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

Results are displayed.<\/p>\n\n\n\n

* How the corresponding record is processed depends on the field and key specified in the update condition. Click here<\/a> for more information.
* If an error occurs, further processing is aborted.<\/small><\/p>\n<\/div>\n<\/div>\n\n\n\n

<\/div>\n\n\n\n
App name<\/strong><\/td>The application name is displayed.<\/td><\/tr>
Number of updates<\/strong><\/td>The number of records updated is displayed.<\/td><\/tr>
Number of filters<\/strong><\/td>The number of filtered records is displayed.<\/td><\/tr>
Number of update errors<\/strong><\/td>The number of failed record updates is displayed.<\/td><\/tr>
Number of skips<\/strong><\/strong><\/td>The number of unprocessed cases interrupted by error handling is displayed.<\/td><\/tr>
Total<\/strong><\/td>The total of Number of updates, Number of update errors, Number of filters, and Number of skips is displayed.<\/td><\/tr>
Update record keys<\/strong><\/td>The key of the updated record is displayed.<\/td><\/tr>
Revision number of the updated records<\/strong><\/td>The revision numbers of the updated records will be displayed.<\/td><\/tr>
Filtered record keys<\/strong><\/td>The key of the filtered record is displayed.<\/td><\/tr>
Key of the records that failed to update<\/strong><\/td>The keys of the records that failed to update will be displayed.<\/td><\/tr>
Error<\/strong><\/td>When a record update fails, the error message is displayed.<\/td><\/tr>
Error details<\/strong><\/td>Details of the error are displayed.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

Additional information about filters<\/h3>\n\n\n\n

Records that match the filter will be processed. Filters can be increased or decreased by clicking the Add or Delete button.\n
\n* All specified conditions must match.<\/small>\n<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Field<\/strong><\/p>\n\n\n\n

Specify the fields.<\/p>\n\n\n\n

Operator<\/strong><\/p>\n\n\n\n

The following operators can be selected. The operators available depend on the field you specify.<\/p>\n\n\n\n

\u30fb= (equal to)
\u30fb\u2260 (not equal to)
\u30fb\u2264 (less than or equal to)
\u30fb< (less than)
\u30fb\u2265 (greater than or equal to)
\u30fb> (greater than)
\u30fbincludes any of
\u30fbdoes not include any of
\u30fbcontains
\u30fbdoes not contain<\/p>\n\n\n\n

See below.<\/p>\n\n\n\n

<\/div>\n\n\n\n
\n
\n
\n

\u00a0<\/p>\n\n\n\n\n\n
Field<\/strong><\/th>\nequal to<\/th>\nnot equal to<\/th>\nless than or equal to<\/strong><\/th>\nless than<\/strong><\/th>\ngreater than or equal to<\/th>\ngrater than<\/strong><\/th>\ncontains value<\/strong><\/th>\ndoes not contain value<\/strong><\/th>\n<\/tr>\n
\u30fbText
\u30fbText area
\u30fbNumber
\u30fbCalculated
\u30fbRich text
\u30fbDrop-down
\u30fbRadio button
\u30fbLookup
\u30fbDate
\u30fbDate and time
\u30fbLink
\u30fbTime
\u30fbRecord ID
\u30fbRecord number<\/strong>
\u30fbLigin user<\/strong>
\u30fbRevision<\/strong>
\u30fbUpdated by
\u30fbUpdated datetime
\u30fbCreated by
\u30fbCreated datetime
\u30fbStatus<\/strong>


<\/td>\n		\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n<\/tr>\n
\n

\u30fbMulti-choice<\/strong>
\u30fbCheck box<\/strong>
\u30fbUser selection(Login name)<\/strong>
\u30fbDepartment selection(Department code)<\/strong>
\u30fbGroup selection(Group code)
\u30fbAssignee
\u30fbAttachment
\u30fbFiles in table<\/strong><\/p>\n<\/td>\n

\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<\/div>\n<\/div>\n\n\n\n

* On the kintone side, it is necessary to enable Worker and Status.
\n* Related records, Field group\n, and Category do not appear in the conditional settings.<\/small><\/p>\n\n\n\n

value<\/strong><\/p>\n\n\n\n

Specify a value.<\/p>\n","protected":false},"excerpt":{"rendered":"

 Home > User guide > BOT > How to use the BOT editor > Extension > kintone > Update multiple records App overview Update multiple records in any app. Extended Feature URL cbot-extension:\/\/cloud-bot:kintone:update-records:4 Provider Extension : Cloud BOT officialkintone : Cybozu, Inc. External communication Yes Version 4 Screen description Input screen kintone app information settings Domain name Specify a domain name. Example> c-bot.cybozu.com App ID Specify the app ID. Example> 6 Guest space ID Specify the guest space ID. If the specified application belongs to a guest space, it must be entered. Example> 3 Authentication method Select the authentication method. Password authentication: Authenticate using your login name (user account) and password. API Token Authentication: Authenticate using the app's API token. * Click here for about API Token Generation.* If multiple API tokens are used, specify them separated by commas. Click here for more information Input fields settings App name The application name is displayed. Input fields Specify the fields of the record to be updated. The number of fields to be updated can be increased or decreased by clicking the Add and Delete buttons. * Click here to learn more about field entry rules. Update record settings Key fields Specify […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_locale":"en_US","_original_post":"https:\/\/docs.c-bot.pro\/?p=27016","footnotes":""},"categories":[123],"tags":[68,53,59,57],"class_list":["post-27244","post","type-post","status-publish","format-standard","hentry","category-kintone_apps","tag-bot","tag-kintone","tag-59","tag-57","en-US"],"_links":{"self":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/27244","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/comments?post=27244"}],"version-history":[{"count":10,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/27244\/revisions"}],"predecessor-version":[{"id":30885,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/27244\/revisions\/30885"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=27244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=27244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=27244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}