I'd like to create an email alert if an approved order contains certain order products. I'm trying to do this via a workflow rule. Is this possible?
I've tried creating a rule on the Order object but Order Product fields can't be accessed. This doesn't work on order products since the order product isn't updated at all when the order is activated (so rule is never triggered). So I tried to create a Field Update that would check a hidden checkbox on Order Product if the Order was approved. However, Approval Process cannot access this field update (does not support cross-object field updates). And again, neither can a rule on the order object.
I'm at a loss here. Any advice would be greatly appreciated. I should mention, unfortunately we cannot use process builder or flows to accomplish this.
7 réponses
You will be able to use it. You can call apex using flows or PBs to recalc for you. I'll encourage to use flows so you can also get it to run when a record is deleted.
