Form Handling

Default tables

By default, FlowForms uses default tables to store input information, forms, published forms, file blobs, lists of values, and submitted data. The default tables are created in the schema of the APEX application and are described below.

UC_FLOWFORMS_FORM

For storing form definitions

Column Name	Data Type	Nullable	Primary Key	Description
ID	NUMBER			Column is used to uniquely identify a form
FORM_NAME	VARCHAR2(255)			Column is used to store the name of the form
FORM_LABEL	CLOB			Column is used to store the label of the form in multiple languages
FORM_DESCRIPTION	VARCHAR2(4000)			Column is used to store the description of the form
CREATED	DATE			Column is used to store the date the form was created
CREATED_BY	VARCHAR2(255)			Column is used to store the user who created the form
UPDATED	DATE			Column is used to store the date when the form was updated
UPDATED_BY	VARCHAR2(255)			Column is used to store the user who updated the form

UC_FLOWFORMS_NODE

For storing form inputs and their respective properties Some fields are not yet in use but are there to be used in the future

Column Name	Data Type	Nullable	Primary Key	Description	Used
ID	NUMBER			Column is used to uniquely identify a node
FLOWFORM_ID	NUMBER			Column is used to store the reference to the node
SUB_FLOWFORM_ID	NUMBER			Column is used to store the reference to another form
NODE_ID	NUMBER			Column is used to store the reference to the node
NODE_NAME	VARCHAR2			Column is used to store the name of the node
LABEL	CLOB			Column is used to store the label of the node
FIELD_WIDTH	NUMBER			Column is used to store the width of the node
SORT_INDEX	NUMBER			Column is used to store the sort index of the node
HELP_TEXT	CLOB			Column is used to store the help text of the node
PLACEHOLDER	CLOB			Column is used to store the placeholder of the node
DEFAULT_VALUE	VARCHAR2			Column is used to store the default value of the node
DISPLAY_CONDITION	VARCHAR2			Column is used to store the display condition of the node
IMG	BLOB			Column is used to store the image of the node
IMG_FILENAME	VARCHAR2			Column is used to store the image filename of the node
IMG_MIMETYPE	VARCHAR2			Column is used to store the image mimetype of the node
IMG_CHARSET	VARCHAR2			Column is used to store the image charset of the node
IMG_LASTUPD	DATE			Column is used to store the image's last update of the node
EDITABLE_IMG_YN	VARCHAR2			Column is used to store if the image is editable of the node
MAX_VALUE	NUMBER			Column is used to store the max value of the node
MIN_VALUE	NUMBER			Column is used to store the min value of the node
NEW_COLUMN_YN	VARCHAR2			Column is used to store if the node is a new column
NEW_ROW_YN	VARCHAR2			Column is used to store if the node is a new row
NODE_FORMAT	VARCHAR2			Column is used to store the node format
NODE_LENGTH	NUMBER			Column is used to store the node length
NUMBER_OF_COLUMNS	NUMBER			Column is used to store the number of columns
REPEATABLE_YN	VARCHAR2			Column is used to store if the node is repeatable
READ_ONLY_YN	VARCHAR2			Column is used to store if the node is read-only
UNIQUE_YN	VARCHAR2			Column is used to store if the node is unique
REQUIRED_YN	VARCHAR2			Column is used to store if the node is required
REPEATABLE_COLS_YN	VARCHAR2			Column is used to store if the node is repeatable columns
REPEATABLE_ROWS_YN	VARCHAR2			Column is used to store if the node is repeatable rows
CHOICES_DYNAMIC_LOV_TYPE	VARCHAR2			Column is used to store the choices dynamic lov type
CHOICES_LOV_ALIGNMENT	VARCHAR2			Column is used to store the choices lov alignment
CHOICES_LOV_ALLOW_OTHER_YN	VARCHAR2			Column is used to store the choices lov allow other
CHOICES_LOV_TYPE	VARCHAR2			Column is used to store the choices lov type
CHOICES_LOV_CODE	VARCHAR2			Column is used to store the choices lov code
CHOICES_LOV_CODES	VARCHAR2			Column is used to store the choices lov codes
CHOICES_VALUES	CLOB			Column is used to store the choices values
COL_LOV_ALLOW_OTHER_YN	VARCHAR2			Column is used to store the col lov allow other
COL_LOV_TYPE	VARCHAR2			Column is used to store the col lov type
COL_LOV_CODE	VARCHAR2			Column is used to store the col lov code
COL_LOV_CODES	VARCHAR2			Column is used to store the col lov codes
COL_LOV_LABEL	CLOB			Column is used to store the col lov label
COL_VALUES	CLOB			Column is used to store the col values
ROW_LOV_ALLOW_OTHER_YN	VARCHAR2			Column is used to store the row lov allow other
ROW_LOV_TYPE	VARCHAR2			Column is used to store the row lov type
ROW_LOV_CODE	VARCHAR2			Column is used to store the row lov code
ROW_LOV_CODES	VARCHAR2			Column is used to store the row lov codes
ROW_LOV_LABEL	CLOB			Column is used to store the row lov label
ROW_VALUES	CLOB			Column is used to store the row values
UOM_LOV_TYPE	VARCHAR2			Column is used to store the uom lov type
UOM_LOV_CODE	VARCHAR2			Column is used to store the uom lov code
UOM_LOV_CODES	VARCHAR2			Column is used to store the uom lov codes
UOM_LOV_LABEL	CLOB			Column is used to store the uom lov label
UOM_VALUES	VARCHAR2			Column is used to store the uom values
CREATED	DATE			Column is used to store the date when the node was created
CREATED_BY	VARCHAR2			Column is used to store the user who created the node
UPDATED	DATE			Column is used to store the date when the node was updated
UPDATED_BY	VARCHAR2			Column is used to store the user who updated the node
NODE_TYPE_CODE	VARCHAR2			Column is used to store the node type code
FILE_ACCEPT	VARCHAR2			Column is used to store the file accept
FILE_CAPTURE	VARCHAR2			Column is used to store the file capture
FILE_MULTIPLE_YN	VARCHAR2			Column is used to store if the file is multiple
MASK_INPUT	VARCHAR2			Column is used to store the mask input
MASK_MODE	VARCHAR2			Column is used to store the mask mode
MASK_PREFIX	VARCHAR2			Column is used to store the mask prefix
MASK_SUFFIX	VARCHAR2			Column is used to store the mask suffix
MASK_ALLOW_INCOMPLETE_YN	VARCHAR2			Column is used to store if the mask allow incomplete
MASK_REVERSE_YN	VARCHAR2			Column is used to store if the mask reverse
MASK_SHOW_YN	VARCHAR2			Column is used to store if the mask show
MASK_UNMASK_VALUE_YN	VARCHAR2			Column is used to store if the mask unmask value
MASK_TOKENS	VARCHAR2			Column is used to store the mask tokens
RATING_MIN	NUMBER			Column is used to store the rating min
RATING_MAX	NUMBER			Column is used to store the rating max
RATING_STEP	NUMBER			Column is used to store the rating step
RATING_ICON	VARCHAR2			Column is used to store the rating icon
RATING_HOVER_HIGHLIGHT_YN	VARCHAR2			Column is used to store if the rating hover highlight
RATING_OFF_COLOR	VARCHAR2			Column is used to store the rating off color
RATING_ON_COLOR	VARCHAR2			Column is used to store the rating on color
RANGE_MIN	NUMBER			Column is used to store the range min
RANGE_MAX	NUMBER			Column is used to store the range max
RANGE_STEP	NUMBER			Column is used to store the range step
RANGE_TOOLTIP_SHOWN	VARCHAR2			Column is used to store if the range tooltip shown
RANGE_SHOW_INPUT_YN	VARCHAR2			Column is used to store if the range show input
RANGE_SHOW_MARKS_YN	VARCHAR2			Column is used to store if the range show marks
RANGE_SHOW_MARK_LABELS_YN	VARCHAR2			Column is used to store if the range show mark labels
SWITCH_ON_VALUE	VARCHAR2			Column is used to store the switch on value
SWITCH_OFF_VALUE	VARCHAR2			Column is used to store the switch off value
SWITCH_ON_VALUE_LABEL	VARCHAR2			Column is used to store the switch on value label
SWITCH_OFF_VALUE_LABEL	VARCHAR2			Column is used to store the switch off value label
SWITCH_VALUE_LABEL_DISPLAY	VARCHAR2			Column is used to store the switch value label display
SWITCH_VALUE_LABEL_COLOR_ON	VARCHAR2			Column is used to store the switch value label color on
SWITCH_VALUE_LABEL_COLOR_OFF	VARCHAR2			Column is used to store the switch value label color off
SWITCH_THUMB_ICON	VARCHAR2			Column is used to store the switch thumb icon
SWITCH_THUMB_COLOR_ON	VARCHAR2			Column is used to store the switch thumb color on
SWITCH_THUMB_COLOR_OFF	VARCHAR2			Column is used to store the switch thumb color off
SWITCH_ICON_COLOR_ON	VARCHAR2			Column is used to store the switch icon color on
SWITCH_ICON_COLOR_OFF	VARCHAR2			Column is used to store the switch icon color off
SWITCH_TRACK_COLOR_ON	VARCHAR2			Column is used to store the switch track color on
SWITCH_TRACK_COLOR_OFF	VARCHAR2			Column is used to store the switch track color off
SWITCH_ALT_LABEL_POSITION_YN	VARCHAR2			Column is used to store if the switch alt label position
EXTRA_VALUE	VARCHAR2			Column is used to store the extra value
GROUP_COLLAPSIBLE_YN	VARCHAR2			Column is used to store if the group collapsible
ROW_DYNAMIC_LOV_TYPE	VARCHAR2			Column is used to store the row dynamic lov type
COL_DYNAMIC_LOV_TYPE	VARCHAR2			Column is used to store the col dynamic lov type
ROW_DYNAMIC_LOV_DATA	CLOB			Column is used to store the row dynamic lov data
COL_DYNAMIC_LOV_DATA	CLOB			Column is used to store the col dynamic lov data
CHOICES_DYNAMIC_LOV_DATA	CLOB			Column is used to store the choices dynamic lov data
UOM_DYNAMIC_LOV_TYPE	VARCHAR2			Column is used to store the uom dynamic lov type
UOM_DYNAMIC_LOV_DATA	CLOB			Column is used to store the uom dynamic lov data

