Posts

Showing posts from August, 2021

Show Help Text using JavaScript in Oracle APEX

Image
  This blog explains, how to Show Help Text using JavaScript in Oracle APEX.  Follow the below steps to achieve this. 1) Create a Region .  2) Create a Button in the region. 3) Create an  On Click dynamic action for the button. 4) Create a True Action (Execute JavaScript Code) and paste the below code. apex . theme . popupFieldHelp ({     title :   "Help" ,     helpText :   'This is a help text box' }); The Help Text also accepts HTML. Below is an example on how to use HTML in the help text. apex . theme . popupFieldHelp ({     title :   "Help Text with HTML" ,     helpText :   '<style>' +                    '.li-color {color:blue;}' +                '</style>' +                '<ul>' +                    '<li class="li-color"><b>This is a help text box that accepts HTML formatting</b></li>' +                '</ul>' }); Click here for DEMO Hap

IG Hack - #4, Change the column width of Interactive Grid using JavaScript in Oracle APEX

This blog explains, how to change the column width of and Interactive Grid using JavaScript. Follow the below steps to achieve this: Example - 1: Set the Column Width for a single Column. 1) Put the below JavaScript Code in the Page -> JavaScript -> Execute When Page Loads section. apex . region ( "EMP_IG" ). call ( "getViews" ). grid . view$ . grid ( "setColumnWidth" , "EMPLOYEE_NAME" ,2 00 );   Note:  In the above code, the width of the Employee Name column is set to 200.  Replace EMPLOYEE_NAME with the name of your column that you want to set the width for. Replace EMP_IG with the Static ID of your Interactive Grid. Example - 2:  Set the Column Width for all Columns. 1)   Put the below JavaScript Code in the  Page -> JavaScript -> Execute When Page Loads  section. var  igView  =  apex . region ( "EMP_IG" ). call ( "getViews" ). grid . view$ ,     colArray   =   [];      colArray  =  igView . grid ( &q