Skip to main content

Recurring Shipments based on Frequency

  • September 5, 2024
  • 1 reply
  • 0 views

Forum|alt.badge.img+5
  • Participating Frequently
  • 5 replies

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

Lom_Labs
Forum|alt.badge.img+12
  • Inspiring
  • 48 replies
  • September 5, 2024

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!


Reply