UC_FLOWFORMS_PUBLISHED

For storing published forms, it holds 3 JSON blobs: one for the languages, one for the schema (structure), and one for the initial data (values). The published forms are what you would eventually send to your end user to fill out...

Column Name	Data Type	Nullable	Primary Key	Description
ID	NUMBER			Column is used for uniquely identifying the published form
FORM_ID	NUMBER			Column is used for referencing the FlowForm Builder form
VERSION	VARCHAR2			Column is used for versioning the published form
SCHEMA	BLOB			Column is used for storing the schema of the form (JSON BLOB)
LOCALES	BLOB			Column is used for storing the locales of the form (JSON BLOB)
INIT_DATA	BLOB			Column is used for storing the initial data of the form
CREATED	DATE			Column is used for storing the date when the form was created
CREATED_BY	VARCHAR2			Column is used for storing the user who created the form
UPDATED	DATE			Column is used for storing the date when the form was updated
UPDATED_BY	VARCHAR2			Column is used for storing the user who updated the form

UC_FLOWFORMS_DATA

For storing submitted data

Column Name	Data Type	Nullable	Primary Key	Description
ID	NUMBER			Column is used for uniquely identifying the filled-out data form
PUBLISHED_FORM_ID	NUMBER			Column is used for referencing the published form
FORM_DATA	BLOB			Column is used for storing the data of the form that has been filled out (JSON BLOB)
CREATED	DATE			Column is used for storing the date when the form was created
CREATED_BY	VARCHAR2			Column is used for storing the user who created the form
UPDATED	DATE			Column is used for storing the date when the form was updated
UPDATED_BY	VARCHAR2			Column is used for storing the user who updated the form

