- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 05, 2024 08:32 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 06, 2024 02:50 AM
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!
