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
- Get Records
- Add Record
- Add Records
- Update Record
- Update Records
- Delete Records
- Get Cursor
- Add Cursor
- Delete Cursor
- 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
-
Kintone Customization 101
- Hello Kintone
- Event handling
- Event objects
- Retrieve record data from the record details page
- Retrieve record data from the record list page
- Webhooks
- Using API token authentication
- How to use the CDN
Development Productivity
- Debugging tips for Kintone JS
- Jswatchdog (JavaScript code checker)
- Using Dropbox for JavaScript customization
- Get all records from an App (the offset method)
- Get all records from an App (the seek method)
- Using Promises over Synchronous XHR
Custom View
Manipulate Display Format
- Change field text colors
- Customize date formats with Moment.js
- Show day of the week on date fields
- Enable markdowns using the marked library
- Color the record List
- Enhance the To Do App with conditional coloring
Embedding
- Add buttons to the record list
- Add buttons to the record details
- Display radar charts with chart.js
- Display maps with OpenStreetMap
- Embed code editors
Pop-ups and Error Messages
- Display an alert dialog
- Display SweetAlert pop-ups
- Display SweetAlert2 pop-ups
- Display toastr pop-ups
- Validation checks in tables
- Show the confirmation dialog for process management
- Error messages with radio buttons
3rd Party Services
- Share process management statuses with Slack
- Linking Google Forms and Kintone
- Get record data with Azure Functions
- Schedule cron jobs with Azure Functions
- Back up record data to Azure Storage
- SSO with Azure Active Directory
- Sync customer information to Marketo
- Export records to an Excel file
Count Record Content
-
Count Table Content
-
Count Records
-
Count Field Values
Autofill Data
-
Custom Calculations
-
Custom Numbering
-
Click Initiated
-
Miscellaneous
Show, Hide, or Restrict Fields
- Show and hide fields using checkboxes
- Show and hide fields on a questionnaire
- Use radio buttons to restrict field edits
- Use radio buttons to open group fields
- Allow only 1 user for user selection fields
Miscellaneous
- Show/hide a spinner with spin.js
- Identify the App Admin
- Bulk download attachments using JSZip
- Create a Guest Space from an App
- Download record comments in CSV format
- Use Kintone REST APIs to create access logs
- Copying process management settings to another App
- Get data from a field in the same table row
Tool Guides
-
Command Line
-
SDK
-
Library
-
Plug-ins Overview
-
Simple Samples
-
Advanced Samples
-
Terms of Services and Guidelines