Skip to main content

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.

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:







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







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

Reply


Terms & Conditions