Skip to main content

Views, filters, sorts & groups

A view shows the records of a database app the way you need them. Learn about Table, Board, and List layouts, team and private views, and how filters, sorts, and groups fit in.

Written by Leo

A view is a saved way of looking at the records of a database app. It stores a layout and, if you like, filters, sorts, and groups. The records stay the same in every view. Views are meant to help you and your team see just what matters, for example open tasks for you, or all properties by city.

You can use views for many things, including:

  • Showing a team's tasks on a board, grouped by status.

  • Keeping a private table of the leads you follow up on this week.

The Properties database app with the Team views list on the left, the Table view open, and the toolbar with the filter count 8 of 8 and the sort and search icons

Note:

  • A view changes the look, not the data. Filtering or grouping a view never removes records from the database app.

  • Changes stay unsaved until you save them. The view shows Unsaved view and a Save button. Learn more about saving views →

  • Team views need Full access or Can share. Anyone who can open the database app can create private views.

Who can use views?

  • Views are available on all plans: Free, Plus, and Premium. Team and private views, filters, sorts, and groups work on every plan.

  • To create or change a team view, you need Full access or Can share for the database app. Private views are only visible to you. Learn more about sharing and permissions →

View layouts

When you create a view, you choose its layout:

The Properties records in a Board view with one column per investment stage and a cover image on each card

Team views and private views

The view list on the left of the database app has two sections:

  • Team views: visible to all members who can open the database.

  • Private views: only visible to you. This section shows up once you have a private view.

The view list with the Team views section, a table view, and a board view with its groups and record counts

You can turn a private view into a team view with Make a team view in the view's settings, and back with Make a private view. Learn more about creating and managing views →

Filter, sort, and group

A table view filtered to the investment stage Renovation, with 1 filter / 2 of 8 on the Filter button, Unsaved view, and the Save button

FAQs

Can I add a calendar or a timeline view?

No, not yet. You can create views with the layouts Table, Board, and List.

Will a filter delete records?

No. A filter only hides records from the view. They're still in the database app and show up in other views.

Can everyone in my workspace see my private view?

No. A private view is only visible to you.

Can I hide the view list?

Yes. Select the view name in the toolbar to show or hide the view list.

Do views change how a record looks?

No. How a single record looks is set by its record layout. Learn more about record layouts →

Can I show my records as a chart?

Yes, in a dashboard app. Views show records as Table, Board, or List. For a chart, add a report to a dashboard app, choose the database app as Source, and pick a View to decide which records count. Learn more about reports →

Still have more questions? Find answers and get help from community experts in the Tape community →.

Did this answer your question?