I have a form "Task" which has a fileds such as Name, Desc, Date, Status. When the status field changes in this form and updated , then I need to update a field(Action) in another table with some value based on the status. For example in the Task form if the status field changed to "Approval and hit save button then the Action field in the other table update with "Submit for Approval'.
So I created a PL/SQL process with update statement with condition if status = 'Approval' . When I change the status to approval and save, this PL/SQL process works and update the action field with value
'Submit for approval " on the other table. it works fine. However Once the Status value is changed to "Approval" and if any other fields such as Name, desc changed, then also this process, does the update. How can I limit that the Process work only when the Status field updated and saved. Please help
Enviroment: apex.oracle.com Apex 5
Browser Chrom
George