Interactive grid most beautiful feature of Oracle Apex 5.1, it’s adapt with the form, as well reporting feature. So while creating the interactive grid we are facing the issue how to create dynamic action when column value changes. In this post we can see the step by step process creating a simple dynamic action for interactive grid.
Step 1: Create Interactive grid with this sample query
select EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, ONLEAVE, NOTES, DEPTNO
from EBA_DEMO_IG_EMP
Step 2: You can see the interactive grid by like this, look the job column there is radio group of different job categories.
Step 3: Our dynamic action requirement is disable / enable of commission column based on job category selection.
for ex: If Job = Salesman Enable Commission Column else hide commission column
Create a simple dynamic action on change of job category radio group looks like below snap
the true condition is looks like below snap
and the false condition is looks like below snap
that’s it finally you got the result enable / disable the columns based on the column value in oracle apex 5.1 interactive grid.