Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi,

I have begun using Airtable as a scheduler. I am looking for a simple way to automatically create a set of date records in Airtable, ideally via Slack. They would be an x number of time slots every y minutes, from time a to time b, for a specific day. The result would need to look like the attached picture.

Any idea on how I could achieve this ?

Thanks!

Hi @MTLGuy 

Good question.

The logic for this can be a bit tricky especially to defensively code.

 

There are 3 inputs:

  1. Start Date & Time
  2. End Date & Time
  3. Interval (in minutes)

 

Things that have to be defensively coded:

  1. What if the Interval is larger than the delta between the Start/End Date Time
  2. What if the End Date is before the Start Date
  3. What if the interval doesn’t split nicely based on the Start/End Dates & Times
  4. ...and so on

 

Probably would be best to standardize into a form that is filled out.

Could be a simple Airtable Form with 2 Date/Time fields and 1 dropdown for interval. (e.g. 15 mins, 30 mins, etc.)

An Airtable Script can be created to be run automatically via an Airtable Automation triggered by a new form submit.

Hiya @MTLGuy! I wanted to swing by and see if Troy’s recommendations helped get this sorted for you? Keep us posted on your success! 🤗

Terms & Conditions