+3I 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)
+29I 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?
+3I 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?
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.
+29I 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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.