Yet another Repeating Event query

[Marianne_Hislop]

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:

[ScottWorld]

I would take a look at these 2 scripts:

Recurring Events Scripting app

Schedule repetition frequency of a transaction or event based (daily, monthly or yearly). Kindly provide suggestions or feedbacks for improvements. Especially, I want to workout more edge case issues. // Query for every record in “Table” let table = base.getTable(“Table”); let query = await table.selectRecordsAsync(); let srcDtl = await input.recordAsync(‘Select the row to repeat?’,table); if (srcDtl) { // Begin logic of creating repetitive transactions // Replace ‘Field’ with name of th…

Create recurring orders Scripting app

Over the weekend I was helping a non-profit that’s organizing food deliveries from restaurants to hospitals as part of their COVID response efforts. They have a table of Orders. An order specifies the restaurant providing the food, the hospital receiving the food, a start and end date, and the days of the week to repeat the order: [Screen Shot 2020-04-06 at 10.47.33 AM] We wrote a script that goes through these recurring orders and creates a delivery record for each day that the order should…

[Marianne_Hislop]

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.