Search This Blog

Wednesday, January 24, 2018

Tabular Form Serial Number Auto Generation Oracle Apex



1. Copy and Pest the javaScript at HTMLHader in the page.
<script>
function setNextSortOrder() {
  var highest=0;
  $(".sortorder").each(function(){
    if (this.value != "") {
      highest=Math.max(highest,parseFloat(this.value));
    }
  });
  $(".sortorder").last().val(highest+1);
}

</script>

2. Create a item and use default sql and select max value.
   and copy the item at "tabular form attributes" as PL/SQL Expression or Function Default ....

3.Copy and Pest sortorder at tabuler form item.
Element CSS Classes : sortorder


4. Finally copye pest the code on "Add Row" button -> URL Target
javascript:{apex.widget.tabular.addRow();setNextSortOrder();}

1 comment:

  1. Hi,
    I have tried this but sequence number not incrementing for new row.can you please help.

    ReplyDelete

PDF to Text Covert by Oracle Apex

Here are the steps to convert and get the character into a region by Oracle Apex. Step1.  Create a page and Copy-Pest the below code into Pa...