Create Application Dashboard in Oracle APEX - Part 4

In this video, you’ll create the home page of the sample database application, which is a dashboard that users see when they successfully access the application after providing valid credentials. The Home page contains six regions to display different summarized information. It uses a 12 columns layout to place these regions accordingly. Besides the application name and logo, the page carries the main navigation menu, which is used to move to other application segments. The navigation bar on the top right side allows you to log out of the application. By default, it displays the id of the currently logged-in user, along with a Sign Out link. The Feedback option on the Navigation bar provides a mechanism for end users to post general comments for application administrators and developers. You can add more options to this bar. The body of a page can have multiple regions that act as containers to display information from database tables. You can place buttons in regions that act as links and allow you to access other application pages to get further details. In addition to buttons, the page also contains text links to dig into the details of the summarized information. Using the options provided in the Developers Toolbar, you can switch to the Page Designer instantly and perform various other development tasks. The Install App option appears when you choose Progressive Web App (PWA) option while creating a new application. When users tap the Install App option, the application is opened in a standalone window, which is free of the browser's UI. You can also add a banner to your application.

What You’ll Learn
===============
How to create dashboards in Oracle APEX web applications
Adding multiple regions to a page to segregate content
Use of 12 columns grid layout to arrange multiple regions on a page
Create links to drill down into details
Badge List, Pie Chart, and Bar Chart to display data in different graphical formats
Summarized text information
Using buttons to navigate to other application pages

Topics covered in this video
=======================
Transform the default blank Home page into a dashboard to display summarized data
Create bar charts
Create a Pie chart
Set chart labels and values
Show and hide chart legends
Define links on charts using link builder to access information on other application pages
Create a badge list
Create text links to access information on other Oracle APEX application pages
Adding multiple regions to show different information on a single page
Set region position on a page using "column" and "column span" attributes
Specify data source for a chart using SQL query
Show region icon and set region height and width
Create a hidden item to store some value - for example, the first day of the current month
Use of PL/SQL Expression
Transform the column text field into a link
Apply numeric format mask
Specify parameters and pass on values to a target page using Set Items
Use substitution string to access the value of a page item
Reset pagination of an interactive report using RIR
Change a chart's appearance using different types of colors
Add buttons to regions to access other application pages
Apply CSS at the user interface level
Add a CSS file to an Oracle APEX application with APP_FILES
Apply styling to a region using a class rule specified in the CSS file
Hide page components with the Never Server-Side Condition

Download Source Code From Here:-
https://drive.google.com/drive/folder...

Create Free Workspace in Oracle APEX:-
   • How To Create Free Workspace in Oracle APEX  


The content of this video is taken from my book "Create Rapid Low-Code Web Applications in Oracle APEX"
https://www.amazon.com/Create-Rapid-L...