Skip to main content

Return to TX Community

Liaison

Using Profile Builder for Student and Contacts

Profile Builder, also referred to as 'Source to Master,' provides the ability to roll up information to fields on the Contact (Student) record from any related records (ie., records from objects related to the Contact by way of a master/detail or lookup relationship; such as Application, Enrollment History, Inquiries, and Test).

When changes are made to related records or new records are created, the information on the Contact is updated accordingly, ensuring the data is up-to-date. The result is a profile of the contact/student that is current - and allows for easy viewing, reporting, and other communication activities.  

For example, a student might have inquired about multiple programs as a prospective student but applied to only one. The profile builder will show the latest inquiry and key application information on the contact/student record.

Configuration

New custom objects are delivered to support the configuration of a user-defined profile.

  1. Source to Master Object - Determines from which source object data will be rolled up and the Order By logic.
  2. Tracked Field - Specifies which fields to map data to on the Contact record.

Follow the steps below to configure the Profile Builder.
 

Step 1: Confirm Versions of Base Package and Recruitment Manager

Profile Builder requires you to have the following:

  • Base Package 1.37 or higher.
  • Recruitment Manager 2.66 or higher.

Step 2: Create Tabs to Access Custom Objects

  1. ​Go to 'All Tabs' ( + ) and search for 'Source to Master Objects.' If present, skip this section. If not, complete the following steps to create a tab.  
  2. Go to Setup and search for Tabs.
  3. Create a custom tab for the 'Source to Master Objects' object, assign the 'Wrench' Tab Style or other - as desired, and click Next.  
  4. Assign Default Off tab security to all profiles and click Next.

Step 3: Enable Profile Builder Triggers

  1. Navigate to the RM Preferences tab.
  2. Enable all/any desired triggers related to 'Profile Builder.' Enabling a trigger for the specified object allows data from those records to be rolled up to the Contact record.
  3. The Batch Rollup Object and Batch Rollup Context fields allow you to run a batch job to create rollups.
  • Batch Rollup Object - Select the object to run the batch rollup. The batch rollup job can be performed on one object at a time. Please wait for the confirmation email that batch rollup has been completed before running the batch rollup on another object. The Run Rollup button runs a batch job to perform a rollup on the selected object in the "Batch Rollup Object" field.
  • Batch Rollup Context - Select "Process All" to run rollup on all records. Select "Process Tracked" to run rollup on all records with values in tracked fields.

Profile Builder rollup settings

Notes:

  • These Settings should only be enabled for objects already set up to use Source to Master.
  • BEFORE running batches, uncheck the Related Contacts Async checkbox in Base Custom Settings and recheck once the batches complete.

Step 4: Edit Page Layouts

  1. Go to Setup and select Object Manager.
  2. Select the following objects and edit their default page layouts:
  • Source to Master Object

    • Include all fields
    • Add Tracked Field related list to the page layout
  • Tracked Field

    • Include all fields

Note: Recommended to list the Source Field and then the Target Field in the left-hand column.

Step 5: Create Target Fields on Contact Object

  1. Go to Setup and search for Fields.
  2. Create a new custom field of the same data type on the Contact object for each field that will be rolled up from a related record.

Note: Name fields and set security appropriately.

Step 6: Create Source to Master Objects Records

  1. Go to 'All Tabs' ( + ) and click 'Source to Master Objects'
  2. Configure each object that has a relationship to the student/contact record:
  • Select 'New'
  • Enter the 'Source object' field value as the fully qualified 'Relationship Name.' The Relationship name value can be built by following the steps below:
    • In a separate browser tab, navigate to the object you wish to roll up data (e.g., Inquiry, Application, etc.).
    • Click the Field Label for the Contact Lookup field on the object.
    • Concatenate the following information from the Contact Lookup field to build the 'Source object' field value. (Note: this is standard SoQL syntax for referencing child relationship fields).
  • First, add the 'Namespace Prefix' from the Field Information section
  • Add double underscore ( __ ) after the above value
  • Next, add the Child Relationship Name from the LookUp section
  • Finally, add double underscore + the ‘r’ character ( __r )

For example, the Relationship Name for the Inquiry Object would be:
    TargetX_SRMb__Inquiries__r

Note: If you're unsure of these steps, please contact TargetX Support.

  • Enter an Order By clause - of 'CreatedDate DESC.'

    NOTE: You can customize the 'Order by' clause, depending on your needs. When ordering by multiple fields, the order by clause should not contain spaces before and after the comma. For example, TargetX_SRMb_Stage_c ASC,CreatedDate DESC  
     

Examples:

  • CreatedDate DESC
  • TargetX_SRMb__Application_Submit_Date__c DESC
  • TargetX_SRMb__Start_Term_Year__c DESC

Step 7: Configure Roll-Up Field Mappings

NOTE: Only one source to master record per source object is supported - meaning you cannot have one source to master rolling up Application data based on orderby clause A and another source to master rolling up Application data based on orderby clause B. You can roll up multiple source fields from the source object in one source to master record, and all must use the same logic criteria.

  1. For each 'Source to Master Object' record, add tracked field records for each field to be rolled-up from the related object to the contact object.

  • Select 'New Tracked Field' on the Source to Master record
  • Enter the API name of related Source Field (on related object)
  • Enter the API name of related Target Field (on Contact object)
  • Select Save or Save & New to add more fields for the same source object.

Note: Field updates will fire based on the Create Date on the related object records. Each field from the child object can only be mapped once; you cannot map the same field twice to two different fields.

Profile Builder Object Names

  • TargetX_SRMb__Application__r
  • TargetX_SRMb__Enrollment_History__r
  • TargetX_SRMb__Inquiries__r
  • TargetX_SRMb__Test__r


For additional information, see Profile Builder for Retention.

  • Was this article helpful?