Repeat record entry based on number of occurrences based on criteria

[Marianne_Hislop]

Hello. Complete noob to Airtable.

Currenty I have an Excel file that handles incoming jobs, 90% of these jobs are based on a recurring schedule of weekly, 1-4 weekly, monthly, yearly and so on. Not time dependant, only date.

In excel I use VBA to copy a new recurring job entry record x amount of times based on the frequency calculated by the frequency between the start date and end date and the schedule (end date max 2 years to eliminate forever). So example:
Start Date 27/3/21
End Date 27/3/23
Schedule every 1 week . 7 days
Total number records to be copied is 104 with the Start date of each record to be previous Start date + 7 days.

Each job record will have a unique ID number, and each recurring job record will also have a Recurring Job ID. Recurring ID for one off jobs will be 0.

I would like to know if anything like this is possible in Airtable.

Thank you.

[ScottWorld]

Welcome to the community, @Marianne_Hislop!

You could do this by writing your own custom JavaScript to handle this, or by turning to a low-code automation platform like Integromat.

Here’s an example of a similar JavaScript that you could potentially adapt for your needs:

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…

Or, if you use Integromat, you could turn to their “Repeater” module to loop through the creation of your recurring records:

Integromat

Flow Control App Help Docs | Integromat Help Center

Repeater Repeater is used in cases where you wish to repeat a task a given number of times. Let us assume you would like to send five emails with sub

(Note that I am a professional Airtable consultant and a Registered Integromat Partner, and the Integromat link contains my personal referral code.)