Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Recurring Shipments based on Frequency

Topic Labels: Automations
428 1
cancel
Showing results for 
Search instead for 
Did you mean: 
John_M
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

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

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:

Interval Scheduler - Monthly.gif

And here it's generating records quarterly and annually!

Interval Scheduler - Annually.gifInterval Scheduler - Quarterly.gif