Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 02, 2021 11:41 PM
I operate a booking system in Airtable and I have to generate months of recurring dates/times (one per record) in advance.
Click, hold, dragging date sequences is very helpful in this regard (see:
Quickly filling cells using fill handle – Airtable Support)
However, I’m left wanting more.
I’d like to create a script or automation to generate the recurring dates/records for me.
As an example, let’s say I was teaching a yoga class every Mon, Tue, Thurs, and Sat at 1 pm and 4 pm.
Instead of having to continually check my dates, then drag out hundreds of dates/records manually, I’d like to write a script or automation that would do it for me, thereby ensuring that the timeslots/records for the said class were always created several months in advance.
Has anyone solved a similar problem to this one? Does anyone have any thoughts as to how I should approach a solution?
I could imagine an Airtable app that had similar options to the “create recurring event” modal used by google calendars.
Aug 14, 2022 08:32 PM
Hi,
I think that such kind of tasks - to prepare a table filled with some recurring dates - does not require scripting at all. I would use date formulas (dateadd) in connection with autonumber and a lot of copypasting
Aug 16, 2022 11:46 PM
Hi Alexey
I agree also - but have you found use in the airtable automations?
I’m using date add also, and for some just google calendar recurring tasks, synced to airtable (with automations I update task name, some fields per calendar it is coming from, eg ‘Meeting Calendar’ all are type ‘meeting’ for example, or ‘unplanned’, or ‘bills’)
I’d created a large project management base and used copy pasting and helper columns but now getting into automations finally and they are incredible! Change a status and an automation generates a ‘task’ - approve a ‘request’ and a project template is created with all generic tasks needed for the project (including which will be recurring project control tasks, eg setup weekly sprint, and so forth)
A lot of fun also :slightly_smiling_face:
Oct 23, 2022 11:47 AM
Hely Andrew
This is a god sent ! :slightly_smiling_face:
2 things I am trying to get my head around, is there a way to get it to get the start date, number of weeks and the days to generate the events from a record response in another base?