Airtable automation trigger: At scheduled time

To start creating an automation, from the open base of your choice click on Automations in the upper left corner of your screen to open the automation configuration window. Click the + Create automation option to begin the setup process. If you would like, you can rename the automation right away to make it easier to understand what it does.

1. Next, you will need to click + Add trigger option.

2. Once clicked, the available triggers will display for you to choose from. Choose the At scheduled time option.

3. Under the “Interval type” section, you can then choose from six options to trigger your automation:

   1. Minutes

   2. Hours

   3. Days

   4. Weeks

   5. Months

   6. One time
      Each interval type offers different options for triggering your automation. You'll find more details on using each interval below.

4. Next, you’ll configure the “Timing” of the automation. The options shown will depend on the interval you selected.

5. After configuring the timing, move on to the “Starting” section. This section exists for all interval types except the “One time” interval since that interval already contains the information about when it will start. Otherwise, set a date and time (in the future) of when you want the automation runs to begin.

It’s important to test the trigger at this point so that you can utilize dynamic tokens in the automation action steps. For instance, this trigger allows you to pull in date/time information to use in later steps:

• Actual trigger time

• Expected trigger time

• Next trigger time (If applicable)

Check out our help center’s Automation actions section to learn more about each action Airtable offers.

Again, be sure to test all of the steps in the automation that you are building. Once every part of the automation has tested successfully, you’ll likely be ready to turn the automation on. Find the red colored “OFF” toggle and click it so the automation now appears as “ON” in green.

Use the "Minutes" interval type to trigger your automation at 15 minute intervals, including every 15, 30, 45, and 60 minutes. With this option you can also designate a "Starting" date and time that you want the trigger to begin on.

Note

Triggers that include a starting time will activate at the nearest time interval. For example, If you deploy a trigger for every 2 hours at 2:45pm, it will fire at 4:45pm, and again at 6:45pm. As another example, if you deploy a trigger for every 30 minutes at 2:10pm, it will fire at 2:40pm, and again at 3:10pm.

Use the "Hours" interval type to trigger your automation at hour intervals, from 1-24 hours. With this option you can also designate a "Starting" date and time that you want the trigger to begin on.

Use the "Days" interval type to trigger your automation every set number of days (from 1-30) at a set time. With this option you can also designate a "Starting" date that you want the trigger to begin on.

Use the "Weeks" interval type to trigger your automation at week intervals, from 1-11 weeks. You can additionally designate which days of the week to use the trigger (e.g. weekdays like in the example below). Lastly, you can also designate a "Starting" date that you want the trigger to begin.

Use the "Months" interval type to trigger your automation every set number of months (from 1-12), on a specified day of those months (from 1st - 31st, as well as the "last day", and at a set time. With this option you can also designate a "Starting" date that you want the trigger to begin on.

Use the "One time" interval type to trigger your automation at a single date and time.

No, only future dates and times can be selected.

Datetimes defined in the "At scheduled time trigger" don't automatically handle the DST transition. That means times will be shifted 1 hour forward or backward when a transition happens. If the specific hour that an automation is triggered to run is important for a workflow, then a user will need to adjust any automations containing this trigger every time DST starts or ends.