Build a script that converts a single row (with start date, end date) to multiple rows

[Kristjan_Kristj]

I have an airtable base with ~1000 records. Each row record has a start and end date as well as additional information. I need to transform each record into multiple rows so that a record with a 3 month plan is shown in 3 rows, on a monthly basis (always 1st of every month)

[kuovonne]

I recommend you have the new records created as linked records in a different table. That way you will not have so much duplicate information.

Can you clarify your goals?

• Are you trying to write this script yourself?
• Are you looking for an existing free script?
• Do you want to hire someone to write this script for you?

[Kristjan_Kristj]

I tried to do it myself. Ended up being to complex. Then hired a contractor to do it. Script works, but times out after 30 seconds (I need to multiply ~600 rows of data each with 1,3,6 or 12 rows, after around 200 rows it times out.

[kuovonne]

Kristjan_Kristjansso:

Script works, but times out after 30 seconds

Is this an automation script? Automation scripts are limited to 30 seconds.

Can you change this to a scripting app that is run from a button to avoid the time limitation?

I suspect that your script is already creating records in batches of 50. (200 original records times an average of 6 new records would take about 30 seconds to create). However, it is possible to create all the records you need using a different technique that I call mega batches. With mega batches, you could create all the records you need (600 x 12) in well under 30 seconds.

If you are interested in hiring me to implement a script with mega batches, you can book an appointment with me to discuss options.