Skip to main content

Implementing Dynamic Flexible Fields (flexfields) in Oracle APEX

I like to share my approach on capturing additional information if all attribute columns (flexfields) on a table have been used up.

This implementation does not require altering any existing table(s) instead it gives administrators and/or superusers the ability to dynamically manage additional information capture within the application.

Below are steps taken:


  1. Create tables FLEXFIELD_REGISTRY (This stores the flexfields setup data) and FLEXFIELD_VALUES (This stores the values captured on flexfields)
         FLEXFIELD_REGISTRY
         FLEXFIELD_VALUES
 
        
 
   2. Create an interactive grid to manage flexfield setups
   

  3. Create additional information form
     


Application Demo Link: Flexfield Feature Demo
Credentials: demo/demo1234$


Comments

  1. AshokMarch 8, 2021 at 12:00 AM

    Could you please share the application source.

    I am working on the similar functionality to adapt the Flexfields.

    It will be very helpful for me.


    Thanks in Advance

    Ashok

    ReplyDelete
    Replies
    1. KehindeMarch 26, 2021 at 10:35 PM

      Hi Ashok,

      Please follow the link:
      https://apex.oracle.com/pls/apex/f?p=100471

      Delete
  2. David VegaNovember 16, 2021 at 8:17 AM

    When I create the additional information form, the fields are not displayed. Might you help me?

    ReplyDelete
    Replies
    1. Kehinde AdeyemiNovember 26, 2021 at 5:04 AM

      Hi David,

      Please share your email id.

      I should be able to assist you

      Delete

Post a Comment

Popular posts from this blog

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 Special Characters' on the SELECTEMP column to 'No' 6. Run the report and see the changes when you select/unselect the checkbox in the heading Happy APEX Exp
1 comment
Read more

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