..the apex plugin directory

an initiative of

Add your APEX Plugin info

Describe your Plugin’s features. You can upload the Plugin’s code and documentation, or, alternatively, submit the URLs to your Website, GitHup Repository or Blog.

You are here:
Follow us on Twitter
Item Plugin Flexfields


Categories: Item Plugin
Author: Josep

Changing field types dinamically

Some applications leave administrators the capability of extending its application by adding some fields to existing tables. In that case, administrator can expand application functionality by storing some data to application without the need of technical assistance.

Demo: https://apex.oracle.com/pls/apex/f?p=JOSEPCOVES:FLEXFIELD

Tutorial: http://www.relational.es/blog/en/apex-relational-flexfield-plugin-tutorial/ 

 SQL source options:


       FLEX_NAME,        --(varchar2) Flexfield name

       FLEX_DESC,        --(varchar2) Flexfield description -> Shown at help

       FLEX_TYPE,        --(varchar2) STRING, LOV, LOVSQL, TEXTAREA -> Type of flexfield

       FLEX_LOV,         --(varchar2) Name of APEX LOV for LOV type flexfields

       FLEX_NULLABLE,    --(char(1))  S, N -> Specifies if allows null values

       FLEX_SIZE,        --(Integer)  Size of the HTML element

       FLEX_MAX_LENGTH,  --(Integer)  Max length of its content (only for STRING and TEXTAREA types)

       FLEX_HEIGHT,      --(Integer)  Height of HTML element (only for TEXTAREA)

       FLEX_HTML_ATTR,   --(varchar2) Additional HTML element attributes

       FLEX_LOV_SQL      --(varchar2) In case TYPE= LOVSQL this column specifies LOV SQL returning pairs display value and return value


where flexfield_name = 'MyField01' 

Special Requirements
- An existing data base table with N flexfield fields of varchar2(4000) to fill

- Optional: flexfield metadata table (FLEXFIELD_DEF, see example below)

- This plugin on some page

flexfields, item type, apex

Oracle APEX Plugin
Date added: 17.11.2015
Views: 3839
Votes: 2
Reviews: 0
Min. APEX Version:
Share on Facebook
Digg! Share on Digg
Save This Page
Link to:
download apex plugin
If something is not correct please report it here: Report Listing
Do you have a question about this Plugin? Want to write a Review or Comment?
Login first.
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
Powered by Sigsiu.NET RSS Feeds

Disclaimer: The APEX Plugins on this site are not supported by Oracle Support Services.

If you have a question about a Plugin or need support: Login and select the plugin detail page. At the bottom you can enter your Question / Review / Remark.
Your message will be sent to the author of the plugin.