Home/ Questions/Q 608
In Process

vinish.ai Latest Questions

  • 1
  • 1
Asked: 2020-09-12T15:05:13+00:00

How to create warn on unsaved changes when item = value in Oracle Apex

  • 1
  • 1

Hi!

I want to warn on unsaved changes when item = EDIT, I use the same page for reading and editing. I have an item which contains EDIT or READ_ONLY. I want to warn only when item = EDIT and when the user wants to close the tab. 🙂

Thanks in advance!

javascriptoracle apexquestion
Share
Leave an answer

Leave an answer

Browse

6 Answers

  1. This answer was edited.

    Select Item. Go to Advance ->Warn on Unsaved Changes->Select Page Default

  2. This answer was edited.

    Works for Chrome and Firefox, thanks a lot Vinish! 🙂

  3. Hi Pavlos,

    Put the below JavaScript function in the page’s function and global variable declare section:

    window.onbeforeunload = function (e) {
e = e || window.event;
if ($v("P18_TYPE") == "EDIT") {
if (e) {
e.returnValue = '?';
}

// For Safari
return '?';
}
};

    Change P18_TYPE with your page item.

    Also, you can return any message from the function, but it shows only the default message in Chrome.

    Please try and let me know if it works.

  4. This answer was edited.

    Works for chrome. Function returns warn when I click on the SAVE button, how to avoid this?

    • I have applied this and it works.

      Let see, follow these steps:

      Create one more hidden item Px_SAVE and set the default value type Static and value as N.

      On the save button. Create a dynamic action to execute the JavaScript code and add the following code in it:

      apex.item("P18_SAVE").setValue("Y");

      Now click on the Save button and you will find its action type to Dynamic Action, revert it to the Submit page.

      And now change the main JavaScript function as below:

      window.onbeforeunload = function (e) {
e = e || window.event;
if ($v("P18_TYPE") == "EDIT" && $v("P18_SAVE") == "N") {
// For IE and Firefox prior to version 4
if (e) {
e.returnValue = '?';
}
// For Safari
return '?';
}
};

      Please test and let me know if still any issues.