Automate repeating calendar events

This is a bit of a pain point as Airtable doesn’t really like to automate re-occurrences. 

Solely inside Airtable, you could try to add a reoccurrence field and use that in conjunction with DATEADD() delineated in weeks, but you’ll probably need a number of conditionals. There might also be a scripting solution (which is generally beyond me).

The way I mostly handle this kind of thing is by separating the events into an event table and a dates table, and then using Fillout Forms as my form provider. With Fillout you can add new records inside a linked field, so people can create and attach as many dates as they want to an event to represent reoccurrence. It means the submitter has to specifically add  1/20/26, and 1/27/26, and 2/3/26, and etc. In my mind this works for up to maybe 5 repeating before it gets anti-user...

Fantastic ideas & tips from ​@DisraeliGears01 above!

I always recommend Fillout to everyone, because it is 100% free and it can do hundreds of things that Airtable’s native forms can’t do.

Here is Fillout’s support article on creating new linked records with a form.

Fillout also allows you to:
- update Airtable records using a form
- create custom PDF files from a form submission
- accept payments on forms
- pre-fetch dynamic data from an Airtable record
- customize a theme for your form
- display Airtable lookup fields on forms
- create multi-page forms with conditional paths
- add a login page to your form
- perform math or other live calculations on your forms
- collect signatures on a form
- and much more

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

• Using Fillout to update an existing Airtable record & create an eSignature approval process with PDF file creation.
• Using Fillout to create an order entry form with line items.

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Hm, how far in advance do the events need to be created?  I’ve worked on something similar where we had to create them one week in advance and I’ve put it together here for you to check out
 

Each Program has a Start and End date and is linked to multiple Calendar records, where each Calendar record is a single Event for that Program.  We use a rollup field to grab the latest Event date, and then use a formula to help us figure out when the next meeting is

An automation then runs once a week on Sunday at 12am and looks for all Programs that have a ‘Next Meeting’ value.  As you can see, Program 2 doesn’t have a value in ‘Next Meeting’, as its next meeting would have been 22 Jan, which is after the End date that was set for it

And here’s what the automation would look like:

Airtable does not currently support this functionality. This is something I wish they had built in as well; however there are some workarounds you could try to do to make this a much easier process for you.

One of the options you could take would involve setting up an automation that will generate all or most of the recurring events at once with all of the start and end dates with a form submission.

Then create a view that looks for events that are occurring within that week so that you only see the repeating events that are currently in use.  You can add other select fields to perhaps customize your view and make it have even more functionality than it did before.  While not perfect it can make things a little easier organizationally.

I actually just went over my example of recurring events on the latest episode of the BuiltOnAir podcast. My implementation doesn’t use scripts or external integrations, just multiple formulas.

The whole episode is me yapping away about how I did it. In my example I had a button to generate the next few events. It sounds like you can just have the automation trigger automatically when the latest event is X days out, create the next event.

Lol, loved the “All Weekdays” formula ​@Kamille_Parks11!!!!!!
Nice workaround!

Mike, Consultant @ Automatic Nation 
YouTube Channel 

Use an automation tool that supports recurring events, such as Airtable automations, Google Calendar with recurrence rules, or a workflow in Zapier or Make that duplicates the event on a weekly schedule based on the original submission.