Workflow Application: MERGEFORM usage

Development Workflow Applications
1

As of version 6.1.4, WorkflowGen includes the new MERGEFORM application, which takes multiple form data files and merges them into one file. It can also merge form archives into a target form archive by merging the HTML sections from both files.

Required parameters

Parameter                                       Type       Direction Description
FORM_DATA File INOUT The merge target FORM_DATA. All FORM_DATA_SOURCE parameters will merge into this parameter's default value (IN) and will update the specified data (OUT) with the result.
FORM_DATA_SOURCE1 File IN Specific form data to merge into the target form data.
FORM_FIELDS_MERGE1 Text IN The fields to merge from FORM_DATA_SOURCE1 to FORM_DATA, separated by commas. It supports the asterisk (*) at the end of a parameter name as a wildcard character to select all fields starting with the prefix.

Note: If you don’t specify a FORM_FIELDS_MERGE[N] parameter, all of the fields in FORM_DATA_SOURCE[N] will be merged.

Optional parameters

Parameter                                      Type       Direction Description
FORM_DATA_SOURCE[2..N] File IN Specific form data to merge into the target form data.
FORM_FIELDS_MERGE[2..N] Text IN The fields to merge from FORM_DATA_SOURCE[2..N] to FORM_DATA. It also supports the asterisk wildcard character.
FORM_ARCHIVE File INOUT The merge target FORM_ARCHIVE. All FORM_ARCHIVE_SOURCE parameters will merge into this parameter's default value (IN) and will update the specified data (OUT) with the result.
FORM_ARCHIVE_SOURCE[1..N] File IN Specific form archive to merge into the target form archive.
FORM_FIELDS_ARCHIVE[1..N] Text IN Section IDs to merge from FORM_ARCHIVE_SOURCE[1..N] to FORM_ARCHIVE, separated by commas.

Note: This parameter does not support the asterisk wildcard character; instead, you must specify the exact IDs of each section to merge.

Examples of parameters

Parameter                                       Type       Direction Description
FORM_DATA File INOUT Send value of FORM_DATA
Retrieve value into FORM_DATA
FORM_DATA_SOURCE1 File IN Send value of FORM_DATA_VALIDATES_ACCOUNTING
FORM_FIELDS_MERGE1 Text IN Send value of ACCOUNT_*
FORM_DATA_SOURCE2 File IN Send value of FORM_DATA_VALIDATES_SALES
FORM_FIELDS_MERGE2 Text IN Send value of SALES_DECISION,SALES_COMMENT
FORM_ARCHIVE File INOUT Send value of FORM_ARCHIVE
Retrieve value into FORM_ARCHIVE
FORM_ARCHIVE_SOURCE1 File IN Send value of FORM_DATA_VALIDATES_ACCOUNTING
FORM_FIELDS_ARCHIVE1 Text IN Send value of ACCOUNT
FORM_ARCHIVE_SOURCE2 File IN Send value of FORM_ARCHIVE_VALIDATES_SALES
FORM_FIELDS_ARCHIVE2 Text IN Send value of SALES

For a tutorial on how to use the MERGEFORM application in a process, see How to create a workflow with parallel actions that can be launched at the same time.

3

HI,

Is it possible to use MERGEFORM to merge tables from multiple sources? e.g. those created by GridViews?

We’re looking to merge the GridView rows from multiple parallel paths in a process.

Thanks,
Jim