No duplicate record creation

[mirkolando]

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

[Lom_Labs]

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:

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:

And here it's generating records quarterly and annually!