In my oracle apex form , when user change the status field value to "Assigned" from "New" and save , an email to be sent to the assigned user. for this purpose i created a process After Submit with PL/SQL function and attached to the save button. it works fine when the status changed to "Assigned" from New, However it also send email when any other field is updated while already the status= "Assigned". How can I limit the process execute only when status changed "Assigned" only . it should not send email when status is still "Assigned" and other fields are updated. ?
Thanks
George