Jenzabar Campus Portal Features Help Hub

FormBuilder - Archive

Tip

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

Enhancements
Updates to Default Data for Address Mapping Tables

Default data for mapping user-defined address information now references the NameAddressMaster_UDF table instead of ADDRESS_MASTER_UDF. This change impacts the following windows in Desktop and updates the data mapping table references in the Campus Portal FormFlow – Forms and Form Builder features.

Desktop Window

Description of Change

Manage Mapping Tables

  • Available Tables drop-down: NameAddressMaster_UDF replaced ADDRESS_MASTER_UDF.

  • Mapping Columns grid: References NameAddressMaster_UDF instead of ADDRESS_MASTER_UDF.

Review Submission Mapping Details (from Internet Submissions)

  • Available Tables drop- down: NameAddressMaster_UDF replaced ADDRESS_MASTER_UDF.

  • Data Mappinggrid: References NameAddressMaster_UDF instead of ADDRESS_MASTER_UDF.

Caution

This change removes any mappings to user-defined address columns in your existing forms. You'll need to remap those columns and specify the correct address code for each mapping row. For more details about mapping columns, see the following topics:

Note

The form_data_mapping.form_data_mapping_ID values are not impacted by this change. If your school generates submission data with a customization outside of FormFlow or Form Builder that references the mapping tables instead of the form_data_mapping_id, the mapping table names must be updated to reference NameAddressMaster_UDF.

Changes to the Form Builder Submission Process for User-Defined Addresses

User-defined addresses submitted in Form Builder through the Constituent Profile feature are now stored in the new NameAddressMaster_UDF table instead of the ADDRESS_MASTER and/or ADDRESS_MASTER_UDF tables.

Resolved Issues

Issue

Description

RN21988

When a parent question was updated, the child question's options did not automatically update.

Enhancements
Max Column Lengths Updated for Mapped Data Columns

The max column length for several name-related mapping columns increased to allow longer name entries to be saved in the database.

Map Table Name

Map Column Name

Max Char Length

FERPA_PERMISSION

FIRST_NAME

30

FERPA_PERMISSION

LAST_NAME

60

FERPA_PERMISSION

MIDDLE_NAME

30

NameMaster

FIRST_NAME

30

NameMaster

LAST_NAME

60

NameMaster

MIDDLE_NAME

30

NameMaster

ORG_NAME_COMPUTED

120

ORG_TRACKING

ORG_NAME

120

RELATED_PERSON

FIRST_NAME

30

RELATED_PERSON

LAST_NAME

60

RELATED_PERSON

MIDDLE_NAME

30

RELATED_PERSON

ORG_NAME

120

SALUTATION

FIRST_NAME_TO_USE

30

SALUTATION

LAST_NAME_TO_USE

60

SALUTATION

MIDDLE_NAME_TO_USE

30

SALUTATION

SALUT_LINE_1

120

2020.3
2020.2
2020.1
2019.5
2019.4
Resolved Issues

Issue

Description

166324

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

2019.3
2019.2
2019.1