Skip to main content

Checkbox Font Color using HTML in Oracle APEX

 

Here I am giving an example to change checkbox font color using HTML in Oracle APEX.

Step 1: Create a Page.

Step 2: Create a Region.

Step 3: Create a Checkbox item.


Step 4: Create List of Value.
  • Go to Shared Components.
  • Click on List of Values under other components.
  • Click on Create option to create LOV from scratch.
  • Choose LOV source as "From Scratch"
  • Give valid name and choose LOV type as "Static"
  • Enter Static Display Values as below,

  • Click on Edit icon and copy and paste below HTML code, which will change the color of display value.
        

HTML Code:

<span title="#DISPLAY_VALUE#" aria-label="#DISPLAY_VALUE#"><span style="color:green;font-weight:bold;font-style:italic">#DISPLAY_VALUE#</span></span>

Step 5: Go to page item's list of values and choose fxgn_checkbox_values (LOV) from shared components and set it.


Step 5: 
Go to Page item's security and set Escape Special Characters = 'YES'


Output:
The demo is here

That's it.

Happy APEXing!!!...

Comments

Popular posts from this blog

Printing Page Numbers in RTF Template [Oracle BI Publisher]

Here I am giving an example to print the page numbers dynamically in the RTF (Rich Text Format) template. Step 1:  Go to page footer and copy and paste the below script. Page |  <?fo:page-number?>  of  <?fo:page-number-citation:xdofo:lastpage-joinseq?> <fo:page-number> :   This is the object, which is used to represent the current page-number. <?fo:page-number-citation:xdofo:lastpage-joinseq?> :  This is the syntax, which is used to represent the total number of pages. Step 2:  Load the XML and preview the result. Output: That's it. References: fo:page-number Printing Page Number Code in Oracle XMLP RTF Template

Oracle Application Express Views (APEX)

Application Express Views Search SELECT * FROM apex_dictionary WHERE column_id = 0; View Comment Parent View APEX_APPLICATIONS Applications defined in the current workspace or database user. APEX_WORKSPACES APEX_APPLICATION_ALL_AUTH All authorization schemes for all components by Application APEX_APPLICATIONS ...

Save Selected Interactive Grid Records into a Collection - Oracle APEX

Here I am giving an example to save selected interactive grid records into a oracle apex collection. Step 1: Create a new blank page. Note: Mine was page 20. You will need to update reference to " P20 " with your page number if it's different. Step 2: Create a new interactive grid report region to the page using below query. Set Static Id "EmpDetails" to the region. SELECT  *     FROM   ( SELECT  emp . empno ,                emp . ename ,                emp . JOB ,                dept . dname department ,                dept . loc  LOCATION ,                mgr . ename  ...