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 Spe...
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