Help

Yet another Repeating Event query

Topic Labels: Base design
1059 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.