Skip to main content

Change an item label dynamically in Oracle APEX 20.1

Step 1: Create an Items as follows,

Source Item: P2_PARTY_TYPE 

Type: Radio Group
List of Values: Person - P; Organization - O; Agent - A; Vendor: V

Affected Item: P2_PARTY (Don't give label name. Let it be blank)



Step 2: Create dynamic action as follows,

Event = Change
Selection Type = Item(s)
Item(s) = P2_PARTY_TYPE
Condition = (No Condition)


True Action = Execute JavaScript Code
Fire On Page Load = Yes
Selection Type = (Blank)
Code = (please copy and paste below JavaScript code)

JavaScript Code:

if ($v("P2_PARTY_TYPE")=='P') {
    $("label[for=P2_PARTY]").text("First Name")
} else if ($v("P2_PARTY_TYPE")=='O') {
    $("label[for=P2_PARTY]").text("Organization")
}
else if ($v("P2_PARTY_TYPE")=='A') {
    $("label[for=P2_PARTY]").text("Agent")
}
else if ($v("P2_PARTY_TYPE")=='V') {
    $("label[for=P2_PARTY]").text("Vendor")
}

This code will change the label text of an item based on condition.

The demo is here

That's it. Happy APEXing!!!...

Comments

Post a Comment

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
2 comments
Read more

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
Post a Comment
Read more

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  manager ,                emp . hiredate ,                 nvl ( emp . sal , 0 )  salary ,                 nvl ( emp . comm , 0 )  commission            FROM  eba_demo_chart_emp emp ,                eba_demo_chart_dept dept ,                eba_demo_chart_emp mgr           WHERE  emp . deptno = dept . deptno             AND  emp . mgr      = mgr . empno  ( + )           ORDER   BY  emp . ename
9 comments
Read more