Skip to main content

Posts

Showing posts from October, 2019

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: 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$