FROM THE TUTORIAL: "Now let's get started! In this automation example, we'll be setting a scheduled automation that means you don't have to do something to trigger the automation rather it automatically runs based on a schedule we set. The automation you want is that each week any active project will require a weekly status update, so let's go into the automations. I'll choose settings and scroll down to automation. Let's start a new automation. This automation will be set to trigger on a schedule. I'll name my automation. The frequency can either be daily, weekly or monthly. I'm going to set this to weekly and have it run every Monday. Now I'll add in my action. You might be thinking, the action I want to perform here is to add a record; and while you wouldn't be wrong, you wouldn't be entirely right either. What I'm actually going to do is copy records because I need my tasks to remain related to my project and now I do need to set up some particular filters. We'll start by identifying the record we want to copy. Now I know that I named it with a task name 'weekly status update', we want to choose the latest weekly status update. In order to do that I'm gonna choose the date created is on or after the date of seven days in the past, and then I can continue to add additional filters as necessary. For this example, let's take the project status and say it's not equal to the value 'on hold'. I don't want to be creating any weekly status updates requirements when the project is 'on hold'. You could also include perhaps things like 'cancelled' or 'complete'. With those settings in place, I can now think about what do. I actually want to have copied from this record that we've filtered down to into my new task. The destination table will be tasks. I'll set my task name here again. I'll type in a value and then, very important here, I want to make sure that my task remains connected to my parent, so we're going to copy the related project from a value in the record. Great! So we've got that all set up. Very important all of this filtering and narrowing, now let's go ahead and click Save and return to our application. Our automation has run and so we can check out the results before we head over to the tasks table to see our new weekly status update. I do want to point out one thing: notice the record here for finance system upgrade. It happens to be 'on hold' and if you recall from our automation, we set anything 'on hold' to not get that weekly status update record added. Now let's head over to our tasks table. On our tasks table we'll scroll all the way here to the bottom and you'll notice we have weekly status updates for a number of items. These first five are the ones that I previously added. The ones that we made a copy of however, these next four well these are the ones the automation automatically added for me. These were added around 4:00 a.m..."
