Jenzabar Campus Portal Features Help Hub

FormFlow & WorkFlow - Archive

Tip

Only releases with enhancements or resolved issues for this module have content below.

Resolved Issues
Enhancements
New Form Validations

The Manage Forms and Edit Forms pages now show icons and message boxes to let you know when there are issues with a form's questions or fields. The validation process checks for invalid data sources, undefined dates, disabled form links, unselected payment profiles, partially hidden required questions, and unmapped WorkFlow data points. A new Validate button on the Edit Form page lets you manually check a form to confirm your updates resolved the issues.

FormFlow validation icons and messages.

Schools that upgraded from EX to J1 will see this message when they:

  • Create a new form based on a Jenzabar-provided template without a J1 database defined. This is because Jenzabar’s latest form templates use data sources that reference the J1 database.

  • Rename their EX database to J1 database and then import an older, saved form that still references the EX DB.

When this message appears, users can update the data sources to use the J1 database or create the J1 database being referenced.

Enhancements
Map Student Information to J1

Users can now create forms that map to student-related tables. This means student-submitted forms such as a Leave of Absence or Major Change requests can be processed using the Process Internet Submissions window. To set up a form that maps to student tables, select the new Student Request option from the Form Type drop-down (Manage Forms, tools, J1 Mapping Tool.)

RN_2020_1_campusportal_studentform_mapping.png
New Database Reference

The following Jenzabar-provided form datasources now reference the J1 database:

  • Candidate: Online Application

  • Constituent: Online Giving

  • Data Privacy: Consent Request, Data Request, Forget Me Request

  • Events: Multi-Part Events, Single with Fee, Single No Fee

  • Residence Life: House App

RN_2020_1_FF_J1_DB.png
Resolved Issues

Issue

Description

164372

Rerouting a document to another track correctly assigned the document to the track, but incorrectly left it in the original stage container.

179579

Deleting a row in a form resulted in errors in the browser console.

180726

Submitting a login page with FireFox browser would result in a warning that the page was being reloaded.

182247

Sort buttons were missing from the reports view.

183179

Forms with emails that include the submission PDF could see performance impacts when multiple email templates are triggered for each submission.

186975

In some cases, generating a view using FormFlow tools would result in a crash if the connection string wasn't in the order expected.

188294

When a field was required, and the form submitted without a value in that field, an error message displayed. If the field was changed to not required, the error message would incorrectly persist.

189251

The execute link used to reprocess mappings was not working.

190641

Attempting to download a submitted file resulted in a simple login page being displayed for a single download. Now downloading a file  no longer requires the simple login for authenticated users.

193047

Questions marked as Show Only in Report did not display in Admin view.

193118

Sorting arrows were not included on the documents list table.

193297

Stored procedures set to execute on answer change did not include the approver ID parameter.

194990

The unique label allowed white space only values and should not have.

196502

Using parenthesis in a rule comparison value would cause errors on the page.

197796

The LSR testing screen did not have proper styling to distinguish between the string replacer being tested and the value returned by the string replacer.

198430

Forms with large amounts of submission data experienced decreased performance when loading the reports page.

199030

When using a Workflow rule in the Forms feature, the selected target track was saved to the database but was not shown in the drop-down when editing the rule.

199356

When adding approvers, spaces were excluded from the search which resulted in only the first name being evaluated.

200131

For image questions that did not have text associated with them, a blank label was displayed on the form that caused the image to shift from its original position.

200490

The progress checkmark was not appearing on forms without a collection grid.

201529

In some cases, the order of multi-row values submitted to J1 Desktop did not populate in the same order as the mapping on the form.

202665

Some F5 load balancer configurations would cause "Invalid request" errors to be shown when working in FormFlow.

202666

Some F5 load balancer configurations would cause "Invalid request" errors to be shown when working in Workflow.

204742

In some scenarios, approved documents moving to the next stage would receive a "potential loop" error when no actual loop occurred.

201471

The progress checkmark was not appearing on forms that did not have a collection grid.

Resolved Issues

Issue

Description

178404

When a track was created by one user, it was not accessible by another user with permissions to manage workflows.

186709

When using the Display in Main View setting and the Allow users to access active submissions modal setting, the link to the active submission can result in a YSOD in certain situations.

189602

In some cases, update panels were not correctly functioning which prevented database, data source, and payment profile changes from saving.

191015

When using a unique ID replacer in the attachment name format field, the value was not replaced.

192735

When editing an item with an existing send email rule action, the edit pencil did not show immediately.

193302

Tracks created by one user were not able to be edited by another.

193942

Saving or updating tab progress rules did not properly display the progress check mark.

