kintone · DOCS

kintone tips

A site that provides information to make better use of kintone.

REST API

Add a Record (Single)

This guide introduces how to add a single record using the kintone REST API. It also covers required permissions, cautions, and sample code for Node.js, GAS, and curl.

Adding Records (Multiple)

This page introduces how to add multiple records using the kintone REST API. Sample code for Node.js and GAS is also provided.

Delete Insert Records

When you want to update records using the API, you generally use the PUT API. However, there are situations where you need to delete all records under certain conditions and then recreate them, considering specifications and safety. This article introduces a code sample for such cases.

Deleting Records

This guide introduces how to delete records using the kintone REST API. The usage is the same for both single and multiple records. It also covers the 100-record limit per request, with sample code for Node.js and GAS.

Extract Specific Fields from Form Settings

In kintone, you can use the API to retrieve field information for a specified app. However, the API request parameters only allow you to set the app ID and language, so all fields of the specified app are retrieved. This includes standard fields such as record ID, creation date, and update date, as well as unused category fields. This article introduces a method to extract only specified fields from the form information retrieved using the API.

Bulk Retrieval Using Record ID

kintone offers multiple ways to retrieve record information using APIs. This article introduces the seek method, which allows bulk retrieval based on record IDs.

Get Field Names

By using the event object, which is the argument of the kintone.events.on callback function, you can retrieve the record information displayed in the list. However, you can only get the field code, field type, and value from this, and the field name is not included. This time, we will introduce a method to retrieve the field names set in a specific list.

Get a Record (Single)

This guide explains how to retrieve a single record using the kintone REST API. You can specify the record ID to get the record information. Sample code for Node.js, GAS, Python, and curl is also provided.

Retrieve Multiple Records

This guide explains how to retrieve multiple records using the kintone REST API. You can specify a query to filter records and retrieve only the fields you need.

Get Views

Learn how to use the kintone REST API to get an app's view settings. Covers required permissions, cautions, and sample code for JavaScript, Node.js, and GAS.

Tips

API Backdoor

When using the API in kintone, you can choose to use either an account ID and password or an API token for authentication

Constant Definitions

There are many ways to implement constant definitions, so it's always a challenge to determine the best method. Here, I will introduce a method that has worked well for me.

Sample for Adding Buttons to Record List and Detail Screens

Learn how to add buttons to the record list, detail, and edit screens in kintone JavaScript customization, with sample code. Also covers which header-space API to use and how to share logic across screens.

Field Code Naming

In kintone, various fields can be created in an app, and each field needs to be assigned a field name and a field code. The field name is mainly visible to users, while the field code is primarily used by app administrators and referenced in JavaScript. This article introduces field code naming conventions and tips for using field codes in JavaScript.

Implementing Download Functionality

One of the most common complaints I heard while developing apps on kintone was that the download (CSV export) functionality was cumbersome. To address this issue, I will introduce a simple method to implement custom download functionality.

Search by Single Character

kintone field search has limitations: it requires at least two characters for Japanese and searches only by whole words for alphabets and numbers. This article introduces a plugin I developed to solve this issue. It is open-source and free to use.

Applying Web Fonts

As of 2021, the default font in kintone is Meiryo, and there is no feature to change it. Additionally, Cybozu provides a CDN, but it only includes JavaScript libraries and icon fonts, not regular fonts. To address such requests, we will explain step-by-step how to load and apply web fonts using Google Fonts, which can be used as a CDN.

Impact of IE Discontinuation

With IE11 support ended, kintone JavaScript customizations no longer need legacy IE-compatible code. This article explains the impact on kintone development and why to use const and async/await instead of var and Promise chains.