Oracle APEX - Warn unsaved changes for custom fields

By
Oracle APEX 5 introduced a new feature called "Warn on Unsaved Changes" at page, item and button level. This is a great feature by enabling any unsaved changes to ask for user confirmation before leaving the page.

Purpose of this blog is, if we have custom form element such as APEX_ITEM on a classic report or IR, will that by-default use this feature? Answer is No. You have to write code for that.

I have seen there are several ways people have implemented this using custom code and logic. Now, here I have tried to use one of the APEX's JavaScript library function to achieve this.



Following are the steps:

1. Set "Warn on Unsaved Changes = Yes" from page attribute section.

 2. Declare a new variable under "Function and Global Variable Declaration" from page attribute section as below

 var gSerializeValue;

 3. Create new dynamic action named "Initialize Warn on Unsaved Changes" as on page load event.

 4. Add true action "Execute JavaScript Code" with following code.

 gSerializeValue = $('[name="f01"],[name="f02"]').serialize();

 var fnIsChanged = function(){
  var lSerializeValue = $('[name="f01"],[name="f02"]').serialize();
  if(gSerializeValue === lSerializeValue){
    return false;
  }
  else{
    return true;
  }
}

apex.page.warnOnUnsavedChanges('', fnIsChanged);

 5. You are done, test it by changing the value and try to reload the browser or navigate to some different page without submitting page.

 Working Demo

 Hope this helps!

 Regards,
Jaydip Bosamiya
jbosamiya@gmail.com

Comments

  1. AshiFebruary 3, 2020 at 3:02 PM

    Didn't work

    ReplyDelete
    Replies
    1. Jaydip BosamiyaFebruary 24, 2020 at 1:01 PM

      Hello Ashi, may I know what error your are getting?

      Delete
    2. AshiJune 22, 2020 at 11:38 AM

      Actually I am trying this on a form which is made of apex items. But it doesn't work. No errors, simply goes to another page without the popup

      Delete
  2. AshiFebruary 26, 2020 at 8:55 AM

    Didn't work for me either

    ReplyDelete
    Replies
    1. Jaydip BosamiyaFebruary 26, 2020 at 10:23 AM

      Hello Ashi, may I know what error your are getting?

      Delete
  3. venkyMarch 31, 2020 at 7:57 PM

    Hi Jaydip

    Thanks for adding this, the above code is working leaving page.

    I have a navigation link from the one report to another editable region, if user changed column value and I want show the alert and if user select CANCEL in the confirmation popup, need unbind the link click event.

    Appreciate your help.

    ReplyDelete

Post a Comment

My photo
Jaydip Bosamiya
I am Oracle APEX Consultant, Blogger and Integrator. All-rounder in building small, medium and enterprise applications. Extensive knowledge in various area of web-driven applications in Back-end (PL/SQL, SQL, Java), Front-end (Oracle APEX, HTML, JavaScript, CSS, jQuery, OracleJET, ReactJS), RESTful APIs, Third-party library integrations (Apex Office Print (AOP), Payment Gateways, Syncfusion, HighCharts) and APEX Plugins (HighChart, StarRating)

Popular posts from this blog

Oracle APEX - Interactive Report - Scrollbars on Top

By
Image
I have been came across an interested requirement ( which is very valid ) to add scrollbars on the top of the regions! I have seen many times when you want to scroll right to see further data of first few records, you will scroll vertically to get to the horizontal scroll-bars. And then you do horizontal scroll and then vertical scroll to go top of the region. Aren't you ??? :-) So, to ease the user interaction with IR - we should have a scrolling option somewhere on the top of the region ? - For Sure So, how can we add scrollbars on top of the report for an Interactive Report ? By default IR Fix the column headers to the page. This setting gives us an opportunity to add scroll-bars just below the column header as well. Just by adding following CSS line you should get a beautiful scroll-bars just below you header and it works really great as well. #MYIR .t-fht-thead{   overflow: auto !important; } I am also trying to find a way to add same function
Read more

How to create your own customized nested report regions using jQuery

By
Image
Here is how you can create cool nested reports in Oracle APEX and jQuery, which looks like below: For this example, I have used DEPT & EMP example where as a nested report it will show all the child records of employee under department record. To start with, first create a new classic report region with query like " select * from dept ". Add a new derived column of type = Link to that report and set following attributes: Link: javascript: void(0); Link Text: <i class="fa fa-users" alt="Employees" title="Employees"></i> Link Attribute: class="viewEmp" data-deptno="#DEPTNO#" Add new page item to hold deptno value and call it PX_DEPTNO Create new classic report region (this will be your nested region) and set query like " select * from emp where deptno = :PX_DEPTNO " and set following attributes: Static ID:  EMPLOYEES Custom Attributes:  style="display: none" Page Items t
Read more

Oracle APEX - Build Your Own Enhanced Nested Report

By
Image
With lots of feedback and suggestions - which inspired me to dig further into Customized Nested Report and see how we can enhance this further. So, purpose of this blog is to highlight you how you can further enhance  Customized Nested Report . I have tried to add following new things to enhance custom nested reports capabilities. You can try and design your own nested report the way you want. These are just couple of examples that I have created for demo purpose. 3 & 3+ level of nesting with Classic Report Different templates of nested classic reports Classic Report with Badge Template Classic Report with Comments Template Download full application and try it in your own environment. Please note that, it requires default tables EMP & DEPT with some valid data. Working Demo 2 Level Nested Report 3 & 3+ Level Nested Report Nested report as Badge View Nested report as Comment view Please note that, application and
Read more