Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

When you create custom objects, you must provide link fields to connect the custom object record to the correct parent record.

Numbered Headings
start-numbering-ath5
  • For a one-to-many custom structure, use the link field in the custom object to connect it to a person or a company.
  • For a many-to-many structure, you use two link fields, connected from a separately created intermediary object (which is a type of custom object, too). One link connects to people or companies in your database and the other connects to the custom object. In this case, the link field is not located in the custom object itself.

Table of Contents
maxLevel4
minLevel4

Create a Link Field for a One-to-Many Structure

Here's how to create a link field in a custom object for a one-to-many structure.

 Click Admin, and in Database Management, select Marketo Custom Objects.

Select the custom object in the list.

In the Fields tab, click New Field.

Name the link field and add an optional description. Be sure to select the Link data type.

Marketo caution

You won't be able to go back and create, edit, or delete a Link or Dedupe Field once the custom object is approved.

Select whether the link object is for a lead (person) or a company.

Marketo note

If you choose lead, you'll see Id, email Address, and any custom fields in the list.

If you choose company, you'll see Id and any custom fields in the list.

Select the link field you want to connect to as the parent of the new field.

Marketo note

Only string field types are supported in the link field.

Click Save.

 

Create a Link Field for a Many-to-Many Structure

Here's how to create a link field in an intermediary object for use in a many-to-many structure.

Marketo prerequisites

You must have already created the intermediary object and any custom objects you intend to link it to.

Numbered Headings
start-numbering-ath5
Click Admin, and in Database Management, select Marketo Custom Objects.

Select the intermediary object you want to add the field to.

In the Fields tab, click New Field.

You need to create two link fields. Create them one at a time. First, name the field for the members of your database list (leadID, for example). Add an optional description. Be sure to select the link data type.

Marketo caution

You won't be able to go back and create, edit, or delete a Link or Dedupe Field once the custom object is approved.

Select the link object from your database, in this case Lead.

Select the link field you want to connect to, in this case, Id.

Marketo note

Only string field types are supported in the link field.

Click Save.

Repeat this process for the second link to your custom object, in this example, courseID. The Link Object Name will be course, and the Link Field will be courseID. Since you already created and approved the course custom object, these selections are available in the drop-down menus.

Create any other fields that you want to use in your intermediary object, such as enrollmentID or grade.

Using Custom Objects

The next step is to use these custom objects in filters in your smart campaigns. With a many-to-many relationship, you can select multiple people/companies and multiple custom objects. In the example below, anyone in your database who matches these criteria will be listed. The coursename field comes from the course custom object and the enrollment grade comes from the intermediate object.

 

Marketo whats next