I have a bot that creates rows for delivery stops. Then it assigns the first order to the stop with the highest priority.
Then another bot fires every time a Stop row is created or updated. It updates the un-ordered stops with a value that it uses to assign the next order. It repeats this until all the un-ordered stops are given a delivery order.
It seems like the second bot it firing before the first one has assigned the first stop and finished. When I try to just set the second bot to fire when the table "updates only", it will fire once and then stop.
When I disable the second bot, the first one completes and assigns the first stop without a problem.
I'm looking for a way to tell the second bot to wait until the first one has completed?
LinkedIn
Twitter
