How to create user define help (Oracle APEX)

How to create user define help (Oracle APEX).

Idea of this blog is to show how can we create user define help for our pages in applications. Application will be develop under Oracle Cloud Template you can copy it from all Oracle Applications in Package Applications.

Step One Create Tables

First of all we need to create two table where we will store our help text and user settings for help
Table for storing help text and user setting for help will have next structure:

Step Two Create Package

To extract and print help we will use package with two procedures

Package spec:

Dodaj naslov

Package body

Step Three Create Global Page

Now in our application we need to add 0 Page or Global page with two Dynamic Actions and one check box and one PL/SQL region.

In PL/SQL region (don't have name) we will call our procedure for printing help (Template need to be Modal and Static ID need to have value of 'help' or some other define by you)

P0_SHOW item need to look like 

and its default value need to be status of help

Then we create dynamic action for P0_SHOW item 

PL/SQL Code for this (true/false) action are:

For TRUE help_util_pkg.turn_on_off_help('Y');

For FALSE help_util_pkg.turn_on_off_help('N');

Now we need code to call all of this from any page. We will create another dynamic actions like

Now all you need is to populate tables with help text (can be used in html format) and user settings. Also you can place on Navigation Bar Entries who call javascript:openModal('help') so user can turn of or on help. 

The Result

Now when user first time open the page, if help is defined popup will show with help text. User can check it to turn it off or leave it. Another thing is that user can define this text updating or inserting data in tables.