Mapping Tool

Schools licensed to use Candidate features can map form information to the J1 Desktop Process Internet Submissions window where it can be processed and associated with the candidate’s information. You can map a single question to a table/column or use a collection grid to map several questions to the same row of a single mapping table.

The Mapping Tool uses the Internet Submissions Mapping page where you can select a form type to see a list of related database tables that can be used for mapping your form data. The base mapping tables are associated to form types via data provided by the installer and mappings to custom tables for various form types are managed using the J1 Desktop Manage Mapping Tables window.

How To

1. Log in to the campus portal as an administrator and access J1 FormFlow - Forms.

2. Click Manage Forms. The Manage Forms page appears.

3. Click on the name of the form you want to update. The Form page appears.

4. Add the questions you want to map to the J1 Desktop Process Internet Submissions window. If you are setting up the online application form, see Set Up an Online Application Form from a Template. Many of the needed J1 database mappings are completed for you.

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. The Internet Submissions Mapping page appears.

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.

FAQ

Online Application/Make an Inquiry

With the CRM Candidate license, you can create an online application for admissions or an inquiry form that maps to the Process Internet Submissions screen in J1 Desktop via the J1 Mapping Tool.

In the tool, you can choose the type of form you’d like to configure and a list of tables available to that form type will be displayed. This list of tables is controlled by J1 Desktop in the Internet Submissions screen.

Events Registration Forms

The Events module provides additional mapping options to J1 Web from FormFlow. While not immediately visible in the J1 Mapping Tool, additional settings are made available in the settings tab of each question on the form. The options available here are pre-determined based on data that the web service API expects for event registrations.

Student Housing Application

CRM Student provides mappings in the J1 Mapping Tool screen in the form of the Housing Application form type. When using this form type, additional fields are displayed in the mapping tool to allow for questions on the form to be mapped to data points that the API end point for housing applications expects.