Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Automation to copy rows based on formula

Topic Labels: Automations Formulas
683 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Lethokis
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
kuovonne
18 - Pluto
18 - Pluto

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.