Customize Kintone App
DO
CONDITION
'event'
when the record list page is displayed
when the record details page is displayed
when the record create/edit page is displayed
when the record create/edit/detail page is displayed
when the record edit page is displayed
when the record create page is displayed
when the record create page of reused mode is displayed
when the record is saving include deleting
when the record is saving exclude deleting
when the record is deleting
after the record has been saved
when a specified field value changes
when a specified CALC field value changes
When Table Row Added
When Table Row Removed
When Table Row or Removed
When Process Action Proceeded
When Kintone Event Triggered
'Pluguin Cooperation'
'other condition'
When Button Clicked
When Cancel Clicked in Confiramation/Input Dialog
When OK Clicked in Confiramation/Input Dialog
When Record is Auto-Saved
When Another Action Complete.
'page'
if current page is the record list page
if current page is the record details page
if current page is the record create page
if current page is the record edit page
if current page is the mobile page
if current page is the PC page
If List Page is Specified View
'field condition'
If Field Value is Specified
If All Field Satisfy Same Condition
If One Field Satisfy Condition
If Field Contains Two or More Value
If Field is Accessible to Show
If Field is NOT Accessible to Show
'other additional condition'
If the Login User is a Guest.
If the Login User is NOT a Guest.
If the Login User is Specified One
If the Login User Belongs to Group/Organization
If the Login User do NOT Belongs to Group/Organization
If Status is Specified
If the Count of Records is Zero
If the Count of Records is Greater Than Zero
If Date is Specific Day-of-the-week
If Comparing Two Dates Satisfies Conditions
Job Runner
Do
Fields
Auto Input to field
Input values to Multiple fields at Once
Input value to Text Area
Clear Field Values
Add Choices to Multiple Choices Allowed Field
remove Option Values From Multiple Choices Allowed Field
Round Down Field Value
Round Up Field Value
Round Off field value
Convert Half-width to Full-width
Convert Full-width to Half-width
Convert Alphanumerics and Symbols From Full-width to Half-width
Convert Uppercase to Lowercase
Convert Lowercase to Uppercase
Convert Katakana to Hiragana
Convert Hiragana to Katakana
Remove Blank Spaces
Extract Characters From the Beginning of the Field
Extract Characters From the End of the field
Replace Part of Field Value
Replace Strings with Specified Regular Expressions
Calculate Age
Convert from the Gregorian Calendar to the Japanese Emperor Reign
Update Lookup Fields
Auto Numbering
Copy Attachments
Create String for Search
Record
Configure Set Kintone API Token
Retrieve Records Passed by Webhook
Retrieve All records
Retrieve Record ID Passed by Webhook
Retrieve Records by Providing Key
Retrieve Records by Providing Conditions
Retrieve Records by Providing Conditions in Query
Retrieve Records by Providing Conditions in Query (No Escaping)
Retrieve Records with Same Conditions of Related Records
Save Updated Records
Save Updated Records One by One
Add New Record
Add Records from Other Records
Add Records from Date Range
Update Records by Key Value
Update Record Providing the Another Record Field
Update or Add Record Providing the Key Value
Update or Add Record Providing the Another Record Field
Export Table Data to Another app
Remove Duplicated Records
Sort Records
Filter Retrieved Records
Combine Records
Bundle Records by Field Value
Bundle Records by Field Value
Convert Record Rows to Columns
Convert Record Columns to Rows
Post Comment on Specified Record
Update App Management App's Records
Update Customization Management App's Records
Update Job Execution History App's Records
Tables
Retrieve Table Rows as Records
Export Records to Table
Add New Record with Table
Add Row to Table
Delete Row From Table
External Service Integration
Post Message to Slack
Post Message to Microsoft Teams
Post Message to Google Chat
Post Message to Chatwork
Configure Connection to LINE WORKS
Post Message to LINE WORKS
SendGridSend E-mail using SendGrid
Send E-mail with Attachments using SendGrid
Output Through Print Creator
Configure Collaboflow Connection (Japan Only)
Output Collaboflow Document as PDF (Japan Only)
Get Information from the Webhook of Collaboflow (Japan Only)
Get Eligible Billing Vendor Information (Japan Only)
Retrieve Payment Link ID Passed by Stripe Webhook
Get the Checkout Session ID Passed from Stripe's Webhook
Retrieve Payment Intent ID Passed by Stripe Webhook
Get Customer Information Passed from Stripe's Webhook
Retrieve Payment Amount Passed by Stripe Webhook
Create Payment Link of Stripe
Deactivate Payment Link of Stripe
Create Checkout Session of Stripe
Make Stripe Payment Detail Page URL
Generate Text From Text Using OpenAI
Generate Text From Text and Images Using OpenAI
Process Management
Change Status
Change Status on Each Specified Record
Changing Process Management assignees
Date and Time
Set Time Zone
Get Specific Date
Get Specific Date by Providing Date
Get a Date on the Day of the Week
Get a Day of the Week from Date
Calculate the Number of Days
Calculate the Number of Months
Calculate Date
Calculate Time
Round Up Time
Round Down Time
Remove Date From Date and Time
Remove Time From Date and Time
Calculate Fiscal Year
Calculate the Number of Fiscal Year
Format Dates and Times
Aggregation
Sum of Field of Records
Minimum of Field of Records
Count the Number of Records
Count Selection of Field of Records
Average of Field that Meets Criteria
Sum of Field that Meets Criteria
Calculate Average of Fields in Records
Maximum of Field that Meets Criteria
Minimum of Field that Meets Criteria
Count the Number of Records by Providing Conditions
Maximum of Field of Records
Count the Options Selected in Records by Providing Conditions
Other
Output Excel
Output PDF
Output CSV
Output Excel by Query
Output PDF by Query
Output CSV by Query
Retrieve Comment Text passed by Webhookk
Retrieve the Author of the Comment Passed by Webhook
Retrieve the Recipient of the Comment Passed by Webhook
Get Last Job End Time.
Format Number
Format Phone Number
Get User Profile
Generate Text from Template
Generate QR
Put Log Message
Generate Text From Text Using OpenAI
Generate Text From Text and Image Using OpenAI
Generate Text From Text Using Azure OpenAI
Generate Text From Text and Image Using Azure OpenAI
Do Nothing
Conditions
Other Conditions
When the Webhook Starts
When the time for execution comes
When One Record is Ready
When All Records Are Ready
When Another Action Complete
When Any Action Complete.
When Main Process Complete
Field Condition (additional condition)
If the field value is a specific value
If Field Value is Empty
If Field Value is NOT Empty
If All Field Satisfy Same Condition
If One Field Satisfy Condition
If All Fields Are Empty
If At Least One Field Is Empty
If Field Value is Equal to One of the Specified Values
If All Selected Field Value is Equal to One of the Specified Values
If Field Contains No Value
If Field Contains One or More Value
If Field Contains Two or More Value
Webhook (Additional Conditions)
If the webhook occurs due to the addition of records
If the webhook occurs due to the record editing
If the webhook occurs due to the record deletion
If the webhook occurs due to the post of comments
If the webhook occurs due to the status update
If the webhook occurs due to the completion of Stripe Checkout Session
If the webhook occurs due to the completion of Stripe Payment Intent
Other Conditions (Additional Conditions)
If Result of Action is Specified Value
If Comparing Two Values Satisfies Conditions
If Status is Specified
If the Count of Records is Zero
If Date is Specific Day-of-the-week
If Date is Specific Month
If Comparing Two Dates Satisfies Conditions
If Comparing Two Times Satisfies Conditions
If the Date within the Range
If the Time within the Range
Writing Expressions and Mappings
How to Write a Formula
Available Operators
How to describe field mapping
How to Assess the Equality of Field Values
Comparison of large and small fields
How to Describe Field Values According to Field Type
How to Write a Text Template
Functions List
Today Function
NOW Function
FORMAT Function
getdate Function
ROUND Function
ROUNDUP Function
ROUNDDOWN Function
ABS Function
COUNT Function
max Function
MIN Function
SUM function
AVG Function
StringMax Function
stringmin function
TextJoin Function
LEFT Function
RIGHT Function
MID Function
encodeuri Function
encodeuricomponent Function
IF Function
AND Function
OR Function
NOT Function
APPEND Function
FindIf Function
Q Function
Excel/PDF Output
Reference Manual
Errors in Excel and PDF Outputs and How to Fix Them
Supported Excel Functions
Kintone Error Codes and Their Solutions
日本語
English
Customer Support
R3 Blog
Facebook
Welcome to Gusuku Customine Document
>
DO
> 'date and time'
Customize
'date and time'
Get Specific Date by Providing Date
Calculate the Number of Days
Get Specific Date
Get date of specific day of the week
Get day of the week from date
Calculate Date
Calculate Fiscal Year
Calculate Period Number
Calculate the Number of Months
Format Date/Time
Calculate Time Difference
Round Up Time
Round Down Time
Remove Time From Date and Time
Remove Date From Date and Time
Get a Date from Date Range