May 17, 2020 08:02 PM
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:
Aug 31, 2020 12:14 PM
thanks a lot! this ended up in my lifestack!
Dec 07, 2020 03:30 PM
Hi Charles, thank you so much for sharing. This is exactly what I need, but I’m struggling to understand how to adapt and use it on my base. The formula file, converted to txt, is fairly difficult for me to follow.
I am building a calendar for 2021 where I only need 12 rows, one for each month, and the date should be the first Thursday of every month. I’m struggling how to build the formulas. Can you help me to understand how best to use your sample base? Many thanks in advance.
Dec 07, 2020 07:18 PM
Hi Peggy,
Let me know when you have a few minutes free for a call/zoom meeting. I’d be happy to help.
/chuck
Dec 08, 2020 10:17 AM
Thank you so much Charles! I’m on PST - and I’m free from 4:30pm today onwards. Zoom would be great, if possible, thanks!
Dec 08, 2020 11:49 AM
Send your email address to chuck@chuckbeckett.com and I’ll set it up for 4:30pm PST.
Dec 08, 2020 12:06 PM
See if you can get a copy of the base using this link: https://airtable.com/shrqO8VrsRE29Iqpj
Dec 08, 2020 01:14 PM
Just sent you an email. Thanks Chuck.
Dec 23, 2020 07:07 AM
Hi @Charles_Beckett thanks for sharing! Looks very similar to something we’re trying to do. I see that you have the ability to add things like weekly recurring evnets and when the record is open it shows when the next ~4 events take place. In the calendar view I see the first event but the subsequent events don’t show up. Is this a limit you ran into or am I not using the views correctly?
Dec 23, 2020 07:59 AM
I’m just about to release a ‘V2’ version of this, which eliminates a lot of bugs and provides a much better user experience. I’ll share it with you if you are interested in trying it out and giving feedback; I’d love some feedback before I post to Airtable.
This version is aimed at letting folks sync the recurring events from the base to bases of their own. This eliminates all the work of copying formulas to your own base, and means you can share the same set of events to multiple bases.
Let me know if you would have the time to review the base.