Automation! Schedule adding records in Quickbase

Показать описание

Schedule routine tasks to be done for you automatically in Quickbase! Using automations on a schedule will change the way you work in ways you can't even imagine.

Bonus: This video also utilizes the NEW Builder Program where you can access a FREE personal Quickbase license. Check out the RESOURCES below ▼ for more information.

Do you have daily, weekly, or monthly recurring Quickbase activities? I bet you do!
If any of these sound familiar you'll want to check out this video:
* You Track tasks or to-do lists that have recurring daily, weekly or monthly tasks that you manually create records fo reach time
* You track subscription type charges that occur on a regular schedule
* You track recurring marketing campaigns
* You track monthly finance activities
* The list goes on...

In this video on Quickbase Automations, I'll take you through each step to set up an automation that runs on a regular schedule to add records.
1. Create a new automation based on a daily, weekly, or monthly schedule
3. Set the action(s) to add new records and save
3. Test the results

As you get started with Automations, please be cautious and heed the warnings I share in this video. Otherwise, have fun and enjoy saving boatloads of time!

RESOURCES:

****FREE GUIDEBOOK****
The Ultimate Grid Edit Guidebook: Using Grid Edit will never be the same!

FROM THE VIDEO: "...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 so let's go into the automations I'll choose settings and scroll down to automations 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 need to set up some filters we'll start by identifying the record we want to copy 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 I can now think about what do I actually want to have copied from this record that we've filtered down to 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 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 now let's head over to 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 however these next four well these are the ones the automation automatically added for me..."

Feeling like a Junkie? Subscribe Now!

LET'S CONNECT!

© Quick Base Junkie

Quick Base Junkie is unofficial and not affiliated with Quickbase Inc.