Skip to content
Contacts

View and filter records

Last updated: November 4, 2022

Applies to:

All products and plans

Each CRM object in HubSpot (contacts, companies, deals, tickets, and custom objects) has an index page that displays the object’s records. These index pages also include actions and filters you can use to customize and segment your records. Learn more about creating CRM records in HubSpot

Depending on your subscription, you can also filter and segment your call and payment records on their respective index pages. A payment record is created when a buyer makes a payment using a payment link, scheduling page, or a quote that is connected to the payments tool. A call record is created when you make a call through HubSpot's calling tool, using HubSpot's integration with Zoom, or using a third-party calling provider that supports Conversation Intelligence (CI).

Filter records and save views

For each individual object, you can view all records or segment records based on that object's properties. If you’re looking for more ways to filter records, learn about the differences between saved views and lists.

  • Navigate to your records:

    • Contacts: In your HubSpot account, navigate to Contacts > Contacts.

    • Companies: In your HubSpot account, navigate to Contacts > Companies.

    • Deals: In your HubSpot account, navigate to Sales > Deals.

    • Tickets: In your HubSpot account, navigate to Service > Tickets.

    • Payments: In your HubSpot account, navigate to Sales > Payments.
    • Calls: In your HubSpot account, navigate to Contacts > Calls.
    • Custom objects: In your HubSpot account, navigate to Contacts > [Custom object]. If your account has more than one custom object, hover over Custom Objects, then select the custom object you want to view.

  • Once you’re on an index page, you can also click the [Objects] dropdown menu in the top left to navigate to a different object.

  • If you’re viewing an object with pipelines (deals, tickets, or custom objects):

    • To toggle between a table view or board view, click the listView table and grid board icons next to the object name. The table view shows all records in a list, while board view shows records moving through the stages of a pipeline.

    • To show records that are in a specific pipeline, click the All pipelines dropdown menu next to the object name and select a pipeline.

  • When navigating to an object index page, you’ll be brought to the default view for the object. When you first navigate to the index page, the default view shows the entire list of object records, but you can edit your default view.

  • To locate a specific record, enter a search term in the search box in the top left of the view.
  • Hover over a record and click Preview to see record information on the right. To navigate to the full record, click the record name.
    • For payments, click the payment amount in the Gross amount column to open the payment record in the right panel. 
    • For calls, click the call title to open the recording review tool. Learn more about reviewing recordings

Please note: you review details about the payment in the right panel, but cannot edit any of the payment properties


  • To view deal stage amounts in a different currency (Starter, Professional, and Enterprise only), hover over the amounts at the bottom of the board, then click View in your preferred currency. Select your currency in the right panel, then click Save. You can hover over the Total and Weighted amounts to view in company currency or update your currency at any time.
  • To select a different saved view:

    • To access an open view, click the view's tab.

    • To open a saved view not shown as a tab, click +Add view, then select a view from the dropdown menu.

    • If you’re in board view, click the [Current view name] dropdown menu, then select a view.

  • To change the filters in the selected view, use the property dropdown menus at the top of the table or board:

    • To filter by a common default property, click one of the default property dropdown menus above the table (e.g., Contact owner, Create date, Last activity date, Lead status for contacts) and select filter criteria.

filter-records-updated

    • To filter by the object's other properties, click More filters. In the right panel:

      • Search for and select properties.

      • Set criteria for the selected properties, then click Apply filter. Learn more about setting criteria.

      • To select another property, click AND.

      • To remove a property, hover over the filter and click the delete delete icon.

      • Once you’re done, click the X in the top right corner.

    • To clear all filters from a view, click Clear All above the table.

  • To save the current filters and settings, in the top right, click Save view:

    • To update the filters and settings for the current view, click Save.

    • To save these filters and settings as a new view, click Save as new. In the dialog box, enter a view name, select a visibility setting, then click Save.

    • To reset the current view to its original saved filters, select Reset. This will remove any new filters you've applied to it.

save-view-dropdown

  • To export the records in the current view, click the Actions/Board actions dropdown menu and select Export view. Learn more about exporting records.

Once you’ve set filters, learn more about bulk editing records from an index page.

Select filter criteria

Before you select criteria for your view, learn how to choose filter options to segment your records. On each index page, you can only filter by that object’s properties.

To set your criteria in a view, click More filters, then in the right panel, select a property. Depending on the property's field type, choose an option to set criteria for that property:

  • contains exactly: enter a value. A record’s property value must contain the exact text entered to be included in the view. To search for a value with multiple words in a specific order, or including non-English characters, you'll need to enter your value in double quotes (e.g., "HubSpot knowledge base") to filter for an exact match.

Please note: non-alphanumeric characters included in criteria values are treated as delimiters, not as characters themselves. For example, filtering by HubSpot_knowledge_base> will search for values containing HubSpot, knowledge, and base, treating the _ and > as spaces. Even if you use double quotes, such as "HubSpot_knowledge_base>", it will search for values containing "HubSpot knowledge base" in that exact order, but not for values containing the other characters.

  • doesn’t contain exactly: enter a value. A record’s property value must not contain the exact text entered to be included in the view. Records with no value for the property will also be included.

  • is: for Date properties, select from predetermined options (e.g., Today, Yesterday, Last quarter). A record’s property value must be within the selected time frame to be included in the view.

  • is after: for Date picker properties, select a date on the calendar. A record’s property must have a date value that is after the selected date to be included in the view.

  • is any of: select multiple values. A record’s property must have at least one of these values to be included in the view.

  • is before: for Date picker properties, select a date on the calendar. A record’s property must have a date value that is before the selected date to be included in the view.

  • is between: for Date picker properties, select two dates on the calendar. A record’s property must have a date value that is equal to or after the first selected date and equal to or before the second selected date to be included in the view.

  • is (not) equal to: enter or select a value. A record’s property must (not) be equal to this value to be included in the view. If you’ve selected is not equal to, records with no value for the property will also be included.

  • is greater than: for Numerical properties, enter a number. A record’s property must have a value that is greater than the entered number value to be included in the view.

  • is greater than or equal to: for Numerical properties, enter a number. A record’s property must have a value that is greater than or equal to the entered number value to be included in the view.

