Create Copies of Records through Automation

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
I have a Task Table (Task Name, Owner, Start Date, Duration, etc).

Some tasks are tasks that are recurring (they happen each week for the next month, or two months, or etc).

Wondering if there's a way through automation to to be able to create "x" number of copies of a record, based on perhaps a field changing in a record.

For example, in my task table, if I check "Duplicate Record", And insert a number in a field... that would copy my record those many times.
Photo of Ashley Asante

Ashley Asante

  • 696 Points 500 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of Slider

Slider

  • 1,326 Points 1k badge 2x thumb
You would have to create a looping automation, but be careful not to make an infinite loop!

I have been experimenting with looping automations, and they are tricky. I am trying hard to write the solution here, and I have failed multiple times.

Sometimes I have one automation that will kick off the loop, causing another automation to fire in a looping fashion until the conditions are met.

for instance, you can have a counter field, and every time the automation to clone the task fires, it takes the counter and adds 1 to it, triggering the next automation to clone the task, increment the counter by 1 until the counter equals the number of copies specified.

(Edited)