How to Import into a Connection Field

I'm having trouble importing into a connection field. What can I do?

First-Time Importing Connections

If it's your first time importing into a connection field, we recommend you start by reviewing this article: Importing Connections.


Importing Multiple Connections

If you're trying to import multiple values into a connection field, take a look at this section of the article: Importing to a Many-to-Many Connection Field.


Check the Connected Table

To connect a record in your import file to a record in a connected table, the connected record must already exist. For example, if you are importing a new Employee and want to connect them to the Sales department, the Sales department must already exist in the "Departments" table.


Check Your Mapping: Columns to Fields

When connecting records through an import, you need to match one of the columns in your import file to one of the fields in the connected table. That way the system knows which connected record to connect to the record being created or updated by your import:

howtoimportconnection1

You will need to make sure that you’re matching a unique field in the connected table. Auto increment fields are great for matching, though several field types can be set to "Must be unique":

mustbeunique

Tip: If you have any further questions on importing data into connection fields, please don't hesitate to reach out to our support team. You can reach the support team via the chat widget in the Builder or by submitting this form

 

Learn more about importing in the following articles: