View and filter records on an object index page

Each CRM object in HubSpot (contacts, companies, deals, and tickets) has an index page that displays the object’s records. Depending on your subscription, you can also filter and segment your custom object, call, and payment records on their respective index pages.

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. 

View records and access saved 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.

• 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. If you're a super admin, you can also set the default view for new users.

• To locate a specific record, enter a search term in the search box in the top left of the view.
• To change the order of your records, you can sort them based on a property. Click the property's column header to sort by that property. Learn how to customize which properties appear as columns.
• In board view, to hide the records in a stage/status, click the left left carat icon at the top of the column. If a column is already collapsed, click the right right carat icon to expand it.

• 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 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 export the records in the current view, click the Export in the top right of the table. Learn more about exporting records.
• To access a record, click the record name. You can also hover a record and click Preview to see record information on the right panel.

Filter records and save views

For each object, you can 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 or a specific view.

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

  • To filter by a common default property, click 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.

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

    • If you have quick filters selected, they'll appear at the top. Click Hide to remove them from the panel. 

• • • Click +Add filter to set up a new filter, then search for and select the property you want to filter by.

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

    • To select another property, click AND or OR. When you set a filter with AND, records must meet all of the criteria in the filter group in order to be included in the view. When you select OR, the records must meet the criteria in at least one filter group to be included in the view.

Please note: saved views using an OR filter cannot be viewed on mobile.

• • • To duplicate a group of filters, click Clone above the group. When you clone a group, the new duplicate group will follow OR logic.

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

    • To remove a group of filters, click Delete above the group.

• • • 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.

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 All 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.

• 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 Edit columns in the top right of the table. In the dialog box:

• • 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.

• • • 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

• Navigate to your records.

• 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.

• 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.

• 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 retrieve all views regardless of the object or owner, clear all checkboxes in the dropdown menus.

• • 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 view 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. 

• • 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).
  • If you’re a super admin, click the Default views tab to set up an object’s default view order for new users.