194888

The Public Registration portlet was displaying an error when the user attempted to define success messages.

195547

When archiving submissions, the next submission ID starts with 1 causing conflicts during a second attempt at archiving. A new SQL Server sequence was introduced to keep submission IDs consistent for all runs of the archiving process.

195574

An email template that listed the same email more than once resulted in a "SQL note available" error if JICS email logging was turned on.

195724

Authenticated users with a direct link to a report or file could access it even if they were not the original submitter or user with permissions.

Enhancements
Multiple Workflow Tracks for Documents

Using the WorkFlow Rules tab, you can now set up forms to process through more than one Workflow track at a time. For example, you can set up employment application submissions to be routed to someone in your human resources department as well as the team lead for the department hiring.

RN_2019_4_FFandWF.png
Sample query with an updated column name.

You can set up as many tracks as needed and even remove tracks.

Tip

When multiple approvers make changes to a document on more than one workflow, all changes are combined into the same submission.

Note

If your school has created custom queries referencing the WorkflowID column, you must update them to use the new CF_SubmissionExtensionData DataKey, “WorkflowDocumentID” column. This allows your existing queries to handle multiple documents.

Resolved Issues

Issue

Description

127392

In Edge and Internet Explorer broswers, Formbuilder Application (via Employment Positions) question text didn’t align with the top of the input field, and the spacing between the question numbers and question text was missing.

130119

When using a validation mask in FormFlow, the input cursor could not be positioned with a mouse click in the input.

136142

When including a reference to a stored procedure with a name longer than 50 characters, a “yellow-screen-of-death” (YSOD) would display or the data would be shortened when saving on the Stored Procedures screen.

148034

When an external user attempted to view reports that they had permission to view, a datatables.net error was displayed.

150670

When a form was created using a collection grid and a parent grid was marked required while a child grid was optional, the system would not consider the question complete until both parent and child grids had valid content.

158238

When creating an External Sign up account in FormFlow, the minimum and maximum password requirements defined in JICS were not honored.

162601

In FormFlow, when a user changed an answer in their form, the answer changed event did not properly send emails, execute procedures, or process rules assigned to a question.

169658

For users without edit permissions, collection grid rows were displayed when reviewing the submission in Workflow.

170692

From the Online Application Template, when selecting a school by state on the Education tab, the list of schools in the drop-down was not sorted in alphabetical order.

171188

When creating a rule and applying them to a group of questions in a form, the rule would be applied to all question groups containing the name of the specified group instead of only applying to the group with the exact matching group name.

171237

In FormFlow, when using a string replacer in the file upload root, uploaded files were placed in the correct location, but the file could not be downloaded by the report viewer.

172126

Using the delete button to remove an email template in FormFlow did not delete the template.

172127

The default data for email address validation did not support email addresses using subdomains.

172476

Files and images added to a label by MoxieManager were not visible to guest users.

174051

Using a string replacer in a SQL function as a parameter in a data source resulted in an error message because a comma was being included in the replacer.

174052

When looking at the Dynamic Approvers in Workflow, the list in the drop-down was not in alphabetical order.

174354

The FormFlow J1 Desktop Mapping Tool did not always assign the proper version numbers in J1 Desktop so submitted forms were not being refreshed when changes were made to the form.

175444

Rules added to Hidden questions on FormFlow forms did not execute when the form loaded.

175511

In FormFlow File Upload, any files with a comma in the name were causing a browser error in Chrome when the file was downloaded.

176379

When a hidden question was referenced in a drop-down question's data source, the data source did not update if the question was updated by a look up.

176546

When sharing a form that accepts a payment as a shortcut in JICS, a “yellow-screen-of-death” (YSOD) is displayed when being transferred to the payment portlet.

176547

In FormFlow Reports, when an approver without edit permissions viewed a report on a mobile device, responses on the report did not appear.

176548

When users without the JICS administrator role attempted to manage workflows they received an error message even though they had permission to the workflows.

177109

In FormFlow forms, read only questions did not execute rules associated with them when the value was updated via a look up.

178183

In FormFlow, when an approver opened a form the audit trail was logging information using the approver’s GUID rather than the user’s name.

179742

In Workflow, when attempting to assign an alternate approver to a stage that already had one or more approvers, the selection didn’t save.

179816

When an approver attempted to download an uploaded file in Workflow, a “yellow-screen-of-death” (YSOD) page appeared due to an error in the permissions check.

180329

In FormFlow, when a default value using a string replacer was used in a textbox or essay question, the value was being correctly stored in the database when submitted, but it didn’t show correctly on screen.

180642

