Requirement: We have a Text Field, and we want to ensure that whatever value we enter in this Text Field is only an Integer value.

In case the user tries to enter any value other than the Integer value it will simply not be entered into the Text Field.

Solution: For solution of the above requirement follow the steps as shown below:

Step 1: Create an Oracle APEX page. Create a Region inside the page and set Title as Allow only Integer Value

Step 2: Create a Page Item inside the above created Region. Set the properties for the Page Item as below:

• Name: P6_ENTER_VALUE
• Type: Text Field
• Label: Enter Value

Go to the Advanced section of the property palette of the Page Item and set the below properties

• CSS Classes: allow-integer

Step 3: Let us add the following jQuery code to the Execute when Page Loads section for the page:

$(".allow-integer").bind("keypress", function (e) {
    var keyCode = e.which ? e.which : e.keyCode               
    if (!(keyCode >= 48 && keyCode <= 57)) {
        return false;
    }else{
    
	}
});

Save and run the application. Thus, the ran application is shown below:

Try to enter values other than the Integer value, and we can see it is not allowing us to enter the value. When we enter Integer value, say 123, it has excepted the Integer value 123 as shown below:

Hence, the solution to our requirement.

If you like the post please comment, share, and do join me on Facebook. Please subscribe to my YouTube Channel for video tutorials.

Thanks & Regards,
Susanto Paul

 360 total views,  3 views today