Home/ Questions/Q 3022
In Process

vinish.ai Latest Questions

  • 0
  • 0
Asked: 2020-11-06T08:05:44+00:00

Add Row Item in Interactive Grid in Oracle Apex

  • 0
  • 0

HI,

i would like to add item number in IG then each row will be submitted into table.

i couldn’t find any solution.

Thanks,
Ratana

oracle apexquestion
Share
Leave an answer

Leave an answer

Browse

9 Answers

  1. it works..thanks!

  2. Please explain your question in detail.

    What I understand so far is, you are clicking on the Add Item button and then adding the records manually.

    Or you want the Item number to populate itself when the product has been selected?

  3. i want to populate Item Number once product is selected and Item number is not changeable by user cause it will insert into table.

  4. i mean that when i select product column, item number will  add 1. then if i add other row then select product column, item number 2 will be added automatically. It is sequence number of each row.

     

    Item No Product QTY
    1 A 12
    2 B 2
    3 C 3
  5. This answer was edited.

    Ok follow these steps to show the sequence for a column:

    Add the following JavaScript code line in the Function and Globar variable declare section of the page:

    var i = 0;

    Then create a dynamic action on the interactive grid for Row Initialization event and add 1 True action to execute JavaScript code and add the following code in it:

    i += 1;

    Create one more True action as Set Value and set the following properties:

    • Set Type: JavaScript Expression
    • JavaScript Expression: i
    • Affected Item: YOUR_ITEM_NUMBER_COLUMN

    Now save the changes and run the page to test.

  6. after test, i am facing an issue when user click on any column then Item column update value.

    1. first screen, when click on Add Item button

    1. second screen, when user click on Net Amount or Unit Price then Item column update value.

     

     

  7. perfect. thanks for ur contribution.