I have a parent “Orders” table and a children [Order Items] referencing “Order Details” table of which both tables have “Status” columns. I have an action “Fulfill Order” on the parent which fulfills the order and its [Order Items] children.
I have defined a “Fulfill Item” action on “Order Details” table which does partial fulfillment on orders, and created a Bot that watches for “Fulfilled” Status updates on that table with a condition that "If the count of [Order Items] is equal to the count of “Fulfilled” “Order Detail” of that Order then set the Order Status to “Fulfilled”. The condition works but Order Status is never updated.
Show more details, like EVENT, PROCESS, STEP
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |