Noloco
Ask the CommunityHire an ExpertLoginSign up
  • Noloco Overview
  • 🚀Quickstart
    • Start with your data
    • Start with AI
    • Start with a template
  • Data to App
    • Database Consolidation
  • App Settings
  • Components
    • Containers
    • Video
  • Templates
  • 🔗Data Sources
    • Data Overview
      • Setting a Collection's Primary Field
      • Syncing
    • Noloco Tables
      • Field Types
      • Relationships
      • Automatic Links
      • Rollup Fields
      • Lookup Fields
      • Formulas
      • Noloco AI
      • Import a file
    • Airtable
    • Google Sheets
    • SmartSuite
    • MySQL
    • PostgreSQL
    • REST APIs
    • HubSpot
    • Xano
  • 📄Pages
    • Collection views
      • Show collection record count
      • Empty State
    • Blank pages
    • iFrame embeds
    • External links
    • The Home Page
    • User Profile Page
    • Parent pages & folders
    • Page visibility rules
    • Cloning pages
    • Renaming pages
    • Hiding pages
    • Sidebar dividers
    • Tabs
  • 📂Collections
    • Adding collection views
    • Display
      • Rows
      • Cards & columns
      • Tables
      • Kanban boards
      • Calendar
      • Timeline
      • Gantt
      • Split-view
      • Charts
      • Maps
      • Pivot Table
      • Single record view
      • Grouping records
      • Record Colors
    • Filters
      • Logged in user
      • Relative Filters
      • Record values
    • Filter fields
    • Sort & limit
    • Row Action
    • Column Summaries
  • 📝Forms
    • Forms
      • Customizing Form Fields
      • Passing Linked Record Values to a Form
      • Dynamic Form Field Filters
      • E-Signature Fields
    • Public Forms
  • 📃Record Pages
    • Overview
    • Visibility Settings
    • Hidden Field Values
    • Record Comments
  • ✏️Field Formatting
    • Field visibility conditions
    • In-line editing
    • Conditional Highlight Colors
    • Dates & Time Zones
  • 📊Charts
    • Overview
  • 📂Data Management
    • Export Data
    • Import Data
  • 👥Users & Permissions
    • User Table
    • User Management
    • User Roles & Permissions
      • Record-level permissions
      • Field-level permissions
    • Open Sign Up
    • Offboarding Users
    • Testing as other users
  • ⏩Actions
    • Action buttons
      • Create records
      • Update records
      • Bulk actions
      • Barcode Scanner
      • Add a Comment Action
  • ⚡Workflows
    • Workflows
      • On-demand workflows
      • Comment Added Trigger
      • Watched Fields
      • Trigger webhooks
      • Send automated emails
      • For each item in a list...do...
      • Only continue if
      • Create a Record Action
      • Update a Record Action
      • Delete a Record Action
      • Deactivate a User Action
      • Reactivate a User Action
      • Send an Invitation Email Action
      • Add a comment to a record
      • Send a Push Notification
      • Ask Chat GPT Action
      • Summarize Text Action
      • Correct Grammar Action
      • Extract Keywords Action
      • Analyze Sentiment
      • Finish Text Action
      • Send a message to a Slack Channel
      • Send a message to a Slack User
      • Generate a PDF with DocsAutomator
  • 🔔Notifications
    • Notifications
    • Notification Preferences
  • 📑API Documentation
    • API Overview
      • Fetching Records
      • Fetching a Record
      • Creating a Record
      • Update a Record
      • Deleting a record
  • ⚙️Settings
    • General Settings
      • Live Mode
      • Custom Logos
    • Theme & Design
    • Progressive web apps
    • Navigation Settings
    • Spaces
    • Email Settings
    • Custom Code
    • Custom Domain
    • Login & Signup
      • Sign in Options
      • Single Sign On
      • 2FA - Two Factor Authentication
      • Client Portal User Add-On
    • Login Screen
    • User Lists
    • Integrations & API Keys
    • Billing & Usage
    • Support
    • Publishing
      • App Version History
  • 🔄Integrations
    • Zapier
    • Make (Integromat)
    • Sign in With Google
    • Intercom
    • SMTP Emails
    • Documint
  • ⚙️Account
    • Workspaces
    • Pricing
      • Client Portal Add-on (Legacy)
    • Transferring an App
    • Onboarding Call Preparation
Powered by GitBook
On this page
  • How to filter data in collection views based on record values?
  • How to use multiple filters on collection views?
  1. Collections
  2. Filters

Record values

Learn how to filter collection views based on record values

PreviousRelative FiltersNextFilter fields

Last updated 7 months ago

By default, collection views will show all records in a particular collection - but often we don't need to see all the data at once.

With Noloco, you're able to add filters to collection views to determine that records should only be shown that match certain criteria based on the relevant field values.

In this video, learn how to:

  • Add filters based on a single-option field

  • Filter records based on a date field (relative to today's date)

  • Filter records based on a price (number) field

  • Use multiple filters together with 'And' logic

  • Use an 'Or' filter group to show records that meet any of the filter criteria

  • Combine 'And' conditions within an 'Or' filter group

How to filter data in collection views based on record values?

Filters allows you to exclude items from your collection views based on different criteria. For example, in the app below we add a filter that only shows Properties that have a status of 'Active'.

The filter is created by checking certain criteria on a field in the relevant data collection. In the above example, we have a list of Properties synced from an Airtable base. Some of these properties are on the market (i.e. 'active') whereas some are not.

We have a single-select field in our Properties table that informs us of the Status of the Property with a range of values in that single-select field stored in the Status field from Active, Pending, Under Contract, Closed, Cancelled and Not Listed.

In Noloco, we select the field we want to filter on and then we choose the criteria by which we are filtering.

The field selected is Status and the criteria is is equal to Active

Filters enable you to display different data from the same collection in different pages in your app. For example, the app below shows data from the Properties collection in several different views but each one is filtered to show a list of properties that meet different criteria.

  • Properties Board (All properties)

  • Active Properties (Filtered to only show properties on the market)

There are a few different ways you can create multiple views of the same collection.

Once you have created your additional sidebar menu item, you can rename it appropriately, apply your filter(s) and you now have a new way to present data to your users from the relevant collection.

How to use multiple filters on collection views?

You can use multiple filters on a list with AND + OR logic. In the following example, we add two filters to our list of properties to show only records that have a status of either 'Active' or 'Pending'.

  • Status is equal to 'Active'

  • OR

  • Status is equal to 'Pending'

My Properties (Filtered to only show properties related to the )

Either by to the sidebar menu again or by an existing collection view.

📂
Logged in User
adding the collection
cloning
Click to expand
Click to expand
Multiple sidebar menu items for Properties
In edit mode - add new sidebar menu item
In edit mode - clone a view