Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Yet another Repeating Event query

Topic Labels: Base design
596 2
Showing results for 
Search instead for 
Did you mean: 

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:

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.