Workflow Application: MERGEFORM usage

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.

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