kintone Plug-in: "Bulk Update" Plugin

Series Outline

kintone Plaform Part 1 - Business database apps creation platform without coding

kintone Plaform Part 2 - Using Plug-in to extend your platform features

kintone Plaform Part 3 - Plug-In development Tutorial

kintone Plaform Part 4 - Plug-in List

Overview

In this article, i will introduce to you a new useful Plugin. Unless you known about below topics, please review its (in the series outline at the first part) before continue:

  • What is kintone
  • What is Plugin
  • Plugin eco-system and Plugin development Tuttorial

Problem

  • When working with Database Management System liek SQL Server, mySQL, Oracle, ... You have the ability to modify many records even whole table at the same time. Regrettably, kintone does not provide that feature but you can still use a plugin in order to realize it. Plugin Bulk Update can update/ replace many records at the same time quickly, automatically. It also brings a friendly interface with end-users.
    So let's investigate how to use it practically.

How to use Plug-in

Bulk Update plugin Advantages

Bulk Update 's developed to improve the updating data work better. Plugin supports 2 modes : Replace String and Update Data.

  • With Replace String, you can search a term and then replace it with the word/number provided.
  • With Update Data, you update the whole filterd data records appears on the screen by your provided data .

Step by Step Tutorial

  • Please follow the last article (Plugin: Sum of Total Records) to install Plugin to your kintone App at first.
  • After setting up successfully, you can use it freely depend on your needs.

Replace String Mode Guide

Firstly, i would like to inform that, this mode only supports for the following fields:

  • Text (Single Line Text)
  • TextArea (Multi Line Text)

It also avoids some fields set:

  • Calculation
  • Reference to a look-up (destination of a lookup source field)

Let's take an example: Assuming that, I have a "Bulk Update" sample app.

Choose the desired field in the dropdown list:

Enter the string, that you 'd like to be replaced at Search Term input box. The new string will be entered at "Replace String". After that, press at CONFIRM button.

Congratulation, replaced successfully!!! You can follow the information message - press CONFIRM button again - to do a reload of your page so that the new content will appear on the screen.

Update Data Mode Guide

  • Similarly to Relace String Mode, there are some notices when using Update Data Mode. Here are supported fields of this mode:
    • Text (Single line text)
    • TextArea (Multi line text)
    • Date
    • Date&Time
    • Dropdown
    • Checkbox
    • Radio button
    • Number
  • Fields, which has these setted attribute, will be not included:
    • Calculation
    • Prohibit Duplicate Values

As the previous part, we do an example together to sum up. On constract, you must choose Update Data mode, at the top of the function box to switch to Update Data mode. Here, i choose "Number" field.

Input the value, that i would like to update all records of "Number" field - "123".

Dont forget to press CONFIRM, after review your input carefully, all of replaced data can not be brought back.

Done, everythings seem to work perfectly. Although, you can struggle some error messages when using it, please follow the direction of the message. If you still can not fix it, please feel free to post your problems here, and i'll try to support asap.

Notes

  1. We do not guarantee this sample to run.
  2. We do not provide any technical support for this sample Plug-in.

Downloadable Content

zip file, please download the follwed link and upload whole package to kintone, don't extract it before upload to kintone. https://goo.gl/h2FXRG

It is not the end

I hope that this plugin can bring some benefits to your work. This series is not yet end and we will still meet again to discuss about more interesting plugins afterward. If you have any questions, please place a comment and i will try to reply as fast as possible. Thank you !