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

Restrict File Upload by File Type in Oracle Apex

If you want to restrict file upload by file type/extension/format you can follow the below steps.  Goto File Browser Item --> Advanced --...