Plug In: Number Field with Decimal

It's a Number Field with Decimal Plugin In, which allow only Numeric Values and one DOT and Specified decimal value (2 or 4) in Number Field.

Plug-In Details:


DB versions: 12.1.0.1, 12.2.0.1, 18.4.0.0, 19.0.0.0.0, 19.2.0.0.19, 21.0.0.0.0, 21.1.0.0.0, 21.1.0.0.1

APEX versions: 20.1.0.00.13, 20.2.0.00.20,  21.1.0



Installation:

Go to GitHub and export plugin file "item_type_plugin_orclking_number_field.sql" from Source directory and import it into your application.

Steps to Achieve:

Step 1: Create a new blank page.

Step 2: Export plugin file "item_type_plugin_orclking_number_field.sql" from Source directory and import it into your application.

Navigation: Shared Components ==> Plug-ins ==> Import


Plugin will be listed under plug-ins bucket after successful installation.


Step 3: Create a region to the page. Region type should be Static Content.


Step 4: Create a item to the region. Change item type to "Number Field with Decimal [Plug-In]".


Step 5: In the Settings section you can choose some options. The image below shows all the available options.


  1. Element Text Position - Position of the field value (Left/Right)
  2. Min. Value - Specifies the minimum value allowed
  3. Max. Value - Specifies the maximum value allowed
  4. Digits - Specifies the decimal value allowed

Output: Then you output would display like this,


The demo is here.

That's it.

Happy APEXing!!!...

Comments

Popular posts from this blog

Highlight the cell of Interactive Report based on Search Criteria in Oracle APEX

Number of Tables by The Number of Rows in Oracle Database

Querying Data From Flat Files in Oracle

Highlight Data That Meet Certain Criteria in Oracle APEX Report

Return a Validation Message using JavaScript if the Oracle Application Express Item is Empty

Find Where Specific Table or View is Used in Oracle Database

Save Selected Interactive Grid Records into a Collection - Oracle APEX

Remove X (Close Mark) from Oracle APEX Modal Dialog

[Loner Tables] Find Tables Without Relationships in Oracle Database

Change the color of the rows alternatively using a Simple CSS in Oracle APEX IR & IG Reports