Customize Kintone App
DO
Conditions
'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 or Removed
When Process Action Proceeded
When Kintone Event Triggered
When Record Add Page Displayed Without Duplicating Mode
When Record Add/Edit Page Displayed or When Fields Value Changed
When Table Row Deleted
When Table Row Duplicated by Row's Duplicate Button
When Lookup Succeed
When Lookup Failed
When Graph Displayed
When Record List Page or Graph Displayed
When the Kintone Portal page Displayed
When Record List Page Displayed With Tree View
'Pluguin Cooperation'
When krewSheet is displayed
When krewSheet is reloaded
When redrawing krewSheet after save
When a krewSheet row is added
When a krewSheet row is duplicated
When a krewSheet row is added
When you receive a call with Amazon Connect
When you start a call with Amazon Connect
When you end a call with Amazon Connect
'Other Condition'
When Button Clicked
When Tab Clicked
When Cancel Clicked in Confirmation/Input Dialog
When OK Clicked in Confirmation/Input Dialog
When Record is Auto-Saved
When Pulldown Selection Changed
When the QR Code or Barcode is Recognized
When Record on Gantt Chart Clicked
When Record Edit Page should be Locked
When Record Editing is Locked
When Record Editing is Unlocked
When Table Data is Read from CSV
When Error Check Results an Error
When Another Action Complete.
When Kintone API Failed
When Any Action Complete
When an Element is Fetched from List
When Fetching List is Finished
'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 current page is the record create page that is reused mode
If List Page is Specified View
if current page is the record create page that is not reused mode
if current page is the record create page from app action
if current page is the record create page or the record edit page
If List Page is Searched Using the Customine Search Form
If current page is the krewSheet page
If current page is NOT the krewSheet page
If current page is the Calendar Plus page
If current page is NOT the Calendar Plus page
'Field Condition'
If Field Value is Empty
If Field Value is NOT Empty
If Field Has an Error
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
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 All Table Columns Satisfy Same Condition
If One Table Column Satisfy Condition
If the field satisfy same condition in all records
If at least one record whose field satisfy the condition
If Field Contains No Value
If Field Contains One or More Value
'Other Additional Condition'
If Result of Action is Specified Value
If the Login User is a Guest.
If the Login User is NOT a Guest.
If Comparing Two Values Satisfies Conditions
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
If the User Belongs to All Groups and Organizations (Departments)
If the User Belongs to at Least One Group or Organization (Department)
If the User Does NOT Belong to Any Group or Organization (Department)
If the User Does Not Belong to Any Group or Organization (Department)
If the User Has Specified Job Title
If status matches one of specified values
If the Records in the List Page is Checked
If Date is Specific Month
If Comparing Two Times Satisfies Conditions
If the Date within the Range
If the Time within the Range
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
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