The Basics
      Back to home
      1. Knowledge Base
      2. Importing Data
      3. The Basics

      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: