Batch Duplicate Records Within Same Table

Hi Airtable Community, I’m looking to figure out a way to create my team’s baseball lineups in Airtable and have grouped by date. I’m looking to duplicate the entire lineup and update the date field (upcoming game) all at once. Is there a way I can do this or add an automation?

Below shows you how I’m looking to duplicate all the records for 9/25 and create a duplicate data set, but for 10/2. Thanks for the help!

Hi,
just select the range 6x12 (from Wesley/RSVP) and copy-paste it at lower cell (also Wesley/RSVP)

p/s/ I wrote a script for that, looping through fields, then did a lot of troubleshooting with conversion, then solved a bug with filtered ‘falsy values’ (like 0). and then realized I could just copy-paste ))

Awesome! 5 years later and now just realizing I could have copy and pasted :slight_smile: Thanks for the help!!

1 Like