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.

Yet another Repeating Event query

Topic Labels: Base design
1762 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Marianne_Hislop
5 - Automation Enthusiast
5 - Automation Enthusiast

Completely new to Airtable.

I’m trying to design a jobs database that can handle repeated job events. Scenario is a customer needs a service carried out on a regular basis ie, 1, 2 3…weekly, fortnightly monthly, yearly etc. I need all future repeats to show on a calendar (don’t need time, just dates). I had something working in Google sheets and Excel, where a script would copy down a record xxx amount of times based on a cell value that calculated the no of occurrences until a specified end date (that was capped at two years), then added every occurrence to a spreadsheet database with the same record ID number to group them.

Is this possible in Airtable?

Thank you :slightly_smiling_face:

2 Replies 2

I would take a look at these 2 scripts:

Marianne_Hislop
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you Scott. As mentioned I’m completely new to Airtable, so now I have to figure out this scrip. I will have a look.