Kintone
Help
English
  • 日本語
  • User Help
    • Learn the Basics of Kintone
      • What is Kintone?
      • How to View the Portal
      • Basics of App Features
      • Basics of Space Features
      • How to view People
    • Creating and Deleting Apps
      • Various Ways to Create Apps
      • Creating an App from the Marketplace
      • Creating an App from a Template
      • Creating an App from Scratch
      • Creating a New App by Duplicating an Existing App (Copying an App)
      • Integrating Data Across Apps
      • Resuming App Creation
      • Deleting an App
      • Create Apps by Importing Files
        • Creating an App from an Excel File
        • Solutions for Handling Excel Files That Exceed Size Limitation of 1 MB, 1,000 Records, and 100 Columns
        • Creating an App from a CSV File
        • Field Type Criteria in Creating Apps from Files
        • Troubleshooting When Creating an App from an Excel or CSV File
        • Creating an App by Importing a Template File
    • Adding/Deleting Records
      • Adding Records
      • Duplicating Records
      • Editing Records
      • Editing Records on the Record List Screen
      • Deleting Records
      • Deleting Records in Bulk
      • Creating and Updating Records in Bulk
        • Creating and Updating Records in Bulk
        • Create Records in Bulk: Creating a File
        • Update Records in Bulk: Editing a File
        • Supported Formats for Each Field Type
        • Create/Update Records in Bulk: Importing a File
        • Creating and Updating Records Including Tables in Bulk
        • Creating a File to Be Used to Import Data to a Table
        • Actions to be Taken When You Failed to Bulk Register/Update Records
        • Canceling the Process of Creating/Updating Records in Bulk
    • App Settings
      • App Setting Screen
      • Changing an App Name
      • Configuring Forms
        • Configuring Forms
        • Duplicating/Deleting Fields
        • Fields Available in Kintone
          • Label
          • Text
          • Rich Text
          • Text Area
          • Number
          • Calculated
          • Radio Button
          • Check Box
          • Multi-choice
          • Drop-down
          • Date
          • Time
          • Date and Time
          • Attachment
          • Link
          • User Selection
          • Department Selection
          • Group Selection
          • Related Records
          • Lookup
          • Space
          • Border
          • Field group
          • Table
          • Record Number
          • Created by
          • Created Datetime
          • Updated by
          • Updated Datetime
          • Field Entry Limits
        • Adding Tables into Forms
        • Setting Formulas
          • Basic Usage of Formulas
          • Fields That Can Be Referred by Formulas
          • List of Operators and Functions
          • SUM Function: Sum Calculation
          • & Operator: Concatenating Strings
          • ROUND Function: Round Off, Round Down, or Round Up Numbers
          • Setting the Round Off, Round Down, or Round Up
          • IF Function: Changing the Value to Display Depending on the Condition
          • AND, OR, NOT Functions: Combining Conditions
          • DATE_FORMAT Function: Displaying Date and Time Using Formulas
          • DATE_FORMAT Function: Usage Example
          • Errors Which Are Displayed for Formulas
          • What Is a Field Code?
        • Using Lookup to Retrieve Data from Other Apps
          • What Is Lookup?
          • Setting Lookup
          • Using Lookup
          • Clearing Lookup Settings
          • Fields That Can Be Specified for "Field Mappings"
        • Listing Related Records
          • What Is Related Records?
          • Setting Related Records
          • Fields that Can Be Specified for the "Fetch Criteria" Setting in Related Records
      • Setting Record Views
        • What Is a View?
        • Configuring Views
        • Changing the Number of Records to Be Listed in a View
        • Duplicating Views
        • Modifying or Deleting Views
        • Sorting Views
        • Changing the Default View
        • Changing View Column Width for Each User
        • Saving Column Widths of the View in App Settings
      • Creating Graphs
        • What Is a Graph?
        • Sum Feature and Graph Feature
        • Creating Graphs
        • Duplicating Graphs
        • Modifying or Deleting Graphs
        • Sorting Graphs
        • What Is a Periodic Report?
        • Chart Types and Their Usage
        • Example Graph Setting: Creating a Graph by Categorizing the Amount of Product Sales by Product Category and then by Product Name
        • Example Graph Setting: Summing Up the Amount of Sales for the Current Month
      • General Settings
        • Changing App Groups to Which Apps Belong
        • Setting an Icon and a Description of an App
        • Changing the Color Theme of an App
      • Setting Process Management
        • What Can Be Done with Process Management
        • About Status, Action, and Assignee
        • Designing Process Management
        • Basic Usage of Process Management
        • Example Settings of Request Workflows
        • Example of Auto Fill of an Approver
        • TIPS: Useful Settings When Used with Process Management
        • Notes on Changing the Process Management Settings
      • App Notification Settings
        • What Can Be Done with App Notification Settings
        • General Notifications: Setting Up Notifications with Conditions of Actions on Apps
        • Per Record Notifications: Setting Notifications to Be Sent When Records Meet a Certain Condition
        • Per Record Notifications: Setting Notifications to Be Sent When an Options Field Is Updated
        • Reminder Notifications: Setting Reminder Notifications with Date and Time Conditions
        • TIPS: Recipients That Can Be Selected Using the Add a Field of the Form Option
      • Adding Plug-Ins to an App
      • Customizing an App with JavaScript and CSS
      • Generating API Tokens
      • Setting Webhook
        • Setting Webhook
        • Checking Webhook Execution Logs
      • Managing Permissions
        • Actions Available to Users in Apps
        • Setting App Permissions
        • Setting Record Permissions
        • Setting Permission for Fields
        • Example Permission Setting: Prevent Editing of the Record Whose Status Is "Completed"
        • Example Permission Setting: Allowing Only the User Who Created a Record to View, Edit, Delete the Record
        • Example Permission Setting: Allowing Only the Users in Human Resources to Edit and Delete Records, and the Other Users Only to View Records
      • Setting Categories
        • What Can Be Done with the Category Feature
        • Setting Categories
      • App Localization Settings
      • Setting the Record Title
      • Misc Settings
        • Setting the Thumbnail Image Display
        • Setting an App Code
        • Disabling Comments
        • Setting the Significant Digits of Numbers and the Rounding Method
        • Changing the First Month of the Fiscal Year
      • Setting App Actions
        • What Can Be Done with App Actions
        • Configuring App Actions
        • Combinations of Field Types Acceptable for App Action
        • Creating an Action to Duplicate a Record in the Same App
      • Previewing Apps
      • Downloading App as Template
    • Utilizing Data That Is Added in Apps
      • Filtering Records to Display in a View
      • Displaying Records Which Meet Multiple Conditions
      • Exporting Data to a File
      • Canceling the Data Export Process
      • Posting Comments to Records
      • Clicking Like for Comments
      • Copying Record URLs
      • Printing Records
      • Summarizing Data
        • Summarizing
        • Retrieving Embed Tags for Summarized Results
        • Exporting Summarized Results to a File
      • History
        • Checking Change History of Records/Reverting Records to Previous Version
        • Disabling the Logging Feature for Change History
    • Space
      • Actions Available to Users in Spaces
      • What Is an In-Space App?
      • What Is Related App & Space?
      • Actions in Spaces
        • Creating Spaces
        • Configuring Spaces
        • Adding or Deleting Space Members
        • Joining or Leaving a Space
        • Creating Threads
        • Deleting Threads
        • Following Threads
        • Unfollowing Threads
        • Posting Comments to Threads
        • Creating Apps in Spaces
        • Attaching Apps to Spaces or Threads
        • Deleting Spaces
      • Setting Thread Actions
        • What Can Be Done with Thread Action
        • Creating Thread Actions
    • Guest Space
      • Adding Guest Spaces
      • Inviting Guests
      • Guest Actions
        • Guest Action:Guest User Login Process
        • Guest Action: Linking the Guest Account to Your Kintone Account
        • Guest Action: Editing Profile
        • Guest Action: Changing the E-mail Address
        • Guest Action: Rejoining the Space You Previously Left
    • People
      • Posting Comments to Your People
      • Users Who Can View Your Post
      • Follow Other User's People
    • Message
      • Sending Messages to Other Users
    • Mobile
      • Using Kintone on Mobile Devices
      • iOS
        • Using Kintone on Safari for iOS
        • Using the Mobile App for iOS
        • Allowing/Disallowing Notifications on Mobile Devices (for iOS)
      • Android
        • Using Kintone on Chrome for Android
        • Using the Mobile App for Android
        • Allowing/Disallowing Notifications on Mobile Devices (for Android)
      • Using the Desktop View on Mobile Devices
      • How to Use Mobile Version Screens
      • Understanding Notifications on Mobile Devices
    • Notifications
      • Checking Notifications
      • When and to Whom Notifications Are Sent
      • The Difference Between "To Me" Notifications and Other Notifications
      • Marking Read Notifications as Unread
      • Setting E-Mail Notifications
      • E-mail Notification Subjects
    • Search for Data
      • Searching Data
      • Searchable File Formats
    • Integrating External Services with Kintone
      • Integrating Microsoft Power Automate with Kintone
      • Integrating Slack with Kintone
    • Personal Settings/Account Settings
      • Personal Settings
      • Account Settings
  • Administrator Help
    • Invitation
      • Inviting Team Members During Your First Login
      • Invite Team Members While You Are in Trial Period
    • Opening the System Administration/Kintone Users & System Administration
      • Opening the System Administration Screen
      • Opening the Kintone Users & System Administration
    • Managing Apps
      • Accessing the App Management Screen
      • Checking Your App License Usage
      • Checking/Downloading App List in the App Management Screen
      • Deleting Apps from the App Management Screen
      • Restoring Deleted Apps
      • Managing App Templates
        • What Is an App Template?
        • Settings That Are Not Included in App Templates
        • Creating a Template from an App and Registering It in Kintone
        • Exporting an App Template Which Is Registered in Kintone to a File
        • Registering an App Template File in Kintone
    • Managing Spaces
      • Managing Spaces
      • Deleting Spaces through Space Management Screen
      • Restoring Deleted Spaces
      • Managing Space Templates
        • What Is a Space Template?
        • Data That Is Included or Excluded from Space Templates
        • Creating a Template from a Space
        • Importing a Space Template from a File
        • Exporting Space Templates to a File
      • Opening the Tread Actions Management Screen
    • Managing Guests
      • Enabling 2-Step Verification Authentication for Guests
      • Managing Guests
      • How to Check the Name and Status of Guest Users
      • How to Check the Number of Guest User Accounts
      • Checking the Required Number of Guest Account Licenses
    • Managing Permissions
      • Permissions for Main Actions on Portal
      • Types of Kintone Administrators
      • Configuring Permissions in Kintone Users & System Administration
        • Configuring Groups (or Roles)
        • Restricting Visibility of Departments and User Details Across Different Top-Level Departments
      • Configuring Permissions in Kintone System Administration
        • Setting Kintone System Administrators
        • Changing Permissions for Creating Apps
        • Changing Permissions for Creating Spaces
        • Changing Permissions for Creating Guest Spaces
        • Managing App Groups
          • What is an App Group?
          • Adding an App Group
          • Configuring the Permissions of an App Group
          • Changing the Default App Group
          • Deleting an App Group
    • Editing Portals
      • Setting/Changing the Portal
      • Using Announcements
    • Setting Kintone
      • Setting the Activated Features
      • Enabling E-Mail Notifications by Administrators
      • Changing the Default Setting for the View on Mobile Browsers
      • Plug-Ins
        • Adding/Deleting Plug-Ins (System Administration)
      • Customizing the Whole Kintone with JavaScript and CSS
      • Changing the Header Color
      • Changing the Header Logo
      • Customizing the Login Page
    • Backup
      • Backing up Records
    • Audit Logs and the Import/Export of Data
      • Data Types That Can Be Imported or Exported
      • Audit Log Checking and the Log Lists
    • Limits
      • List of Limits
  • Usage Guide
    • Purposes
      • Managing Apps
        • Managing Apps Using a CSV File Containing App List
      • Integrating Apps
      • Various Calculations
        • Calculating the Number of Days or Weeks
        • Displaying the Date That Is a Month (30 Days) from Today
        • Calculating N Years Later after the Date/Datetime Field
      • Tips on Utilizing Tables
        • Counting the Number of Table Rows
      • Tips on Adding/Displaying Records
        • Managing Your Schedule in Kintone
        • Displaying a Default Contact Name When Creating a Record
        • Viewing Records That Are Assigned to You
        • Using Thousands Separators
        • Displaying Multiple Fields in the Title Field
      • Utilizing the Filter Feature and the Sum Feature
        • Filtering Records for the Next Month
        • Summarizing the Amount of Sales for Current Month
        • Summarizing and Creating Graphs of Monthly Order Amount
        • Categorizing and Summarizing the Amount of Product Sales by Product Category and then by Product Name
      • Tips on Migrating Apps or Data
        • Migrating Information on Record Creator When Migrating Data to Another App Using a CSV File
        • Migrating an App to Another Kintone
  • Q&A/Troubleshooting
    • Problems Related to Log in
      • When Users Forget Their Passwords
      • Unable to Access Due to Client Certificate Error
    • FAQs/Troubleshooting Topics Regarding General Actions in Kintone
      • What Are Kintone System Administrators' Tasks?
      • Symbols That Cannot Be Used for Search or Filtering
      • Unable to Find the Searched Data
      • When Using Kintone, An Error Message Is Displayed to Ask For Log In
      • Specifying Comment Recipients
      • In What Condition User/Department/Group Is Displayed As Mention Candidate?
      • Bookmarking Pages
      • Switching Between 12-Hour/24-Hour Clock Display
      • How To Attach Files by Drag and Drop
      • How to Work with Kintone Using Keyboard Shortcuts
      • Is It Possible to Open a Linked Page in a New Tab or a New Window?
      • Is It Possible to Get Backups?
      • Deactivating Space, Guest Space, and People
      • Is It Possible to Display the Contents in Other Languages?
      • Is It Possible for Non-administrator Users to Check Users Who Belong to a Specific Department/Group?
    • FAQs Related to Actions on Apps/Records
      • What Are App Administrators' Tasks?
      • Is It Possible to Arbitrarily Sort Apps in the Portal?
      • Adding Apps to Favorites
      • Is It Possible That Multiple Users Edit the Same Record at the Same Time?
      • Can I Set Access Permissions for Views?
      • Can I Set Access Permissions for Categories?
      • Can I Expand/Collapse the Category Tree?
      • Is It Possible to Set Permissions for Fields in Bulk?
      • Maximum Number of Characters for an App Description
      • Checking App Creators
      • Retrieving Data from Other Apps
      • When Fields Are Not Displayed in the Order You Set in the Record Selection Screen of the Lookup Settings
      • Can I Import Values from a File to a Lookup Field?
      • Is It Possible to Search Data Using Partially Matched Keyword When Retrieving Data by Lookup?
      • Can I Bulk Update Data Copied through Lookup, Because I Changed Values in the Datasource App?
      • Displaying Data of Other Apps in a Form
      • Steps to Restore Accidentally Deleted Apps
      • Is It Possible to Restore Bulk Deleted Multiple Apps at One Time?
      • Is It Possible to Restore Accidentally Deleted Fields?
      • Is It Possible to Check Who Deleted an App?
      • Is It Possible to Check Who Deleted a Record?
      • What Should I Note When Working with a Large Amount of Data?
      • Copying an App Including It's Records
      • How Can I Specify Character Encoding When Exporting Data to a File?
      • What Is the Difference Between Next Week and Following Week When Specifying Condition for the Date or Date and Time Field?
      • Is It Possible to Display a Day of the Week in a Date Field?
      • Is It Possible to Enter the Desired Time in the Time Field or the Date and Time Field?
      • Can I Open Records When Comments and History Are Closed?
      • Setting a Drop-down Field as the Title Field
      • Setting a Date Field as the Title Field
      • Can I Renumber Records from 1?
      • Can I Change/Delete the "(All)" View?
      • Is It Possible to Display a Table in a View?
      • Can I Save a Filtered Record View?
      • Which Fields Can Be Used for Sorting?
      • Is It Possible to Place an Existing App in a Space?
      • Setting Default Filter Condition Value/Sort by Value for Records
      • Summarizing Registered Values or Record Counts
      • Is There Any Feature or Action That Cannot Be Used for Fields in Tables?
      • When Importing a CSV File to Update Data, Is It Possible to Specify a Field Other Than the Record number Field as the Key to Bulk Update?
      • Is It Possible to Toggle the Display of Action Buttons Based on Record Values?
      • What Happens When Clicking the Plus Sign in Calendar View?
    • Troubles Related to Operations on Apps/Records
      • An Error Message Is Displayed and Unable to Delete an App
      • An Error Message Is Displayed and Unable to Restore an App
      • When You Receive "Cannot save the record because of error(s) in the following input data." Message
      • Unable to Save Records with "(Cannot display the item name)" Error (For App Administrators)
      • Lookup Field Is Grayed Out and Cannot Be Used
      • Renaming of Apps or Fields Does Not Take Effect
      • When Trying to Change Permission for App, an Error Is Displayed Indicating That There Is No User Who Can Manage the App
      • Edit/Delete Button (Icon) Is Displayed in a Record View Even When a User Does Not Have Edit/Delete Permission for Records
    • FAQs/Troubleshooting Topics Regarding Calculation
      • Calculated Result Is Not Displayed
      • Unable to Save Formula Due To an Error
      • Result of Time Calculation Is Not Correct
      • Setting Zero as the Number of Decimal Places to Round Causes Calculation Error
      • Is It Possible To Round Off Decimal Numbers in Calculated Result?
    • FAQs/Troubleshooting Topics Regarding Mobile Access
      • What to Do When Users' Mobile Devices Are Lost
      • What to Do When Client Certificates on Users' Mobile Devices Expire
      • Troubleshooting for Access from iOS Devices
      • Troubleshooting for Access from Android Devices
      • Cannot Receive Push Notifications While in Doze Mode in Android 6 or Later Devices
      • Cannot Receive Push Notifications in My Mobile App
    • FAQs/Troubleshooting Topics Regarding Notifications
      • When You Cannot Receive Notifications
      • When You Cannot Receive E-mail Notifications
      • Is It Possible to Specify To/CC as Recipients of E-mail Notifications?
      • Only One E-mail Notification Might Be Received When Setting the Same E-mail Address for Multiple Users
      • What Can I Do with "Send REST API Notifications by E-mail"?
    • FAQs Regarding Actions in Spaces
      • What Are Space Administrators' Tasks?
      • Where Can I Check the Number of Spaces/Guest Spaces?
    • Troubles That Might Occur When Performing Actions in Space
      • An Error Message Is Displayed and Unable to Restore a Space
    • FAQs Regarding Guest Spaces
      • Checking the Guest User's Status of Use
      • Guest User's Trial/Required/Not Required License
      • Checking the Guest User's Trial Expiration Date
      • What Happens When Guest User's 30-Day Trial Expires?
      • Deactivating Guest Users
      • Granting Access Permissions for Apps in Guest Spaces
      • Is It Possible to Use Departments or Groups in Apps in Guest Spaces?
      • Unable to Create Guest Spaces
      • What Is Link Account?
    • Kintone Storage
      • How to Check Kintone Storage and Current Usage
      • When Current Usage Exceeds the Limit
      • Increasing Kintone Storage
      • Reducing the Current Usage
      • Terminating the Purchased Storage
    • FAQs Regarding Registered Information and User Details
      • When a User Is Deleted, Will That User's Data Be Also Deleted?
      • Prohibiting Users from Changing Profiles
      • Viewing Users Who Are Using Kintone in a List
    • FAQs Regarding Print
      • Is It Possible To Print Record Lists?
      • Hiding the Page Name or the Date of the Header/Footer When Printing
  • Kintone Glossary
    • API Token
    • Kintone Users & System Administrator
    • JavaScript and CSS Customization
    • Kintone Mobile
    • Kintone System Administrator
    • Recipient
    • Mentions
    • App
    • App Action
    • App Group
    • App Code
    • App Administrator
    • Favorites
    • Related App & Space
    • Related Records
    • Graph
    • Guest Space
    • Apps in a Guest Space
    • Guest User
    • Comment
    • Subdomain
    • Filter
    • Summarize
    • Space
    • In-Space App
    • Thread
    • Thread Action
    • Notifications
    • Periodic Report
    • Table
    • People
    • Field
    • Field Code
    • Form
    • Bookmark
    • Plug-Ins
    • Process Management
    • Header
    • History
    • Portal
    • Message
    • Reminder
    • Lookup
    • Record
    • View
    • Record Details Screen
  • Kintone Help
  • Kintone Glossary
  • Filter

Filter

A filter provides field conditions to limit records to be displayed in a view.
Filtering Records to Be Displayed

Was this information helpful?

In this article

  • Kintone
  • Trademarks
  • Privacy Policy
  • about
The names of the services and products used herein are the registered trademarks or trademarks of their respective companies.