Setting up Connect Fields (Lookup Fields)

ProBiz.png

  • Note: Connect fields feature is available for trial, professional and business accounts. 
    We do not currently have filtering, field validations, and other 3rd party integrations, import, lead conversion, bulk-edit, merge, or global search.
  • Our Business and Professional plan allows you to create an unlimited number of connect fields
  • A connect field can have up to 30 connections
  • If your Connect Field has the SAME NAME as one of Copper's default fields, Copper will import your Connect Field data into the matching default field.

The Connect Fields feature allows you to create a custom relationship between a single record and multiple other records. If you need to go beyond using the 'Related' section of a record profile to define why these records are related, or if you need to create a 1:many relationship between records, connect fields are here for you.

For example, you can use connect fields to indicate the relationship between a manager and his/her direct reports. Other common examples for connect fields include keeping track of referrals, parent and child companies, multiple opportunity owners, investors, and more. Using Connect fields can help you save time keeping track of relationships since it only requires one data entry.

In this module, we'll tackle the following:

Understand Connect Fields

Define your workflow

Create a connect field

Understand Connect Fields

Connect fields can appear on every record except tasks.  In other words, you can create connect fields for leads, people, companies, opportunities and projects.

Connect fields follow a similar pattern:

  • Record A
  • Is connected via _____ circumstances
  • To record B

And

  • Record B
  • Is connected via _____ circumstances
  • To record A

Let's look at some examples.

You might choose to connect two different records:

connect_fields_1.png

You can relate two of the same record type:

connect_fields_2.png

Once you've created a connect field, both sides of the relationship will be shown on a record. Here we can see that person record Jenn Prince is managed by Jared Abercrombie, and she manages Alex Vergara and Brett Carlito: Connect_Field.png

On person record Alex Vergara's profile, we can see he is managed by Jane Prince and does not manage anyone himself: cf2.png

Beyond connecting two records together, you can connect a record and a user. Note that a company user doesn't have a record profile, so this is a uni-directional field. That means it will only show up on the profile of the record the user is connected to:

connect_fields_3.png

The result of creating this connect field would look like this: CF4.png

As you can see, only the relationship from the user to the lead is listed. We don't list the relationship from the lead to the user because there is no user record for it to show up on.

Define your Workflow

There are two ways to establish a relationship between records in Copper, so it's important to ask yourself a few questions to determine which field type is best for you:

  1. Do you want to customize the relationship between two fields? In other words, is it enough to say that a person is related to a company, or would you like to include a field name that explains the relationship?
    • If you want to explain the relationship, use Connect Fields, as these let you customize the field label.
    • If it's enough to say one record type is related to another and not define the relationship further, you can just relate two fields together.
  2. Do you want to rely on email and activity syncing between records?
    • If yes, use the related fields feature. Connect fields won't enforce email or logged syncing between records.
    • If not, use Connect Fields or Related Fields depending on your response to question 1.
  3. Do you want to relate two records of the same type together (e.g. a person to a person)?
    • If yes, use connect fields. 
    • If no, use either connect fields or related fields depending on your answers to questions 1 and 2.

Create a Connect Field

  1. Sign into your Copper account, and click 'Settings.'
  2. Choose 'Field Settings' under 'Customize Copper.'
  3. Click the record type you want to create the field for. (Note: We don't currently have a record type for 'Company User' so you need to initiate a field that's related to a company user from the related record type). Fields1.png
  4. Click the blue button to 'Create Field.'
  5. Set the 'Type' as 'Connect Field.'
  6. In the 'Relationship' drop-down, you can select 'Custom Relationship' to build a connect field from scratch. You may also see options for pre-built connect fields created by our Product Team depending on the record type you're creating the field for. You're welcome to choose these instead: CFRelationship.png
  7. Now you'll build the actual relationship between the fields. In the example below, we can see that each label describes the relationship between these two people records. One is the manager of the other, so the label for the manager's person record is 'Manager Of,' and the label for the direct report's person record is 'Managed by.' CFManager.png
  8. Click 'Create Field.'
  9. When you open a record to see the field displayed, you can click into each field label to fill it out. You can click the 'Add Connection' link to connect more than one record to the existing record: cf3.png

Still have questions?

Still have questions? Ask in our Community, and get answers from our Customer Success Team as well as fellow users.

Was this article helpful? 6 out of 6 found this helpful