filter-criteria-example
  • is known: all records with a value for the property will be included in the view.

  • is less than: for Numerical properties, enter a number. A record’s property must have a value that is less than the entered number value to be included in the view.

  • is less than or equal to: for Numerical properties, enter a number. A record’s property must have a value that is less than or equal to the entered number value to be included in the view.

  • is none of: select multiple values. A record's property must have a value that does not match any of the selected values to be included in the view. Records with no value for the property will also be included.

  • is unknown: all records that do not have a value for the property will be included in the view.

Once you're done, click Apply filter.

Customize a view's properties and board cards

To customize how properties appear in a table or board view:

  • In the table format, click the Actions/Board Actions dropdown menu, then select Edit columns. In the dialog box:

customize-table

    • On the left, select the properties you want to appear in the table.

    • On the right, use the drag handle to drag and drop properties to reorder the columns. Click x to remove a property.

    • Click Apply.

  • In the board format, click the Board Actions dropdown menu:
    • To sort cards based on the records' values for a specific property, select Sort. In the dialog box, select a property and the criteria to sort by (e.g., Most recent value for Create date, High to low values for Deal amount, etc.).
    • To edit the stages in your pipeline, select Edit stages. Learn more about customizing pipeline stages for deals, tickets, or custom objects.
    • To set a preferred currency for viewing deals, select Edit board (Starter, Professional, and Enterprise only). In the right panel, select a currency, then click Save. If you choose to view your preferred currency in the board, each deal stage's Total and Weighted amounts will be converted to your selected currency.
    • To customize how the cards appear, select Edit cards. In the right panel:

      • Choose the card style to customize the amount of information shown in each object card (Default or Compact).
      • Select or clear the checkbox to choose whether or not icons will appear for associated records.

edit-board-cards-1
      • Toggle the [Deal/ticket] activity information switch to choose whether or not to display next and last activity information. This applies only to open deals/tickets with active cards. Activities include notes, calls, tracked one-to-one emails, meetings, tasks, and chats.
      • Toggle the Inactive cards switch to set options for marking deals and tickets as inactive. The last activity will always appear on inactive cards.

      • Once you're done, click Save.

Learn how to customize the properties shown on board cards.

Edit, delete, or clone saved views

As you filter your records and save views, you can customize which views appear as tabs on object index pages, create new views, and set a default view for each object. You can also manage who can access a view, clone views, and delete unneeded views.
  • Navigate to your records:

    • Contacts: In your HubSpot account, navigate to Contacts > Contacts.

    • Companies: In your HubSpot account, navigate to Contacts > Companies.

    • Deals: In your HubSpot account, navigate to Sales > Deals.

    • Tickets: In your HubSpot account, navigate to Service > Tickets.

    • Payments: In your HubSpot account, navigate to Sales > Payments.
    • Calls: In your HubSpot account, navigate to Contacts > Calls.
    • Custom objects: In your HubSpot account, navigate to Contacts > [Custom object]. If your account has more than one custom object, hover over Custom Objects, then select the custom object you want to view.

  • To create a new view with no filters set, click + Add view to the right of your tabs, then click Create new view.

  • To open an existing saved view, click + Add view to the right of your tabs, then select a view from the dropdown menu. Once opened, tabs automatically remain pinned on the index page unless you close them.

drag-and-drop-views

  • To reorder your views, click and drag a tab. If you place a view in the left most position, it becomes your default view. This view will be the first tab each time you navigate to the index page.
  • To close a view, click the X on the view's tab. You can reopen the view from the Add view dropdown menu or the All views page.
  • To manage all saved views in your account, click All views.

all-views

  • On the All Views page, your own custom views are shown for the object you were viewing.
    • To filter by other objects, click the Object type dropdown menu and select the objects you want to include.
    • To filter by certain view owners, click the Owner dropdown menu and select the users whose views you want to include. Users with super admin permissions will be able to see all views, while other users can only see views they have access to.
    • To open a view on an index page, click the name of the view. On the index page, you can edit the view's filters.
    • To see a preview of the views sharing settings and filters, hover over the view and click Preview.
  •  
    • To edit or delete a view, hover over a view, then click the Actions dropdown menu. Select from the following:
      • Delete: delete the view. In the dialog box, click Delete to confirm. The view will be deleted, but the records included in the view will not be deleted.
      • Create report (Professional and Enterprise only): navigate to the report builder to create a report based on data from the view. You cannot create a report based on data in a calls or payments view. 
      • Clone: clone the view. In the dialog box, enter a name for the cloned view, then click Save. A new view will be created with the same filters.
      • Export: export the records in the view. Learn more about exporting records.
      • Manage sharing: update which users have access to the view. In the dialog box, select to make the view private, share it with your team, or share with all users in the account. Click Save to confirm.
      • Rename: update the name of the view. In the dialog box, enter a name, then click Save. 
views-management-page
    • To view default HubSpot views, click Standard views in the top right. In the right panel:
      • Click an object to expand the object's default views.
      • To open a view on an index page, click the name of the view.
      • Hover over a view and click Actions to clone or export the view. Depending on the view, you can also create a report (Professional and Enterprise only).
Was this article helpful?
This form is used for documentation feedback only. Learn how to get help with HubSpot.