Skip to main content

Schedules Example Base

This is my first post to forum; hope I get the mechanics right.

You may find this base handy if you need to schedule recurring events.

I work for a community radio station and wanted to be able to offer users the ability to schedule our on-air broadcasts and various meetings as recurring events. I wanted to give users the same flexibility they have in Google Calendar and Outlook.

I’ve encapsulated recurring date calculation logic in a single table: “Schedules”. I’ve seeded the table with example rows and the primary field’s default formula describes each row using the user-entered fields.

The Schedules calendar view shows a set of example recurring dates, with the primary field documenting each recurring pattern. Check out the calendar view to get a quick idea of scheduling features.

Since all recurring dates are calculated off of the value of the built-in Airtable TODAY() function, the calendar is always automatically up to date. Recurring dates that slip into the past are recalculated into the future as each day passes.

The implementation is not complete: The design and usage document in the Documentation trable of the base outlines design issues and the implementation backlog. I’m publishing this early for selfish reasons. If I’m lucky others will have better ideas and/or implementations. I’m thinking of you, W_Vann_Hall, and all those experienced developers that can poke holes in this thing and/or point me to better ideas and code.

I intend to deploy the schedule table by adding it to our bases where needed and to keep the date logic encapsulated in the table. I’ll use links, lookups and rollups to integrate the date logic into the tables that need it.

The ‘’'Documentation ‘’'table holds source listings and more detailed user documentation.

Recurrence Patterns

The date logic supports the following types of recurring dates:

  • Weekly events on a specified weekday.
    ** ‘‘Every Wednesday’’
    ** ‘‘Every other Thursday’’
  • Monthly events on a certain day of the month.
    ** ‘‘Every month on the 15th of the month.’’
    ** ‘‘Every other month on the 1sth of the month.’’
  • ‘‘Monthly on a certain weekday’’
    ** ‘‘Every month on the last Sunday’’
    ** ‘‘Every 4th month on the 3rd Tuesday’’
  • ‘‘One time events’’
    ** ‘‘Just once, on July 17th’’
  • ‘‘Ad Hoc events. These are like one-time events but the date field is not a formula, enabling the user to drag and drop the event to a different date time.’’

Daily events is at the top of my wish list, but to get around its lack for now, you can create a weekly event for Monday, then duplicate the event and change the day of the week to Tuesday, and so on. I’ll be getting back into the code in the fall and will add daily/weekday/weekend events. Anything else you’d like to see?


Daily events is at the top of my wish list, but to get around its lack for now, you can create a weekly event for Monday, then duplicate the event and change the day of the week to Tuesday, and so on. I’ll be getting back into the code in the fall and will add daily/weekday/weekend events. Anything else you’d like to see?


Hi @Charles_Beckett firstly, huge fan of your base! Second, I have been getting stumped on getting the calendar dates to span over the course of multiple days. The Anniversary date from your base displays as a two day event but I think it might have more to do with the fact the 24 hour period is in the middle of the day so it rolls into the next day ??

My need for this use case for this is to show the span of a pay period on a bi weekly bases. When I leveraged your ‘End Date’ field to put the last date of the pay period it did not display the way I thought it would.

I would consider my Airtable skill to be above average and I have to say your base has a beautiful sophistication I have become enthralled with… kudos!!!

I much appreciate any notes or insights you might be able to share around this. Many thanks


Hi @Charles_Beckett firstly, huge fan of your base! Second, I have been getting stumped on getting the calendar dates to span over the course of multiple days. The Anniversary date from your base displays as a two day event but I think it might have more to do with the fact the 24 hour period is in the middle of the day so it rolls into the next day ??

My need for this use case for this is to show the span of a pay period on a bi weekly bases. When I leveraged your ‘End Date’ field to put the last date of the pay period it did not display the way I thought it would.

I would consider my Airtable skill to be above average and I have to say your base has a beautiful sophistication I have become enthralled with… kudos!!!

I much appreciate any notes or insights you might be able to share around this. Many thanks


OMG I FIGURED IT OUT face palm… all I had to do was multiply the # of days by 24hrs and put that # in the Duration field for the event to span over the days I needed it to…

LOL typing it out was extremely helpful :laughing:


Do you have this still? this is exactly what I'm trying to create!


Hi Charles,

I hope you're still helping people with this use case because your calendar has been incredibly helpful!

I'm reaching out to ask for your assistance in figuring out how to calculate and display an event every Thursday on the third week of every month. I noticed that you have a setup for a recurring monthly event on a specific weekday, but it uses the right now date and Today's date W start date time. Instead, I want it to use a provided start date so that it can show the event for every month of the year, not just from the current date onward.

Can you help me with this? I would greatly appreciate it and would love to discuss it further over a Zoom call if possible.

Thanks in advance!

Best,

Isabel