• 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 and Deleting Data in Apps
      • 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
        • Actions to be Taken When You Failed to Bulk Register/Update Records
        • Canceling the Process of Creating/Updating Records in Bulk
    • Customizing the App Settings
      • Opening the App Settings Page
      • Changing the Name, Icon, and Description of Your App
      • Configuring Forms
        • Configuring Forms
        • 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
      • Setting Notifications
        • What Can Be Done with the Notifications Feature
        • 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
    • 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
    • Guest Space
      • Adding Guest Spaces
      • Inviting Guests
      • Guest Actions
        • Guest Action: Joining the Invited Guest Space
        • 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
      • Writing Comments to Your Profile
      • Users Who Can View Your Post
      • Following the Profile of Other Users
      • 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
    • 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
    • Q&A
      • What Is a Record?
      • What Is "Like"?
      • Which Fields Can Be Used for Sorting?
      • I Cannot Receive E-mail Notifications
    • Account Settings
  • 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
      • Deleting Apps Through 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
    • Customizing the Portal
      • Customizing the Portal
      • Using Announcements
    • Customizing the Whole Kintone
      • Setting the Activated Features
      • Enabling E-mail Notifications
      • Changing the Default Setting for the View on Mobile Browsers
      • Plug-Ins
        • Install the Plug-In on Kintone
      • Customizing the Whole Kintone with JavaScript and CSS
      • Changing the Header Color
    • Backup
      • Backing up Records
    • Audit Logs and the Import/Export of Data
      • List of Data Types That Can Be Imported or Exported
      • Audit Log Checking and the Log Lists
    • Q&A
      • When a user is deleted, is the data of that user also deleted?
      • What Can I Do with "Send REST API notifications by e-mail"?
      • What Should I Note When Working with a Large Amount of Data?
    • Limits
      • List of Limits
  • Usage Guide
    • Migrating an App to Another Kintone
    • Displaying Your Schedule in Kintone
    • Number of Users/Plan Applied to the Free Trial
    • Hiding the Page Name or the Date of the Header/Footer When Printing
    • Selecting Character Encoding
    • Calculating the Number of Days or Weeks
    • Using Thousands Separators
    • What to Do When Users Forget Their Passwords
    • Unable to Access Due To Client Certificate Error
    • Checking Disk Capacity and Current Disk Usage
    • Reducing the Disk Usage
  • 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
All brand names and product names appearing on this site are registered trademarks or trademarks of Cybozu.