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 General Notification Settings
- Update General Notification Settings
- Get Per Record Notification Settings
- Update Per Record Notification Settings
- Get Reminder Notification Settings
- Update Reminder Notification Settings
- Get Graph Settings
- Update Graph Settings
- Get Action Settings
- Update Action Settings
- Get Form
-
Records
-
Spaces
-
API info
-
JavaScript API
- JavaScript API Overview
- JavaScript API List
-
Events
-
Get Data
-
Other
-
User API
- User API Overview
-
Users
- Get Users
- Get Department's Users
- Get Group's Users
- Get User Services
- Add Users
- Update Users
- Update User Codes
- Update User Services
- Delete Users
Departments
- Get Departments
- Get User's Departments
- Add Departments
- Update Departments
- Update Department Codes
- Update User's Departments
- Delete Departments
Groups
-
Plug-in API
-
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
- Using Dropbox for JavaScript customization
- Get all records from an App (the offset method)
- Get all records from an App (the seek method)
- The three methods for bulk record retrieval
- Code examples for bulk record retrieval
- Bulk record retrieval using the Cursor API method
- Using Promises over Synchronous XHR
- Jswatchdog (JavaScript code checker)
- Efficient debugging with Google Chrome developer tools
- How to avoid unrecommended customizations
- Requests with multiple API tokens
Custom View
- Create a custom view
- Custom views with pagination and filtering
- Display record data in a custom view
- Create a blog-like custom view with Foundation
- Mobile-friendly custom views
- Sort records using jQuery UI Sortable
- Create a search form in a Custom View with Vue.js
Custom Portal
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
- Display maps with LeafletJS
- Embed code editors
- Using Font Awesome icons
- Display Gantt Charts
Pop-ups and Error Messages
- Display an alert dialog
- Display SweetAlert pop-ups
- Display SweetAlert2 pop-ups
- Display toastr pop-ups
- Display explanatory text pop-ups with popModal
- Validation checks in tables
- Show the confirmation dialog for process management
- Error messages with radio buttons
3rd Party Services
- Call Kintone REST API with Postman using OAuth Client
- 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
- Retrieve data with Slack Slash Commands and AWS Lambda
- Post approved Tweets using AWS Lambda
- Send emails from records with Gmail and Zapier
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
Data Backup
- Bulk download attachments using JSZip
- Download record comments in CSV format
- Back up and restore records and comments
Miscellaneous
- Show/hide a spinner with spin.js
- Identify the App Admin
- Create a Guest Space from an App
- 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
- Cancel deleting a record
- Organize data using Underscore.js
- Create a random record selector with Underscore.js
Tool Guides
-
Command Line
-
SDK
-
Library
-
Plug-ins Overview
-
Plug-in Tutorials
-
Simple Samples
-
Advanced Samples
-
Terms of Services and Guidelines