gusuku Customine docs
  • 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
        • 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 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 Excel by Query
        • Output PDF by Query
        • Output CSV by Query
        • Get User Profile
        • 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 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 Create Page
        • Run JavaScript
        • Lock Record Edit Page
        • Show Record Lock Status in Header
        • Generate Random String
        • Calculate String Bytes
        • Invoke Kintone Webhook
        • Invoke Scheduled Task
        • Define Value by Gusuku Environment
        • Define Password by Gusuku Environment
        • 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

Customer Support

R3 Blog

Facebook

Welcome to Gusuku Customine Document > DO > 'error check'

Customize

'error check'

In the error check category, There are actions that perform requirement check and/or various format checks.

  • 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