Changing value in parent table based on Related Child

[Jamal_Mh]

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.

[Fernando_Lopez1]

Show more details, like EVENT, PROCESS, STEP