In FormFlow, a “yellow-screen-of-death” (YSOD) would appear when attempting to load forms the no longer existed on a page.

181726

When creating a question in a FormFlow forms with more than one rule, the order boxes for rules did not correctly update the rules when reorder values were provided.

181727

A form with rules requiring groups showed users the groups were required, but didn’t enforce the requirement and allowed forms without groups completed to be submitted.

182710

In FormFlow, creating rules to make questions required on a form would sometimes result in multiple requirement asterisks being displayed.

Enhancements
New Reroute and Skip Features for Workflows

New Reroute and Change stage rule options let administrators set up workflows to change track stages or send a document to an entirely different track workflow.

Notice

If your school has a transcript evaluation workflow set up, you can have a rule that either sends transcripts to a Graduate Admissions Office track or to an Undergraduate Admissions Office track based on the user input.

RN_2019_3_1_FF_1.png

This also means workflows aren’t required to be in sequence. You can set up a workflow to go from Stage 1 to Stage 3 to Stage 5 and then backtrack to Stage 2.

RN_2019_3_1_FF_2.png
General Data Protection Regulation Compliance

The General Data Protection Regulation (GDPR) requires that organizations doing business with any person in or from the EU must alert the person to how their data is being collected, processed, and used and gather their consent. Individuals must be able to withdraw their consent as well as make other requests related to their data. Additionally, there are certain protections that companies must take to ensure that data is secure. With the 2019.3.1 release, we have made steps toward bringing the Jenzabar 1 products in compliance.

  1. Enabled encryption between the database and the webservers (both JICS and J1 Web) and Desktop. This is to ensure protection of the person's data as it moves across the internet. Your organization must take steps to enable SSL encryption.

  2. Created new form templates to give people a way to

    1. Give or deny consent for capturing, using, and processing their data.

    2. Request a copy of the data your organization has on them.

    3. Request that your organization forget their data so that it can no longer be used.

  3. Created a new Data Privacy activity center in J1 Desktop to track the various requests that have been made in a historical fashion and give a way to act on the requests. Two new windows, Data Privacy Consent Types Setup and Data Privacy Requests, make up the Data Privacy activity center.

    RN_2019_3_1_Data.png
Resolved Issues

Issue

Description

119920

When testing a data source with a trailing space, a warning was displayed that did not clear after closing and reopening. Closing the pop-up now clears the warning.

122597

When adding a file upload question to the form, the label would be present, but the button was not visible until the screen was refreshed. The button now appears as expected.

128139

When mapping the pre-population setting on a field to a column in the military service master UDF table, the column did not pre-populate with the value. Now it does.

142364

When exporting a form, all data sources in the system were included in the export rather than only the data sources associated with the form.

144973

Importing a form with a 'for each' statement and editing the statement would improperly select the wrong source question in the 'for each' drop-down. Code was added to correctly select the source question in the drop-down.

146807

If a question had previously been mapped to a J1 Web Event Registration field, the mapping could be changed, but not cleared.

147119

When a user changed their FormFLow external user password, an error message was incorrectly displayed even when a valid password was entered.

150669

In Workflow, when rerouting a document from one track to another, the data points associated with that document were not passed to the new track when mapping was available. Code was added to check for mappings on the new track and transfer the data to those mappings if they exist.

153482

Adding a group name to a question or a message in an alert rule that contained an apostrophe would result in a script error when the rule was evaluated. Code was added to encode user-defined values used in rules to prevent conflicts with existing code.

163297

A value added as an option to a drop-down containing an apostrophe could result in a truncated value written to the database upon selection of the value. Code was added to properly encode the strings to prevent interference.

163547

Security enhancements were added to FormFlow to protect against malicious scripts.

164372

Rerouting a document to another track correctly assigned the document to the track, but incorrectly left it in the original stage container.

166764

In forms with a large number of hidden questions, the FormFlow context menu was inconsistently displayed when right clicking a hidden field.

167082

In some cases, empty rows were rendering in the form design view and could not be removed. Code was added to keep empty rows that were associated with hidden questions from rendering.

168209

Special characters were not properly encoded in the rendered PDF used for the email attachment. This has been fixed.

168797

Mapping a question to a data point could result in an error when the form was submitted if the length of the response was greater than 4,000 characters. The Workflow NHibernate mapping was updated to match the mapping for Forms.

169608

When creating a new form, a default mapping form type was automatically assigned to the form even if mapping wasn't being used. Now that won't happen unless a mapping form type is explicitly selected.

172478

When dependent javascript files were loaded for FormFlow and Event Requests, the JICS version number was incorrectly used instead of the J1 Desktop version number. This caused browser caching issue when attempting to access these features.

