Friday 7 August 2015

DYNAMICALLY ADDING ROWS IN TABULAR FORM IN ORACLE APEX 4.2


A good web design involves the better user interaction and ability to fetch the data in a better way. In Tabular Form user can add rows only by clicking Add Row Button every time. Using this technique user can add multiple entries without clicking Add Row Button and submit them simultaneously.
This is a simple and effective solution for creating multiple entries where the number of rows to be entered is indeterminate.

Step 1: Create Tabular Form  


Step 2: Create Select List in the Tabular Form (Ex: “P22_choose_no_of_rows_to_be_added”) 


Step 3: Write JavaScript Function in Page Header







Step 4: Creation of Dynamic Action




















Step 5 : Call the function f_addRow() in Dynamic True Action



Step 6: Write JavaScript in Cancel Button


















OUTPUT:

1. If No row Selected:













2. If No of rows Selected:
















3. While Clicking Cancel Button


3 comments:

  1. Hello, thank for you post.
    are there any way to load value to a "virtual table" on APEX in contraposition to a form table based??
    example: a user select item from a combobox y this value is loaded into a "virtual table o collecition" dinamicaly, it also can delete item previously loaded.

    regards.

    ReplyDelete
  2. What is the List of Values Query in PX_choose_no_of_rows_to_be_added selected list?? Because in APEX 5.0 we have to input LOV Query for Select List.
    Thank You

    ReplyDelete
  3. i am facing an error,
    when i add new row in tabular form and fill all the details and click submit then an error occurred
    ERROR============
    Error in mru internal routine: ORA-20001: Error in MRU: row= 1, ORA-20001: ORA-20001: Current version of data in database has changed since user initiated update process. current checksum = "A884FA378C851786DDFE3A33709CB23C", item checksum = "7CA7222841395E3C1BF9A54BC17725A2"., update "HRMSADM"."IFFCOEMPL" set "EMPLOYEEID" = :b1, "EMPNAME" = :b2, "UNITCODE" = :b3, "UNITNAME" = :b4, "STATEOFFICE" = :b5, "IFFCOMAIL" = :b6, "GMAIL" = :b7, "ROLE" = :b8
    Unable to process update.

    pls help me
    jsdwivedi1995@gmail.com

    ReplyDelete