00:00Welcome back to another video with Notion Workflow

00:01In today's video, I'll be showing you how to show entries by most recent time or most recent date, and so this is valuable when you have a lot of related database entries, and you just want to see the certain property or certain status for the most recent entry by time

00:21So in this case, we can use a date property, a creation property, a last edited time property, anything that has to do with time, so that we can use a formula to show entries by most recent entry

00:33We have a customer database and a tasks database, and they are just related to each other

00:37You only need these

00:42Three properties to get started, you don't need anything else, and everything you see on the screen is everything you need to get this going

00:46In our case, we're going to start a "let's" formula, and that is because we want to define a variable and then manipulate that further to save some time and effort, and I think generally speaking, you want to lean in on "let's" formulas so that you can define as many variables as you want

01:02Obviously, there's a cap, I'm not sure exactly what that is, but being able to define a variable and reuse it will save you a lot of time in typing, because all you might have to say is "dog" instead of "the"

01:17more complex formula that you've defined within the let formula function

01:19In our case, we'll just title a variable, recent, comma, and then a let's formula works where you define the variable name, and then you can define the actual variable, close it out with a comma, for example, and then after that comma, you can specify an output

01:35In our case, I defined recent as five, and I outputted recent, which is five, so just a quick example there to get started

01:42In our case, we want to manipulate the most recent date database entry

01:47We're going to be using a brand new formula function today, it's going to be the find formula that

01:51allows you to match an array or a relation to a certain criteria to see if it matches

02:00We're going to be looking at the task relation as the first criteria that we're going to be finding from, and then we are going to make sure that the current date that we're finding is equal to the most recent date that is available in the relation

02:15And so, in the past, I've used last and sort as formula functions to find the latest and earliest dates, and in this case, because we're talking about the most recent recent date, we can depend on the last and sort functions and apply that within a mapping formula to match the criteria

02:39That we're looking for, because we're looking at the current date of the related task entry, and we want to find it when it is equal to the most recent date, that is the task that we are looking for

02:51What we can do is map, like we normally do, the tasks, comma, current dot date, and we're going to close that up, and it's going to be do sort to add onto the map variable, and it's going to be the last condition, or the last entry within that mapped array

03:10We're going to close that up with a find function, click done

03:14So if we look at the dates here, notice how update 3 is June 8th, which is the most recent date in relation to today, so now if I

03:23Change this to May 28th

03:25June 1st is the most recent entry, and update two shows within the formula function, that was very fast

03:31And so, I'm going to go and repeat this thought process to help you understand

03:35So, we are finding the related tasks where the date is equal to the most recent date that we are going to output by using this map and set that equal to the current date that we're finding within tasks, basically because we've defined recent as this new formula that we nested in this let's formula function

03:59Because recent is the output of the let's formula, we see update 2 as task

04:03Let's say we wanted to go a little further and add another property that we might also want to show next to the name of this database entry, and so one thing we can do is add a new line within the output by typing in backslash n, and then after that, adding a new row within the formula output, so we can add in another layer of the related database entry, and so let's say we want to maybe automate this process a little bit, what we can do is add an AI summary property within the task database and then have it update, for example, this update provides information about dogs

04:45I did that because that's what I wrote as placeholder text for this entry

04:50I'm going To click on update for all of these, and as you can see, this text is here, this text is here

04:57Let's say we also want to output the AI summary of this most recent entry as well

05:01We can reuse the recent property, but because it is now part of the variable we've defined, we can reference any of properties that are related to that database entry

05:13Let's use AI summary and add that as an additional output, that's after a line break of the name of the most recent task entry, or in this case, updates

05:23So notice how that formula is updated and there is a line break, the clickable element of the entry, so we can verify this by expanding this

05:34And as you can see, that line break is clear

05:36If we wanted to add another one, we can do that, and notice how that line break adds a little more formatting, you could say, or spacing between text for that extra little pizzazz

05:48Within these other database views, we can see the name, any related property that we can define within this formula property

05:55Hope you found this helpful, as it's been a while since I've made videos

05:59Like and subscribe, thanks.