← Blog

Guide

Filters for my team

Use the My teams value in filters and quick filters, so one saved view shows each person the records of their own teams.

This is part of Qorekit 0.3, out now as a beta: download 0.3.0-beta.1. As with any beta, keep a backup of anything you cannot afford to lose.

Once your records have a team, you can build one list that shows each person the work of their own teams. You set it up once, share it, and it fits everyone who opens it.

This post assumes you already have teams and a Team field on an entity. If not, teams: who works with whom shows how to set them up. The examples use Deals in a Sales module, with teams London and Berlin under Sales.

The My teams value

A team field is a related record field that points at Teams. In a filter or a quick filter on such a field, Qorekit offers an extra value called My teams. Other related record fields do not have it.

My teams finds the records of the teams the person looking is a member of. It is worked out for whoever opens the list. Someone in London sees London deals. Someone in both London and Berlin sees the deals of both.

It works like Me on a user field, which stands for whoever looks at the list. The two combine well, as you will see below.

A filter in the filter builder

To try it on your own list:

  1. Open Deals and select Filter, then Add a condition.
  2. Pick the Team field.
  3. Pick the condition is and the value My teams.

The list updates as soon as the condition is complete. Like every filter, it is part of the page’s address, so a link you send opens the same list.

Conditions can be grouped. A sales lead might want Team is My teams and (stage is Negotiation or amount is at least 10,000). Add a group nests the second pair, and Match decides whether a record must meet all of them or any.

One saved view for everyone

A filter you keep using belongs in a saved view.

  1. With the filter in place, choose Save as new view… and call it My team’s deals.
  2. Open the ⋯ button next to the view and share it with everyone who can see these records, or with users with these roles.
  3. If you like, choose the roles it opens first for, such as Sales.

Sharing a view needs the Design forms and share views permission. A shared view shares the list. Everyone still sees only the records their roles allow, and My teams narrows that to their own teams.

This is the point of the value. Without it, you would need one view per team, and a new view each time you add a team.

A quick filter above the list

A quick filter puts the choice one click away, above the list. Anyone designing the list can add one:

  1. Open Deals, choose Design, then the Quick filters tab.
  2. Add the Team field.
  3. Choose Preview to see it as people will, then Publish.

The Team quick filter offers the teams, with My teams among them. A quick filter adds a condition to the list’s filter, so it shows in the filter builder too and can be kept in a view.

Only values used in records, on the quick filter’s settings, offers just the teams that the records have. Each person sees the values of the records they may see.

An Owner quick filter next to it, with Me, lets a salesperson switch between their own deals and their team’s deals without opening the filter builder.

Showing the team in the list

To see at a glance which team a deal belongs to, show the Team field as a column. In the list’s design, on the List tab, drag Team from Hidden into Columns shown, in order. People can also turn the column on for themselves with Columns above the list.

Read more

The teams page and the list design page of the documentation cover both in more detail. You can try filters and quick filters in the public demo; My teams arrives with Qorekit 0.3.0.