Automation to copy rows based on formula

Topic Labels: Automations Formulas
415 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Dear Community,

I do have a table with a formula field, which tells you how many times a row has to be copied.
I did set up an automation which tells you to copy the row, when formula field is bigger than 0.

What I can't figure out is how to tell the automation to stop copying once the desired number is reached. 

Is there a way to achieve this?

Thank you.

1 Reply 1

There are several ways to do this. The way I find easiest is to use a script to turn the number into a list so that you can run a repeating action group in your automation, and you put the "create row" action inside the repeating action group. It is a fairly simple script, but if you do not know how to write the script, I sell one in my scripting automation helpers.