Important
Information and features vary according to the roles to which you belong and the permissions associated with those roles. For more information, contact your module manager or your campus support team.
A collection grid allows you to create one question and collect multiple pieces of information. For example, the online application template lets you collect several schools the applicant previously attended, but treats it as one piece of information. If you are sending information back to your desktop application, this means the information will be stored as one row.
Each collection grid should have one or more fields of information that it is collecting. Each field or question the grid is collecting is called a source question. All source questions, including the button that adds the information to the collection grid, is tied to a stored procedure.
Log in to the Campus Portal as an administrator and access FormFlow - Forms.
Click Manage Forms.
Click on the name of the form you want to update.
From the Tools menu, select Stored Procedures to open the Procedures page.
Click New Procedure.
From the Database drop-down, select the database from which the stored procedure is derived.
For multiple response questions, such as the Collection Grid, you can click New Multi-Response Procedure.
Note
This will tell the form to execute the procedure once FOR EACH response to the question.
Select an option from the This statement should be executed on drop-down.
Select the procedure to be executed from the Procedure drop-down.
Sample stored procedure code:
REATE PROCEDURE dbo.AAA_spNameUpdateSubmission @ID_NUM int, @FIRST_NAME varchar(30), @LAST_NAME varchar(30) AS BEGIN SET NOCOUNT ON; INSERT INTO AAA_NAME_UPDATES (ID_NUM, FIRST_NAME, LAST_NAME) VALUES (@ID_NUM, @FIRST_NAME, @LAST_NAME) END
Sample stored procedure in Campus Portal view:
Note
Procedures are created in SQL Server.
From the parameter table drop-downs, select the form question you are mapping to the parameter or the following:
NULL will enter in a null value.
Custom Value is defined text that is always be inserted into the column.
Submission as PNG converts the final form submission into a PNG file and stores it as a byte array in the database.
Note
This functionality is not supported for CX.
Submission as PDF converts the final form submission into a PDF file and stores it as a byte array in the database.
Note
This functionality is not supported for CX.
Collection Grid: * values indicate the column in the collection grid that should be referenced when inserting into the field. These questions are “Source” questions. Collection Grid: Row Number is generated at submission time and represents the row order where the data exists in the user input.
Click Save.
Repeat steps 5 - 10 to create as many stored procedures as needed.
Click Done.
Access the form you want to work with.
From the Tools menu, select Stored Procedures.
Click New Multi-Response Procedure.
Note
This will tell the form to execute the procedure once FOR EACH response to the question.
From the This statement should be executed on drop-down, select
Submit occurs when the Event action Form: Submit is executed. All Save statements are executed automatically prior to the Submit statements being executed.
Save occurs when the Event action Form: Save is executed.
Workflow occurs upon receiving a command from the Workflow portlet. This command is sent when a document progresses from a stage that has the “Execute Statements” setting checked
From the Procedure drop-down, select the procedure to be executed.
Tip
Procedures are created in SQL Server.
Semple stored procedure code:
CREATE PROCEDURE dbo.AAA_spNameUpdateSubmission @ID_NUM int, @FIRST_NAME varchar(30), @LAST_NAME varchar(30) AS BEGIN SET NOCOUNT ON; INSERT INTO AAA_NAME_UPDATES (ID_NUM, FIRST_NAME, LAST_NAME) VALUES (@ID_NUM, @FIRST_NAME, @LAST_NAME) END
Sample stored procedure in Campus Portal view:
Select the stored procedures you want to execute.
From the parameter table drop-downs, select the form question you are mapping to the parameter or the following:
Collection Grid: * values indicate the column in the collection grid that should be referenced when inserting into the field. These questions are “Source” questions. Collection Grid: Row Number is generated at submission time and represents the row order where the data exists in the user input.
Click Save changes.
Click Done.
A stored multi-response procedure should be used for a collection grid. This will tell the form to execute the procedure once FOR EACH response to the question.