• 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
      • Opening the App Settings Page
      • Changing the Name, Icon, and Description of Your App
      • 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
        • TIPS: Viewing Records That Are Assigned to You
      • 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
        • 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
        • Setting Up Notifications with Conditions of Actions on Apps (General Notifications)
        • Setting Notifications to Be Sent When Records Meet a Certain Condition (Per Record Notifications Settings)
        • Setting Notifications to Be Sent When an Options Field Is Updated
        • Setting Reminder Notifications with Date and Time Conditions (Reminder Notification Settings)
      • Adding Plug-Ins to an App
      • Customizing an App with JavaScript and CSS
      • Generating API Tokens
      • Setting Webhook
        • Setting Webhook
        • Webhook Execution Log
      • 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
      • Previewing Apps
      • Downloading App as Template
    • Utilizing Data That Is Added in Apps
      • Filtering Records to Be Displayed
      • Displaying Records Which Meet Multiple Conditions
      • Exporting Data to a File
      • Canceling the Data Export Process
      • Posting Comments to Records
      • Copying Record URLs
      • Printing Records
      • Summarizing Data
        • Summarizing
        • Retrieving Embed Tags for Summarized Results
        • Exporting Summarized Results to a File
        • Example of Setting Sum Conditions: Categorizing and Summing Up the Amount of Product Sales by Product Category and then by Product Name
      • 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
    • People
      • Posting Comments to Your People
      • Users Who Can View Your Post
      • Follow Other User's People
      • Sending Messages to Other Users
    • 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
        • Troubleshooting for Access from iOS Devices
        • Allowing/Disallowing Notifications on Mobile Devices (for iOS)
      • Android
        • Using Kintone on Chrome for Android
        • Using the Mobile App for Android
        • Troubleshooting for Access from Android Devices
        • 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
      • What to Do When a Mobile Device Running Kintone Is Lost
    • 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
    • Useful Operations
      • Specifying Comment Recipients
      • Adding Apps to Favorites
      • Bookmarking Pages
      • Switching Between 12-Hour/24-Hour Clock Display
      • Attaching Files by Drag and Drop
      • Working with Kintone Using Keyboard Shortcuts
      • Displaying a Default Contact Name When Creating a Record
  • Administrator Help
    • Invitation
      • Inviting Team Members During Your First Login
      • Invite Team Members While You Are in Trial Period
    • Accessing the System Administration Screen
      • Opening the System Administration Screen
    • 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 an App Template File
        • Creating a Template from an App
        • Exporting App Templates to a File
    • 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
      • Managing Thread Actions
        • Accessing the Thread Action Management Screen
    • Managing Guests
      • Managing Guests
      • Enabling 2-Step Verification Authentication for Guests
    • 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 Plug-ins to the System Administration
      • Customizing the Whole Kintone with JavaScript and CSS
      • Changing the Header Color
    • 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
      • Displaying Date/Day of Week/Time
        • Displaying the Date That Is a Month (30 Days) from Today
      • Various Calculations
        • Calculating the Number of Days or Weeks
      • Data Display Format
        • Using Thousands Separators
      • Tips on Utilizing Tables
        • Counting the Number of Table Rows
      • Tips on Adding/Displaying Records
        • Managing Your Schedule in Kintone
        • Displaying Multiple Fields in the Title Field
      • How to Summarize Data
        • 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 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 Is "Like"?
      • Symbols That Cannot Be Used for Search or Filtering
      • When Using Kintone, An Error Message Is Displayed to Ask for Log In
      • Specifying Comment Recipients
      • Bookmarking Pages
    • FAQ's Related to Actions on an App
      • Checking App Creators
      • Steps to Restore Accidentally Deleted Apps
      • Adding Apps to Favorites
      • Copying an App Including It's Records
      • When Fields Are Not Displayed in the Order You Set in the Record Selection Screen of the Lookup Settings
    • Troubleshooting Problems Related to Actions on an App
      • An Error Message Is Displayed and Unable to Delete an App
    • FAQs Regarding Processing Records
      • Can I Save a Filtered Record View?
      • Can I Change/Delete the "(All)" View?
      • Can I Renumber Records from 1?
      • Can I Set Access Permissions for Views?
      • Which Fields Can Be Used for Sorting?
      • How Can I Specify Character Encoding When Exporting Data to a File?
      • What Should I Note When Working with a Large Amount of Data?
      • Can I Open Records When Comments and History Are Closed?
    • Troubles That Might Occur When Processing Records
      • When the Message "Cannot save the record because of error(s) in the following input data." is Displayed
      • Unable to Save Records with "(Cannot display the item name)" Error (For App Administrators)
    • 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
    • FAQs/Troubleshooting Topics Regarding Notifications
      • When You Cannot Receive Notifications
      • When You Cannot Receive E-mail Notifications
      • What Can I Do with "Send REST API Notifications by E-mail"?
    • 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
    • FAQs Regarding Registered Information and User Details
      • When a User Is Deleted, Will That User's Data Be Also Deleted?
    • FAQs Regarding Print
      • 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

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.