Automation - Copy all records from a group, and add them to a new group each week. e.g. 5 record last week, 5 records this week

Hi Everyone.

I 'm having trouble with an Automation (Scheduled Time, Find Records, Create Records) that will find all the records in a group (e.g. Group is “Week 36”), copy those records and create them into the next week’s Group. This in theory is simple and I can get it to almost work. It can find all the records I want it to.

But…

When it creates the records into the next week group it adds them all to a single record. Even if that linked record field is set to off for “allow linking to multiple records”.

I just need it to add a distinct record for each copied record in that new week, not jam them all into one record.

Hi Stephen, unfortunately that’s…working as intended. We can’t create multiple records via an automation easily I’m afraid

If you’re on a Pro plan, you can accomplish this via a script, and if you’re on a free plan you can accomplish this via some weird workarounds

Here’s a base with the weird workaround

This involves an automation that will search for records with the type Group 1, and then update a record with the result (a comma separated list) in another table’s record. Another automation will then paste a formatted version of the result into a linked field to the table you actually want to create records in, forcing a record to be created per comma separated value


And here’s a base with the script

This one’s pretty straight forward, Find Record action into a Run a Script action that just creates the records as needed


We can modify both of the above to create records with additional data as well

You could also use a third party service to help you with this like Make or Zapier or something, and if it’s a weekly thing the free tiers of those apps would work fine for you and probably be less of a headache than either of the above solutions honestly

Lemme know if you’ve got any questions, and if you want someone to just handle it for you can hire me to do it too!