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

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)

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?
1 Like