Interactive Grid simple dynamic action

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.

dynamic1

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

dynamic2

the true condition is looks like below snap

dynamic3

and the false condition is looks like below snap

dynamic4

that’s it finally you got the result enable / disable the columns based on the column value in oracle apex 5.1 interactive grid.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s