Skip to main content

Batch Duplicate Records Within Same Table

  • September 23, 2022
  • 2 replies
  • 2 views

Forum|alt.badge.img+7

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!

2 replies

Alexey_Gusev
Forum|alt.badge.img+23
  • Brainy
  • 1131 replies
  • September 23, 2022

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 ))


Forum|alt.badge.img+7
  • Author
  • Participating Frequently
  • 6 replies
  • September 29, 2022
Alexey_Gusev wrote:

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 :slightly_smiling_face: Thanks for the help!!


Reply