Workflow triggering with column increase/decrease, is it possible?

hsghost
Participant I

Hi, I’d like to know if it is possible to trigger a workflow when the value on a certain numeric column is increasing/decreasing. Currently I can only trigger it with ANY changes to the table. Is there an effective way that I can quote the previous value and the current value in the Condition field, so that an incremental/decremental change could be tracked down to trigger the appropriate actions upon?

Thanks.

0 4 279
4 REPLIES 4

Steve
Participant V

Aha, that is exactly what I wanted.

Thanks a lot!

Umm, another question arose. I discovered that [_THISROW_BEFORE] and [_THISROW_AFTER] are only valid for workflows and cannot be used on data formulae. So, how can I track the value difference on, say, a [Product Qty] increase on an order, so that it can be automatically deducted from my inventory? Right now I can only do the deduction upon order creation. But sometimes order modifications do happen in our use cases.

Many people ask that question. The solution is entirely dependent on your app. I’m afraid I have nothing to offer.

Top Labels in this Space