Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Recurring Record creation

189 0
cancel
Showing results for 
Search instead for 
Did you mean: 
mirkolando
6 - Interface Innovator
6 - Interface Innovator

Hello Airtable Community,

 

We have an Airtable list with our internal communications.

Now we have some communications that take place at regular intervals (X weeks).

I just can't manage to build an automation that creates a new record for each of them.

For example, every 14 days for the next year a record with start, end date & name.

 

Any ideas on how to do this?

 

Many thanks and best regards

Mirko

1 Reply 1
Lom_Labs
7 - App Architect
7 - App Architect

We made an Airtable Marketplace app just for this and we also provide a script for you to use with automations! To create one record every 14 days for the next year, you'd set it to create 26 intervals, one every two weeks:

Interval Scheduler - 2 week settings.png


You can install it to try it here: https://airtable.com/marketplace/blkhKjz9YWXG5Fo0J/interval-scheduler

And you can also generate your own script to test too! https://www.lomlabs.io/airtable/scripts/repeat-interval-scheduler

Here you can see it creating 12 records in "New Orders", each one month after the last, linked to the original Subscription record:

Interval Scheduler - Monthly.gif

And here it's generating records quarterly and annually!

Interval Scheduler - Annually.gifInterval Scheduler - Quarterly.gif