3 Replies Latest reply on Oct 13, 2017 2:24 AM by LA County APEX

    HOW TO AUTOPOPULATE HIDDEN COLUMN CELL WHEN NEW RECORD ADDED - Interactive Grid (IG)

    Gor_Mahia

      Hi,

       

      ive a simple interactive grid based on one table like,

       

      emp(empno    number(4,0),

        ename    varchar2(10),

        job      varchar2(9),

        mgr      number(4,0),

        hiredate date,

        sal      number(7,2),

        comm     number(7,2),

        deptno   number(2,0),

       

      THE RECORDS are saved based on JOB i.e for each saved reports under Action Menu the JOB column is identical value. So i want to auto populate new job column cell with the JOB value for the selected report whenever a record is created.

       

      I tried using jquery it doesn't work it seems the template structure isnt what it used to be with id/class/headers etc.

       

      Any idea is appreciated.

       

      Apex 5.1.2.- Universal theme

       

      thanks.