How i can build automation based on data change trigger

Dezi

Hello

I would like to build Row Copy automation when one of the fields is changed from blank to any value in a specific row, but I don't want to copy the row again when the value changed again in the same cell

how can I avoid the copy of the row twice?

Ryan Sides

Hi Dezi, create a helper column called "Row Copied". In your automation to copy the row, after your row copy action, add an action to Change a cell value and set it to the Row Copied column. Enter some value like "Copied". Then modify the same automation to conditionally filter any rows where Column Row Copied is not blank.

Does that help?

Ryan Sides

Hi Dezi, create a helper column called "Row Copied". In your automation to copy the row, after your row copy action, add an action to Change a cell value and set it to the Row Copied column. Enter some value like "Copied". Then modify the same automation to conditionally filter any rows where Column Row Copied is not blank.

Does that help?

Dezi

Hello Ryan

Thanks i will try

Ryan Sides

Sounds good. Let me know if you run into any issues. Happy to help! 😀