CODEWITHSUNDEEP
oracle-apex
Velocity
Velocity

Reputation: 479

Oracle Apex Interactive Grid When delete set column null/any value

Can we modify interactive grid such that when we select and delete a row, instead of deleting the entire row, a column of that row gets updated to a particular value?

If it can be done using dynamic actions can you please suggest how?

Ex of my interactive grid-> enter image description here

So when i select the 3 lines next to check box and choose option to delete row, it shows the row as strike off. But actually instead of deleting it would set Approver column to 'Not Approver'

Upvotes: 0

Views: 1331

Answers (1)

Chaitanya Koratamaddi
Chaitanya Koratamaddi

Reputation: 261

Here's how you can do by creating a button and then defining a dynamic action. 1)Set the static ID of your IG 2)Create a button and set it to Defined by Dynamic Action 3)Set the True action to execute Javascript Code. Now, your Javascript code should include to set the value of a column in a record by using the setValue method.

Upvotes: 0

Related Questions