Skip to main content

Weighing Scale Integration with Oracle APEX

 Please check out the documentation on the link below:

https://apex.oracle.com/pls/apex/f?p=100471:6:6084788408040:::::

Hope it helps someone.

Comments

Post a Comment

Popular posts from this blog

How to upload and embed a pdf document within a page in an Oracle APEX Application

Some Oracle APEX customers prefer to view embedded PDF documents directly within a page in their application rather than having to download. My current case study allows users to upload a .pdf document, save directly to a file location (rather than a DB Column) and view same embedded on the current page as shown above. Steps taken: 1. Identify the physical location of the #IMAGE_PREFIX# (/i/), in my case it is/u01/userhome/oracle/apex/images 2. Create a folder called 'docs' in the directory logged in as user SYS $ cd /u01/userhome/oracle/apex/images $ mkdir docs 3. Create a database directory called MY_DOCS create or replace directory MY_DOCS as '/u01/userhome/oracle/apex/images/docs'; Directory MY_DOCS created. grant read,write on directory MY_DOCS to {WORKSPACE_SCHEMA}; Grant succeeded. 4. Create a page within your application with following create page items PXX_FIRST_NAME (Textfield), PXX_LAST_NAME (Textfield), PXX_UPLOAD_DOC (File Browse), PXX...
Post a Comment
Read more

Select/Unselect All Checkboxes in a Classic Report in Oracle APEX

Below are simple steps to select/unselect all checkboxes in a classic report: 1. Create a page with a classic report based on a sample query      select apex_item.checkbox(1, EMPLOYEE_ID) selectemp,        EMPLOYEE_ID,        FIRST_NAME,        LAST_NAME,        EMAIL,        PHONE_NUMBER,        HIRE_DATE   from EMPLOYEES 2. Add static ID : emp on the classic report region 3. Add below Javascript on the page function handleClick(cb) {     if  (cb.checked === true) {   $('#emp input[type=checkbox][name=f01]').prop('checked',true);       } else {   $('#emp input[type=checkbox][name=f01]').prop('checked',false); } } 4. Change the heading on the SELECTEMP column of the report to below              5. Ensure you set 'Escape Spe...
1 comment
Read more

Dynamic Collapsible Regions in Oracle APEX

  Introduction Recently, I was asked to create a screen that displays the status of the entries in each collapsible region and makes sure users only work on one collapsible region at a time. This article will demonstrate how to complete this task by following a few simple steps. The theme used: Universal Theme. Step 1 In this example, I have included 3 collapsible regions with respective static ids region1,region2 and region3 and 'Remember Collapsible State' checked for all. In the 'Function and Global Variable Declaration' section add below Javascript COPY function f_navigator ( pVal ) { if ( document .getElementById(pVal).value == null ) { document .getElementById(pVal).value = 1 ; $( '#' + pVal + '.a-Collapsible.is-collapsed' ).removeClass( 'is-collapsed' ).addClass( 'is-expanded' ); $( '#' + pVal + '.a-Collapsible .a-Collapsible-content' ).show(); var myArrayselected = [ "r...
Post a Comment
Read more