Hi. I have a table Sales_Orders and a related table Sales_Orders_Line_Items. I am trying to add a conditional expression on a Format Rule that would highlight โProduct Linesโ in a Sales_Orders_Line_Items table if the quantity has been changed from the original quantity entered. I know there is a [_THISROW_BEFORE] & [_THISROW_AFTER] function but that is just giving me a โUnable to find columnโ error. Can this be done and if so could someone advise on the right conditional expression?
I have attached a screenshot of a detail view.
Thank you.
[_THISROW_BEFORE]
and [_THISROW_AFTER]
are only available in workflows, not in format rules. Even if they were available, they probably wouldnโt work as you need.
You would have to keep a record of โthe original quantity enteredโ to do what you want. You also need to consider what constitutes โoriginalโ: the value set when the order as first place? Or the most recent previous value in the case of several changes?
Thank you @Steve for the insight.
User | Count |
---|---|
33 | |
31 | |
30 | |
19 | |
18 |