I have an automation that is triggered when a field "order status" is changed to Approved. Order status is changed to Approved when the user clicks a button. My issue is that when one record is approved I can get all of the data I want moved over to the other table like I need, however when the automation is triggered for 1 newly approved record, it duplicates already approved records as well in my table the automation is copying to.
How can I get it to only move over newly approved records and not every record that has "approved" in the order status field. Just the one that was clicked on, because the other approved orders would have already been moved over there.
Perfect, thank you!
Basically we are having the [Copy Record] field be something that we can turn on with the button and the automation turns it off or makes it false before completing, therefore making sure it doesn't get copyed a 2nd time when the next order is approved right?
Thank you,Mike Klausing