We are trying to build a custom approval workflow for FA WebADI Transactions.
User wants the functionality of sending the record to the approvers approver, if approver has modified the record prior to his approval.
Eg: Mass additions comes to A. A modifies the mass addition and approves it. This should not be allowed and workflow should goto A' s manager.
Issue I am facing is that, using LAST_UPDATED_BY I am not able to figure out if A has modified the record before approval. This is because on approval, the LAST_UPDATED_BY becomes A.
Even if we use workflow tables, we are not sure whether A has just approved or modified and approved.
Is there any solution to this conundrum?
We have gone with another approach to solve this. Instead of checking if approver has updated the record before approving, we put in form personalization which makes sure that record can be approved only after approving. (If there is an open workflow on the item, no updates would be allowed).