Customize Kintone App
DO
'field'
Disable Field
Enable Field
Hide Field or Group
Display Field or Group
Set Field Value
Set Multi Line Text Field Value
Set Rich Text Text Field Value
Clear Field
Clear All Fields
Add Selection to Field
Round Down Field Value
Round Up Field Value
Round Field Value
Convert from Half-width to Full-width
Convert from Full-width to Half-width
Convert to Lowercase
Convert to Uppercase
Convert Katakana to Hiragana
Convert Hiragana to Katakana
Input Values to Multiple Fields at Once
Replace Part of Field Value
Replace by Regular Expression
Calculate Age
Convert Christian Calendar to Japanese
Search Address from Zip Code (Japanese Only)
Search Address from Zip Code(old)
Update Lookup
Auto Number
Copy Attachment
Remove Option Values From Multiple Choices Allowed Field
Convert Full-width to Half-width
Convert Alphanumerics and Symbols From Full-width to Half-width
Convert Hiragana and Katakana to Roman Alphabets
Convert Letters to Numbers
Remove Blanks Spaces
Extract Characters From the End of the Field
Convert Multi-line Text to Single Line
Split Single-line Text to Multiple Lines
Replace Strings with Specified Regular Expressions
Calculate Age
Update Lookup Fields of Another App
Clear Lookup Fields
Fetch Values from Another App
Copy Attachment of Other Records
Download All Attachments
Gather Chosen Users
Gather Chosen Departments
Gather Chosen Groups
Gather Selected Options
Create String for Search
'error check'
Set Error to Record
Set Error at Field
Clear Error of Field
Check Required
Check Phone Number Format
Check E-mail address format.
Check with Regular Expression
Check Range of Number
Check Number of Characters
Ser Error if Field Value is not Full-Width
Ser Error if Field Contains Two or More Value
Ser Error if Field Value is not Half-Width
'record'
Retrieve Records by Providing Conditions
Retrieve Records by Providing Conditions in Query
Retrieve Record with Highest Field Value
Retrieve the record with the lowest value in the specified field from the app.
Retrieve Record Passed by Previous Page
Retrieve All Records
Retrieve Records By Key
Retrieve Records By Condition
Retrieve Record Displayed on List Page
Retrieve All Record by List Page Condition
Retrieve Selected Records on List Page
Retrieve Records by Reference Table Condition
Add Record
Update Record
Add or Update Record
Write Record
Write Table Row to Another App as Record
Backup Editing Record
Rectore Backuped Record
Remove Duplicated Records
Sort Records
Reuse Record
Update Record Providing the Key With Field
Update Record Providing the Another Record Field
Update or Add Record Providing the Key With Field
Update or Add Record Providing the Another Record Field
Export Each Record to the App
Export Records With Tables to App
Export Each Record With Tables to the App
Export Sort Records to Another App
Filter Retrieved Records
Post Comment on Current Record
Post Comment on Specified Record
Auto Numbering Multiple Records at Once
'table'
Retrieve Subtable Row as Record
Retrieve Subtable Row in another Record as Record
Write the Record to the Subtable
Add Record with Table Data
Add Row to Subtable.
Remove Row from Subtable.
Sort Table Row
Move Row ADD / REMOVE Button to the Left Side
Hide Row ADD / REMOVE Button
Set Table Like Spreadsheet
'button and tab'
Place Button at Spacer
Disable Button
Place Button in Header
Enable Button
Add Check Button at the List Page.
Add Radio Button at the List Page.
'other UI'
Display Information Dialog
Display Error Dialog
Display Warning Dialog
Display Confirmation Dialog
Display Input String Dialog
Display Record List in Dialog
Display Text at Spacer
Add Label at Spacer
Diaplay Text in Header
Add Label in Header
Change Text you put at SPACER or Menu.
Set Text to the added Label.
Expand Group
Expand Group
Collapse Group
Collapse Group
Display Loading Screen
Exit Loading Screen
Change Field Text Color
Change Field Background Color
Scale Field Font Size
Change Record Background Color
Reload Page
Collapse Comment/History Tab
Hide Add Record Button
Hide Reuse Record Button
Hide Delete Record Icon in the List Page
Hide Pencil Icon in the List Page
Put Keyword Search Form on List Page
Put Simple Search Form on List Page
Remove Choice from List Page
Remove -All- from List Page
Make Pulldown from Records
Make Year/Month Picker
'External Service Connection'
Set AWS Access Key
Get Credentials Using AWS Cognito
Invoke AWS Lambda Function
Show Map at Spacer
Show Map in Header
Add Marker to Map
Acquire Latitude and Longitude from Address
'process management'
Change Status on Current Record
Change Status on Each Specified Record
Change Assignees on Current Record
Change Assignees on Specified Records
Get Process Management Action Information
Change Status (Current Record)
Change Status (Specified Record)
'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
'aggregate'
Calculate Average of Fields in Table
Calculate Total of Fields in Table
Calculate Highest Fields in Table
Calculate Lowest Fields in Table
Count the Number of Rows in Table
Count the Options Selected in Table
Calculate Average of Fields in Table by Providing Conditions
Calculate Total of Fields in Table by Providing Conditions
Calculate Highest Fields in the Table by Providing Conditions
Calculate Lowest Fields in Table by Providing Conditions
Count the Number of Rows in Table by Providing Conditions
Count the Options Selected in Table by Providing Conditions
Calculate Average of Fields in Records
Calculate Total of Fields in Records
Calculate Highest Fields in Records
Calculate Lowest Fields in Records
Count the Number of Records
Count the Options Selected in Records
Combine Field Values in Records Into a Single String
Calculate Average of Fields in Records by Providing Conditions
Calculate Total of Fields in Records by Providing Conditions
Calculate Highest Fields in Records by Providing Conditions
Calculate Lowest Fields in Records by Providing Conditions
Count the Number of Records by Providing Conditions
Count the Options Selected in Records by Providing Conditions
Combine Field Values in Records Into Single String by Providing Conditions
'other'
Output Excel
Output PDF
Output CSV
Output Excel by Query
Output PDF by Query
Output CSV by Query
Format Phone Number
Get Belonging Organization of Login User
Get Priority Department
Get User Profile
Get Belonging Organization of Selected User
Get Belonging Group of Selected User
Get Primary Organization of Selected User
Get Users Belonging to an Organization
Get Users Belonging to a Group
Get User's Location
Format Number
Get Login User
Open Record List Page
Open List Page Narrowed by Conditions
Get Belonging Group
Open Record List Page that Displays Specified Records
Get Belonging Organization
Cancel Save of Record
Open Record Detail Page
Open Record Edit Page
Open Record Create Page
Open Record Edit Page Passing Record
Open New Record Page with Record Provide
Run JavaScript
Go to Portal
Lock Record Edit Page
Show Record Lock Status in Spacer
Show Record Lock Status in Header
Generate Random String
Calculate String Bytes
Generate Text from Template
Generate QR
Invoke Kintone Webhook
Invoke Scheduled Task
Synchronize Customization Access Permissions with Kintone Apps
Fetch List Element
Fetch Number From Range
Define Value by Gusuku Environment
Define Password by Gusuku Environment
Put Console Message
Put Console Action Result
Do Nothing
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