I have recently built an app for my e-commerce business which manages order processing. Till now everything seems ok, but I’m stuck with automations where I need some expert advice.
I’ve got these Tables -
- Products (Fields- Product Id, Product Name, Type, Price and Image)
- Sale (Fields- Sale ID, Date, Order ID, Order Status)
- Sale Details (Fields- Sale ID, Product ID, Order ID and Packing Status)
I’m trying to change the status of “Order Status” in Sale Table from “New” to “Packed” when I change the “Packing Status” in Sale details Table to “Packed”.
I know this has to be done with actions and workflow, but I’m not sure how to do it. I’ve seen a lot of videos and read a lot about it, still no help.
Looking for solution with steps (if possible). Thanks in advance