172756

If no value was provided for a date picker when a form using the "Use time" setting was submitted, a YSOD would appear when edited. Code has been added to check for no value in these fields.

173568

Code was added to the date picker function to expand allowable selection to the last 100 or next 100 years.

175294

A form with a payment that had the "Display a message" setting checked might result in a YSOD with the message "Value cannot be null. Parameter name: g." if JICS was configured to use the hosted Authorize.net payment solution. Code was added to retain the form identifying information when the hosted payment form is used.

175837

If a form started as publicly available and submissions were made by guests, and then was converted to an External Sign Up form with the "Allow users to review their own submissions" setting, the user would improperly have access to the guest submissions. Code was added to properly return submissions for the logged in external user only.

166597

When multiple instances of FormFlow appeared on the same page in JICS, clicking a link to open the "Pick up where you left off" modal would result in multiple pop-ups opening.

170754

In Edge, the right click options were not available when designing a form.

171012

When importing a form, the use date checkbox was not automatically checked for date pickers on forms used prior to the setting being available.

171139

A browser compatibility issue caused console errors to appear in Microsoft Edge when FormFlow users designed forms and when others completed forms.

171320

Using a string replacer as a default value for a drop-down- question did not properly set the default value.

171434

When using the Log Email setting from JICS Site Manager, emails generated from FormFlow would produce an error message when sent. Code was added to truncate email addresses longer than the supported length when writing to the log table and additional information is written to the site log.

172245

Existing rule actions, or new ones added in Workflow displayed as the incorrect action on the screen. Code was added to properly sync the UI display with the values in the database.

174462

Using the text editor to adjust the alignment of description text did not work.

175220

If a data source associated with the form used the same parameter name more than once, a validation error was thrown when the form was submitted.

175377

Mapped statements and stored procedures set to execute on workflow approval were not executing when they were supposed to.

Resolved Issues

Issue

Description

161193

An error message was displayed when attempting to add or edit a placeholder question. Code was added to properly handle adding and editing the placeholder questions.

164466

Editing a multi-response stored procedure mapping did not correctly display the saved mappings. The code was updated to properly display the mappings.

164469

When more than one file upload question was added to a form, only one file was actually stored on the server when the form was submitted. Code was added to properly retain each question's file upload response.

Enhancements
New Online Giving Form Available

If your school is licensed for the Constituent feature, a new online giving form template is available through FormFlow. This form allows your institution to accept online gifts and donations while mapping and storing the donor contact information and the gift information. This form will accept gifts from both Campus Portal users and guest users once the form and the page are configured to allow guest access. Users can select the donation type, fund category, and can pay for their donation using the form. To collect payments, a payment profile must be set up and the form will redirect users to a payment page where they can complete their transaction.

When form users submit an online giving form, the gifts are processed as follows:

  • If the user is recognized in the database, the gifts are processed using the Process Online Gifts window in J1 Desktop.

  • If the user is not recognized in the database, the gifts are processed using the Process Internet Submissions window in J1 Desktop under the submission type 200 - Personal Information with Gift.

When the template is used, data for this form is automatically mapped to the Donor Name and Contact Details table and the Online Gift Details table. Jenzabar highly recommends starting with the online giving template as opposed to creating an online giving form from scratch. However, you must be very careful if you remove any questions from a form created from the template.

New Tab Orientation Setting Hides Tabs From Form Navigation

On the Form Settings page (Manage Forms > navigate to form > Admin toolbar > Form Settings), a new option of "None" is available to set the Tab Orientation. Setting the tab orientation to "None" will hide the visible tabs from users so that they cannot be selected. This will not hide the tab contents from users, but will instead force users to navigate through the form using navigation buttons instead of clicking each tab. This is helpful if you do not want users to view or fill out the contents of the tabs out of sequential order. This feature will also hide a tab from users when the form only has one tab.

RN_2019_2_ex_tabNone_manageforms.png
RN_2019_2_ex_tabNone_userview.png
Question Rules are Now Validated

To ensure that the rules you create for each question are valid, the following validations have been put into place for question rules:

  • The first step/condition of a rule will always be "If the answer value is". Users will receive an error if they try to select a different condition for the first step of the rule.

  • An error message will appear if a rule group has more than one "Else" clause.

  • A value will only be saved to the database if there is something in the value field or if an additional step has been added.

Question Groups Can Be Disabled and Enabled Using Rules

Two news actions/events can now be applied to a question’s rules to allow you to disable or enable a group of questions depending on an answer value the user selects or enters.

  • Group: Disable will disable the question group if the user’s answer matches the value you specified in the rule

  • Group: Enable will enable the question group if the criteria matches what you specified in the rule

