Recurring Events with an end date for the automations

Topic Labels: Automations Formulas
484 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello Community.. I hope all is well

I built an Agenda database that has recurring events such as "Daily Lunch Time" and "Weekly Team Meetings" etc.. Keep in mind that new Agenda items with new frequencies keep adding up. 
Setting a recurrence automation is possible, as a new record of the same Agenda item gets created every time the item is marked done. 

But what if I need to see the items for the whole year from now, without waiting for the items to get done, and without having the automation run endlessly? 

I have been looking at a formula or automation for recurring events with different frequencies while having an stop date for the recurrence. would truly appreciate your support if anyone knows a perfect hack for it without the requirement to write a coding script (as I am not experienced in that) neither 

I hope my question is clear. I truly appreciate your support.


2 Replies 2
7 - App Architect
7 - App Architect

Hello @Hamda , we've built an app for this and you can find it here:

You can set the start date, end date, and intervals and it will create the records for you with Airtable Automations:enddate.gif
Or you can just set the number of times you want the event to occur too!

Thanks a lot Lom Labs
But I was kind of hoping to find an automated solution within Airtable functions without the ad-ones.


Thanks again for the efforts