QR Code Reading (for Search) Plug-in Ver8

potara
4 min readJan 6, 2021

--

This plugin allows you to search kintone records based on the contents of QR codes.
Since the camera is launched on the browser (kintone screen), you can quickly read the QR code.

Two types of analysis of QR code contents are supported: “delimited by specific characters” and “delimited by number of characters.
It works on the record list screen, and if there is only one record, it automatically moves to the detail screen.
If there are multiple records, it displays them as choices and moves to the detail screen after selection.
Japanese, English, and Chinese languages are supported.

Introduction to Operation

You can set up to three QR code readers per app.
Here is an example of how it works with two of them enabled.

Operation Example 1 (In the case of Plug-in Configuration Example 1 described below)

This is an example of using a specific character as a delimiter.
In this case, since there are four records, we will display them as choices.

https://twitter.com/i/status/1179014113462124544

Operation Example 2 (in the case of Plug-in Configuration Example 2 described below)

This is an example of using delimitation by number of characters.
In this case, since there is only one record, the user is automatically redirected to the detail screen.

https://twitter.com/i/status/1179014226293084160

Setting up plug-ins

Setting Example 1

This is an example of delimitation by specific characters.
In this case, the data is separated by “,” and the records whose second data is equal to the department name will be searched.
If multiple conditions are specified, the search is performed as an “and” condition.
To give a concrete example, if the content of the QR code is “Kintetsu Transport & Research Institute, Information System Department,” records whose department name is “Information System Department” will be searched.

Setting examples 2

Here is an example of delimitation by number of characters.
The first character is counted as 0, not 1.
The first character is counted as zero, not one.
The first character is counted as the 0th character, not the 1st character.

If multiple conditions are specified, the search is performed as an “and” condition.
For example, if the content of the QR code is “Kintoun Research Institute, Information System Department,” records with “Company name: Kintoun Research Institute” and “Department name: Information System Department” are searched.

!Cautions!

The size of the QR Code that can be read depends on the performance of the camera and the size of the data that the QR Code can hold.
Please try it on the device you will actually use.

Restrictions

Not available for iOS kintone mobile apps.
As of August 2020, camera activation is restricted.
With the upgrade of the kintone mobile app, it is now available on the Android kintone mobile app.
It is not available in the Google Chrome browser on iOS.
As of August 2020, camera activation is restricted.
The fields and search conditions available for searching are as follows
String (one line), equal (=)
Rich editor, include (like)
String (multiple lines), include (like)
Numeric, equal (=)
Calculation, equal (=)
Radio button, include (in)
Dropdown, include (in)
Link, equal (=)
Lookup (=)
The fields that can be displayed when selecting a record are as follows
Character string (1 line)
Numeric
Calculation
Radio button
Drop-down
Date
Time
Date and time
Link
Record Number
Creation Date
Update Date
Lookup
Fields in the table cannot be used for lookup.
Fields in the table cannot be displayed when selecting records.

Download the plugin

It is available for sale on this website. (Potara.net)
There is a 30-day trial period.

QR code for trial use

If you want to try it out right away, please use this QR code.
(You don’t need to print it out, you can read it from your display.

The contents of this QR code are as follows
Golden City Transportation Research Institute, Information Systems Department

If you want to try reading with this QR code, you can use the customer list in the app store, which is convenient because it contains the necessary records.

The setting example 1 or 2 on this page can be used as is.

Updates

2020/4/28 v8 release
Fixed some minor bugs.

2020/2/24 v7 released
Support for lookup fields
Fixed a bug that you can’t select a field in a table

2020/1/19 v6 released
Reduced load when launching camera

12/8/2019 v5 Released
Fixed a minor bug

12/6/2019 v4 Released
Fixed a minor bug.

11/14/2019 v3 Released
Fixed a minor bug

Oct 23, 2019 v2 released
Fixed a minor bug

2019/10/2 v1 Released

--

--