RN_2019_2_ex_group_enabledisablerule.png

As a note, question groups are all enabled by default. The Group: Enable action only needs to be used if you wish to re-enable a question group that you have a Group: Disable clause set for.

When questions in a question group are disabled, form users will still be able to see the questions, but they will not be able to enter any information into them. In the example below, the Zip Code and State questions are both disabled.

RN_2019_2_ex_group_enabledisableform.png
Apply a CSS Class to a Question or Button

A new setting that allows form administrators to add CSS classes to certain question types has been added. This new Input control CSS classes setting is available on the question properties’ Settings tab for the following question types.

  • Drop-down

  • Button

  • Text box

  • Essay

  • Date-picker

  • Image

Administrators can enter in a known CSS class, and it will be applied to the form question. For example, you can enter the value 'btn-success' to turn a button green.

RN_2019_2_ex_inputcssclass.png
Campus Portal Email Logging Now Includes FormFlow - Forms and Workflow

When Campus Portal is set to log emails (Site Settings & Framework settings & Email settings) FormFlow – Forms and Workflow emails are now logged. These emails are logged to the FWK_LoggedEmail tables.

Data Sources Can Now Require Form User To Be Logged in Before Executing

Administrators can now configure data sources so that they cannot be executed if the form user is not currently logged in. This feature is useful if the data the data source retrieves contains sensitive information. Jenzabar also recommends using string replacers in your data source query to further tailor the results that will display to the user.

Resolved Issues

Issue

Description

134450

When the Execute button was clicked in the Reports View, the mapped statements and stored procedures associated with the submission were not being executed.

146878

When reviewing a submission in FormFlow - Workflow, approvers lost their changes if they didn't first save the document before clicking approve.

147583

When a user submitted a form and did not provide an answer, a null value was submitted to a mapped stored procedure which resulted in an error.

150292

When editing a form with a text box or hidden question that contained a value with an apostrophe, the text following the apostrophe was cut off.

151521

A Yellow Screen of Death (YSOD) error appeared in FormFlow - Workflow when users reviewed a document submitted by file upload.

151736

In FormFlow - Forms, when loading a form that had rules associated with a button that should be executed with an empty state, the rules didn't successfully execute.

152066

In FormFlow - Forms, a file extension was  added to uploaded files even when the filename already had an extension.

155271

When submitting a form that had a string replacer as a default value, the string replacer value displayed in the report instead of an empty value if the question was unanswered.

155342

Large amounts of submission data resulted in poor performance on the report view. New indexes were added to improve performance.

158892

Using a string replacer as a default value for a drop-down or radio button question did not properly set the selected value.

158946

Adding a stored procedure to a form always resulted in the OrderNum value being set to zero for every procedure.

159066

The width value of a button that included a percent sign was not being honored.

159634

For the Workflow feature, if a data point value was not provided at form submission, subsequent updates to the form would not be applied to the original data point.

Enhancements
FormFlow Features Are Now Mobile Friendly

The FormFlow - Forms and FormFlow - Workflow portlets are now responsive and mobile-friendly. However, you will not be able to create or administer forms while using a mobile device.

Resolved Issues

Issue

Description

136072

When uploading a file to a file upload question displays the uploaded file name but does not make it a link to be accessed until the page is reloaded.

141175

When using an string replacer in a question label, the replacer appeared when the form was loaded instead of the value that was intended.

141180

Users were able to submit a form multiple times when the TODO List Portlet Setting was checked.

141751

A form with a mapped statement that referenced a not required, file upload question logged an error to the event viewer that the referenced question no longer existing on the form if a file was not uploaded before the submission.

142368

The name data was not passed from the Payments Portlet when payment was made from FormFlow when using the payment launch out method.

143563

When editing mapped statements, the statement being edited was added as a new one instead of updating the original. Code was updated to apply the modifications to the original.

145901

In some cases, file upload and image questions did not render properly when behind a load balancer.

146180

Editing a form in Workflow that contained a date picker control resulted in a console error indicating moment was not defined.

146660

When tabbing from field to field in a form, date picker questions will accept a tab to focus, but will not allow tabbing from that field to the next field.

148384

The Show only in Workflow edit mode setting was missing from the Tab properties modal.

148727

When creating a user account for an email address that already exists as an external user, the create button is disabled but no error is displayed.

148728

Multiple collection grids on the form would result in the add button triggering updates to the wrong grid in some cases.

151583

The J1 Desktop Web Application Services installer logged errors when attempting to update the CF_Datasources table and new globalization values.

150851

The zip code functionality did not properly populate the city/state questions when an answer was provided.