Recurring Shipments based on Frequency

[John_M]

Hello fine people!

Here's what I have and am trying to do... any help would be greatly appreciated!!

Customers order a product from us and can choose a recurring subscription - either once a month, three months, bi-annual, or annual.

What I'd like to do is have an automation of some sort that would recreate this record so I can add a calendar and have those records show up in the calendar based on the next shipment, creating a new record in my "New Orders" table.

Thoughts?

[Lom_Labs]

We made an app just for this and we also provide a script for you to use with automations!

You can install the extension from the Airtable Marketplace to try it out to see whether it does what you want: 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!