Welcome back.

In this lesson we're continuing our exploration of this top nav bar. We started with the filter functionality which helps you reduce the number of records you see according to certain criteria. In this lesson we're going to explore the group functionality which as you can imagine by its name helps you group your table according to certain fields.

So let's group our table by status and what this does is. It moves all of our records into sections according to what status that record is in. So it takes all of our new candidates and puts them at the top then followed followed by those that are in the interview phase, second interview and then those we've rejected so let's take a moment to explore the different functionalities that this opens.

First you can collapse different sections so you can focus on the group that you care about. Second our table provides these convenient summaries at the top of each section. So here I can see that the average salary for candidates that are new in the pipeline is one hundred three thousand I could change that to the median or the minimum. Let's keep it to average. And then as I change it, it updates for each one of my sections - very convenient. One field that's added automatically is the count. So I know that I have four candidates in new, five being interviewed, three in a second interview and eight that I rejected.

So you might be wondering how did Airtable know that we wanted this order for our sections. So when you're grouping by a single select field such as status you don't always order it according to the order that you've input it. If you want an alphabetical order you can click here but we'll keep it in this order.

You can also mix and match groups and filters. So imagine I want to only see candidates who have an expected salary under one hundred fifty thousand. So now I have a filter that removes every record for candidates or removes every record where a candidate has an expected salary that's too high for our position. And then groups them based on their status.

That was introduction to the group by functionality. It's really convenient when you want to order your record into something that makes a little more sense for you. I do encourage you as I didn't last lesson to take the template that I'm sharing in the show notes and copy to your workspace and play around with grouping by different fields talk to you in the next lesson.

Mark lesson as completed & go to next