I have a quotes and dealer orders table. When a user creates a quote there is an "order" button. My goal is to have that sit in their quotes table until they hit order and then that disappears from "quotes" and goes to "Dealer Orders" Table.I have an automation set up that copies certain information from that quote (name, address, material information) to the dealers table when the order button is pressed (triggering a field to show "approved", which triggers the automation). After that the automation changes that field back to "sent" rather than approved so the automation doesnt copy over every quote- just the one ordered. Lastly I have an action in the automation that deletes the record that has "sent" in that field. Am I doing that right or is there a different way I should go about this.
As of now my automation is triggering and deleting from my quotes table, but it never shows up in my Dealer orders table and gives me an error after the automation is ran.