Display the Total Records that Contain a Specific Value
This article introduces how to calculate the total number of records that contain a field with a specific value. The total number is placed in the header menu, above the list of records.
An event is triggered when the Record List page is displayed. A Kintone REST API is called to retrieve records inside the App. If the records in the Record List are filtered, the filter query is used in the REST API call. In this example, only records that include "In progress" in the Drop down field are retrieved. The total number of retrieved records is calculated, and displayed in the header menu above the list of records.
Prepare the App
Create an App with the following fields and settings.
|Field Type||Field Name||Field Code||Notes|
|Drop down||Status||task_status||Set the following options:
After saving the settings and clicking on Update App, navigate to the Record List page. The number of records with the specified query should be displayed in the header menu.
- The number of records retrieved with this sample is dependant on the limitations of the Get Records API that is being called. Read the dcoumentation for more details.