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
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
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?
ratana
i want to populate Item Number once product is selected and Item number is not changeable by user cause it will insert into table.
Vinish Kapoor
In this case, make the item number column hidden and set its Value protected property to No (off).
Make the Product column as a select list or LOV list. Then create a dynamic action on the change event of the product column list and set the following properties:
For more details on Set Value dynamic action, check the following tutorial:
Oracle Apex: Dynamic Action Set Value Example
ratana
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.
Vinish Kapoor
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:
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:
Create one more True action as Set Value and set the following properties:
Now save the changes and run the page to test.
ratana
it works..thanks!
ratana
after test, i am facing an issue when user click on any column then Item column update value.
Vinish Kapoor
Ok, then do one thing.
For the dynamic action you created on Row initialization, specify the client-side condition Item/Column is null and specify the item number column for the column field.
Then it will not update the sequence number again.
ratana
perfect. thanks for ur contribution.