UC_FLOWFORMS_BLOBS

For storing file blobs, ie. Files in file browsers

Column Name	Data Type	Nullable	Primary Key	Description
ID	NUMBER			Column is used for uniquely identifying the file blob
FILE_CONTENT	BLOB			Column is used for storing the file content
FILE_FORM_PATH	VARCHAR2			Column is used for storing the data path in the JSON
FILE_FILENAME	VARCHAR2			Column is used for storing the file filename
FILE_MIMETYPE	VARCHAR2			Column is used for storing the file mimetype
FILE_CHARSET	VARCHAR2			Column is used for storing the file charset
FILE_LASTUPD	DATE			Column is used for storing the date when the file was last updated
DATA_ID	NUMBER			Column is used for referencing the submitted form data that the file belongs to

UC_FLOWFORMS_LOVS

For storing list of values definitions

Column Name	Data Type	Nullable	Primary Key	Description
NAME	VARCHAR2			Column is used for storing the unique name of the LOV
TYPE	VARCHAR2			Column is used for storing the type of the LOV (Dynamic, Static)
SQL_QUERY	CLOB			Column is used for storing the SQL query of the LOV (when dynamic is selected)

UC_FLOWFORMS_LOV_ENTRIES

For storing list of values entries

Column Name	Data Type	Nullable	Primary Key	Description
ID	NUMBER			Column is used for uniquely identifying the LOV entry
LOV_NAME	VARCHAR2			Column is used for referencing the LOV name
DISPLAY_VALUE	CLOB			Column is used for storing the display value of the LOV entry
RETURN_VALUE	VARCHAR2			Column is used for storing the return value of the LOV entry
DISPLAY_SEQ	NUMBER			Column is used for storing the display sequence of the LOV entry

Flow

As said in the previous section, Installation, we encourage you to use our sample app to use this plug-in, as the sample app includes the powerful form builder.

1. Create a form
2. Add nodes to the form
3. Publish the form
4. Send the published form to your end user
5. The end user fills out the form
6. The end user submits the form
7. Manipulate the submitted data as you see fit!