We've released an article for creating custom calculations on kintone using JavaScript.
The article shows how an if statement can be included in calculations of fields.
-
Introduction
-
Kintone REST API
- REST API Overview
- REST API List
-
Apps
- Get App
- Get Apps
- Add Preview App
- Deploy App Settings
- Get App Deploy Status
- Get Form Fields
- Add Form Fields
- Update Form Fields
- Delete Form Fields
- Get Form Layout
- Update Form Layout
- Get Views
- Update Views
- Get General Settings
- Update General Settings
- Get Process Management Settings
- Update Process Management Settings
- Get Customization
- Update Customization
- Get App Permissions
- Update App Permissions
- Get Record Permissions
- Update Record Permissions
- Get Field Permissions
- Update Field Permissions
- Evaluate Record Permissions
- Get Form
- Get Record
- Add Record
- Update Record
- Delete Records
- Get Comments
- Add Comment
- Delete Comment
- Download File
- Upload File
- Bulk Request
- Update Status
- Update Assignees
-
Spaces
-
API info
Records
-
JavaScript API
- JavaScript API Overview
- JavaScript API List
-
Events
-
Get Data
-
Other
-
User API
-
Plug-in Docs
-
Hello Kintone
- Tutorial
- JavaScript Tutorial 1
- JavaScript Tutorial 2
- JavaScript Tutorial 3
- JavaScript Tutorial 4
- Add Buttons (Record List)
- Add Buttons (Record Details)
- Retrieve Record Data (Record Details)
- Retrieve Record Data (Record List)
- Get all records from an App
- Custom View Tutorial
- Custom View Tutorial 2
- Utilizing Table Data
- Using custom calculations
- Post messages to Slack
- Linking Google Forms and Kintone
- Kintone x OpenStreetMap
- Debugging Tips for Kintone JS
- Using API Token authentication
- Webhooks
- Using Dropbox for JavaScript customization
- Jswatchdog (JavaScript code checker)
- SSO with Azure Active Directory
- Preparing the Command Line Tool
- Command Line Tool Basics
- Cli-kintone Tutorial 1: Export record data
- Cli-kintone Tutorial 2: Add and Delete records
- Cli-kintone Tutorial 3: Update Records
- Cli-kintone Tutorial 4 : Updating and re-sorting by query
- How to use the CDN
- Display SweetAlert pop-ups
- Show/hide a spinner with spin.js
- Moment.js - customize date formats
- Display radar charts with chart.js
- Custom Automatic Numbering
- Allow only 1 user for User Selection fields
- Calculations based on Table field edits
- Identifying the App Admin
- Enhancing the To Do App
- Bulk download attachments using JSZip
- Kintone x Azure Functions (Part 1)
- Kintone x Azure Functions (Part 2)
- Kintone x Azure Functions (Part 3)
- Create a Guest Space from an App
- Enabling Markdowns using the marked library
- Add yourself to a user field with one click
- Coloring the Record List
- Embed code editors
- Display toastr pop-ups
- Display SweetAlert2 pop-ups
- Download record comments in CSV format
- Set default rows in a table
- Use Kintone REST API's to create Access Logs
- Using Promises over Synchronous XHR
- Copying Process Management Settings to Another App
-
Samples
- Count table rows
- Count table rows (conditional)
- Count user names in tables
- Input date with a button click
- Use radio buttons to restrict field edits
- Use radio buttons to open group fields
- Display total number of related records
- Show day of the week on Date fields
- Log users who have viewed a record
- Check all checkboxes
- Zero-fill a number
- Add a new table row filled with data
- Show and Hide fields using Checkboxes
- Validation Checks in Tables
- Calculate with Local Date
- Get data from a field in the same table row
- Calculations with Radio buttons
- Character count
- Auto-assign a user when adding a record
- Numbering Tables
- Calculate and display total record counts
- Error messages with Radio buttons
- Show and hide fields on a questionnaire
- Showing the confirmation dialog for process management
-
Plug-ins Overview
-
Simple Samples
- Date Input Button
- 1 User Limit
- Show DoW
- Table Row Count
- Character Count
- Default Choice Restriction
- Conditional Record Count
- Table Numbering
Advanced Samples
-
Terms of Services and Guidelines
Please share your views with us in the Community forums!