Add Marketo Custom Object Link Fields add-marketo-custom-object-link-fields
When you create custom objects, you must provide link fields to connect the custom object record to the correct parent record.
- 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.
Create a Link Field for a One-to-Many Structure 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.
-
Go to the Admin area.
-
Click 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.
note caution 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.
note note 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.
note note NOTE Only string field types are supported in the link field. -
Click Save.
Create a Link Field for a Many-to-Many Structure 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.
-
Go to the Admin area.
-
Click 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.
note caution 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.
note note 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 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.