FormBuilder - Archive
Tip
Only releases with enhancements or resolved issues for this module have content below.
Enhancements
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 |
|
Review Submission Mapping Details (from Internet Submissions) |
|
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.
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
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. |