カスタマイズ
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
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
'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 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
'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 (Current Record)
Change Status (Specified Record)
'date and time'
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
Format Date/Time
'aggregate'
Average of Field of Table
Sum of Field of Table
Maximum of Field of Table
Minimum of Field of Table
Count Rows of Table
Average of Field that meets Criteria.
Sum of Field that meets Criteria.
Maximum of Field that meets Criteria.
Minimum of Field that meets Criteria.
Count Rows of Table that meets Criteria.
Count Selection of Field that meets Criteria.
Average of Field of Records
Sum of Field of Records
Maximum of Field of Records
Minimum of Field of Records
Count Rows of Records
Count Selection of Field of Records
Count Selection of Field of Records that meets Criteria.
Average of Field that meets Criteria.
Sum of Field that meets Criteria.
Maximum of Field that meets Criteria.
Minimum of Field that meets Criteria.
Count Rows of Records that meets Criteria.
'other'
Format Number
Get Login User
Get Belonging Group
Get Belonging Organization
Cancel Save of Record
Run JavaScript
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
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
Count the Number of Records
Count Selection of Field of Records
Average of Field that Meets Criteria
Sum of Field that Meets Criteria
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
Writing Expressions and Mappings
Available Operators
Comparison of large and small fields
How to Describe Field Values According to Field Type
How to describe field mapping
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
日本語
English
Customer Support
R3 Blog
Facebook
Welcome to Gusuku Customine Document
>
Functions List
> ABS Function
Description
Usage Examples
ABS Function
Description
Return the absolute value of the argument.
Usage Examples
= abs (Number_1)