Jenzabar Campus Portal Features Help Hub

Using the J1 Mapping Tool for Internet Submissions

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.

FormFlow gives you powerful tools to process your form information. You can use the J1 Mapping Tool to send form information to the Process Internet Submissions window in the J1 Desktop. After information is reviewed and confirmed, it is updated in the J1 database.

How it Works

When you create or edit a form, the J1 Mapping Tool is accessible from the Tools menu. Clicking the J1 Mapping Tool option opens the Internet Submissions Mapping page, where you can select a form type and see the database tables that can be mapped to it. Only the tables associated with the selected form type are available for mapping (e.g., you cannot use the tables associated with the Admissions Inquiry form type if the Housing Application form type is selected). After the form type and mapping table are selected, you can map your form questions to columns in the selected database table.

Note

The J1 Mapping Tool uses the Jenzabar Web Application Services Data Access Layer to connect back to J1 Desktop. It cannot target any other database.

The default mapping tables are associated to form types via data provided by the installer. If you want to map data for a specific form type to a custom table, use the J1 Desktop Manage Mapping Tables window to set up those relationships.

Form Templates with Default Mappings

Several form templates are already set up with form mapping, and you can add additional mapping connections or update the mappings based on how you've configured your form.

License Required

Form Template

Form Type

Candidate

Online Application

Admissions Application - New

Candidate

N/A

Admissions Inquiry - New

Events

  • Single Fee Event

  • Single No Fee Event

  • Multi Part Event

Access form mapping from the Settings tab for each question.

EXi/J1 Web Student Life

Housing Application

Housing Application

Constituent

Online Giving

Personal Information with Gift

Common

  • Data Privacy Consent Request

  • Data Privacy Data Request

  • Data Privacy Forget Me Request

  • Data Privacy Request - Update Consents

  • Data Privacy Request - Access Data/Forget Data

Note

This setup is required if you want to send information submitted in your form to J1 Desktop.

  1. Log in to the Campus Portal as an administrator and access FormFlow - Forms.

  2. Click Manage Forms.

  3. Click on the name of the form you want to update.

  4. Add the questions you want to map to the J1 Desktop Process Internet Submissions window.

  5. Make note of the Unique IDs of the questions you want to map to the J1 Desktop Process Internet Submissions window.

  6. From the Tools menu, select J1 Mapping Tool to open the Internet Submissions Mapping page.

  7. From the Form Type drop-down, select the type of form you are mapping to J1. A table drop-down appears.

  8. Select the table you want to map the information to.

  9. Click the Add New Row link. A list of available mapping rows for the table you selected appears.

  10. Find the column you are mapping to.

  11. From the drop-down next to the column, select the form question you want to map to the column.

  12. Click Save.

  13. Repeat steps 10 and 11 for each form question you want to map.

  14. Click Done. When the form user submits or saves their form (varies according to your form setup), the question responses will be sent to the J1 Desktop Process Internet Submissions window and available for review and processing.