[00:00:00] Hey, I'm Steve. You've probably met me watching previous videos. In this video I'm gonna go over, um, the general use of like, projects in our projects database. Pretty straightforward. The majority of pages in our projects database are projects. Uh, Which maybe goes without saying, but there it is. In this video we're gonna talk about how you can use project pages to organize stuff you're working on broadly.

[00:00:28] So projects are bigger than individual tasks. They're stuff that you have to revisit or that have multiple tasks or that are shared between multiple different stakeholders. So if you're working on a project with someone, project page is a great place to do that. Um, so we talked a little bit already about.

[00:00:44] Views we have for seeing projects and missions and why. And in this video, I'll break that down in a little bit more detail than I already have by going into each of these tabs and giving you a preview of how you can see projects. And access the ones that you're working on. [00:01:00] Um, and then we also have, uh, we can go over a little bit how to use database views in your own pages so you can start to make breakdown views of different elements of stuff.

[00:01:12] In your, um, projects, In fact, I'll probably cover that a little later in the video, I'm gonna talk first about how to magic manage projects in your own work. So how to set up a project page, how to use that project page, how to discuss that project with people on that project page. So whenever you have something that you're working on with Lander and you don't have a place to talk about it, you know how to make that place.

[00:01:34] Then we're gonna talk about how to accomplish work and move a mission toward completion, uh, which is pretty straightforward, but just to like sort of close the loop on why we have projects in the first place. I'm gonna talk about how to finish a project and then uh, we'll talk a little bit about database views and then we're gonna go into how to find archive missions, assets and projects.

[00:01:52] Cuz I mentioned up here and we talked about the PAM system, the sort of, uh, projects, areas, missions, archives [00:02:00] or projects, assets, missions, archives. Um, They all automatically turn into archives eventually, and so you may sometimes lose things that have automatically been archived just to keep the workspace clean.

[00:02:12] So I'll go into how to find those things. Okay. So without further ado, uh, let's dive into it. First of all, what views do we have for seeing projects and missions and why? Well, um, fortunately, notion, as I mentioned in our, our overview video is sort of like a. Spreadsheets for humans is a great way to think about it, right?

[00:02:30] So rather than have this, this big open spreadsheet with 40 different rows and columns and a whole bunch of content and data, that is technically what we're looking at here. Like if we made a new view and we just made it a table view. Uh, and that table view showed everything. Let's do this. I'll leave this view in here.

[00:02:51] Okay? It's gonna be hilarious. But look, Properties 42 shown. No filter. No sort, no group. Okay, So this is just all of the raw [00:03:00] data that's in our projects database. All of it . So you can see here that we have, I don't know, like a bunch of different columns. So those are properties. You can see here actually that how many columns are there?

[00:03:13] 32. So there are 32 properties in every single project in our project database. They all share the same set of columns, the same properties, and there are probably hundreds of these. Let me hit calculate here At the bottom of the table view, you can always calculate. though I think this view may be so big that it just won't load.

[00:03:37] Oh Lord, you can see my computer's freezing up. You get the idea, right? So this is hundreds and hundreds of rows cuz there are hundreds and hundreds of projects that we've done. I'm gonna stop spending cause it's just gonna get and worse and we need to record a screen flow tutorial earlier so you get this.

[00:03:56] This is what notion is actually storing data wise. Like this is what's [00:04:00] actually happen. Is there's a big spreadsheet and it's pretty hard to read if you don't organize it somehow. So these database views, they're called database views and they look like tabs at the top of any database. You happen to see these give you a way to organize, filter, sort the information in that spreadsheet so that it's useful.

[00:04:17] So I've already covered the missions view, which is basically filtered by. Any project whose type contains mission, so that if you watch the previous video, you know that mission means that it has a timeline, but it doesn't have a project or a mission that it's associated to. It doesn't have a top level mission.

[00:04:36] And so it is the top level mission. So if it contains mission and it's not already in the archive, it's gonna show up on this page and it's gonna show up in this order. You can see, you set a sort as well on these pages, so it's gonna say the ones that. Most recent progress show first and the one that have the most recent timeline.

[00:04:55] Property show first. So the ones that are most done, [00:05:00] uh, show last and the ones that were most edited recently show first. That's basically how that sort works. So every single database view though, has a different set of filters and sorts. So let's go look at another one. This one is called All and it is, It's not actually all but.

[00:05:15] Most of the active projects, and so you can imagine, before I even open the filter button here, what does this filter probably include? What probably includes. Not showing things that are in the archive. It probably includes not showing things that are missions, and it probably includes not showing things that are assets, right?

[00:05:31] Because now we wanna look at all projects, so we're probably filtering out only things that are projects. And so we open the filter here, we look at the rules. Oh, what do you know? It does not contain. It does not contain meeting, which is where most of our assets are. It does not contain standups, and it does not contain our developer who has his own separate set of projects that we don't need to show here for the rest of the team.

[00:05:56] So, um, a pretty interesting filter on this [00:06:00] page, but basically what that results in is it shows us all things that are projects, uh, that we're working on actively, currently. And, uh, we have it broken down by a property we call status. So in notion you used to have to organize statuses by making them yourself, but they have just introduced this feature where you have a status property on these pages.

[00:06:23] And so I'm gonna show you how that status property works. Um, as you can see here, this is, um, this is a view called a CanBan board, which, um, comes from tools like Trello and Asana, where you can see. Um, you see the board layout is what we've selected here. So it's not a spreadsheet, it's not the table, it's not a timeline, it's not a list, it's not a gallery, it's a board.

[00:06:45] And then that board can be broken down by a specific, uh, property type. And so we've decided to group it by the status property, which is one of the columns in our spreadsheet. And that status property has a couple different settings you can set it to. [00:07:00] So, um, you can see here that, um, We have, uh, 93 projects that are finished, 186 projects that don't have an active status, and so they don't show up on this page.