Import Contacts and Add to Groups -- Converting Text Custom Fields into Select Custom Fields

Overview

This article explains how to convert Contact Custom Fields from a "text" value to a "select" value. Use this method so you can filter on the custom fields values and create Reports and/or Groups. This method is commonly used when importing data into Kindful. 

Linked Articles:

Using the Import Data Tool

Custom Contact Fields

Create Custom Reports


Preparing Your Data in Your Imported CSV

To create a contact custom field in a filterable format upon import, begin with the data in your imported CSV. Be sure to label the column header with the name that represents something relevant to you (e.g. the custom field value will be used for, as represented in Row AV - "Group Name" - in the example below). The values in the rows below the header row represent each of the custom field values (e.g. Group 1, Group 2, Group 3).

Screen_Shot_2020-01-14_at_7.24.28_AM.png

When mapping this field in the Import flow, be sure to match this column on your CSV to "Contact Custom Field".

Screen_Shot_2021-06-04_at_9.26.36_AM.png


Change the Custom Field Type

Once the import and subsequent move of the data to production is complete, head to Settings > Contact Settings > Custom Contact Settings and navigate to the Contact Field Groups tab.

Here, you will see your newly imported custom field. The name will include a long code, which is the Import ID. To make these changes, click Edit

Screen_Shot_2021-06-04_at_9.28.55_AM.png

In the "Questions" section, you will see the same name that was in the column header of your imported CSV (e.g. Group Name). It will be set as a Text field, which is default for the import tool process.

The next step is to change the field Type from Text to Select, and then enter in each option exactly as it appears in your spreadsheet in the Group Name column. Separate each possible value with a comma.  

Screen_Shot_2021-06-04_at_9.28.32_AM.png


Segmenting These Contacts

You can filter for contacts with these values on the Contacts or Activities page using this filter:

To Custom Field: Group Name, Group 1 


Moving These Newly Updated Fields to Previously Existing Custom Fields

After completing the import you will see the new Text-based custom fields created (e.g. Group Name).

You will first change this Custom Field from a Text Type to a Select Type, and enter all of your common answers as values separated by a comma.

Once this is done and you have the newly created and updated custom field, you can head to the Contacts page and use the Bulk Edit Tool. This will allow you to move the contacts connected your newly minted custom field (from the import), and apply it to the Custom Field that previously existed.

Of Note: When using this process, we recommend naming the new custom field slightly different than the existing custom field you are wishing to move these contacts to. This will help you identify the proper value when Bulk Editing. 


Adding Custom Fields Values Via Import to Already-Existing Custom Fields

Our import tool allows you to import to already-existing contact custom fields, which can save you from needing to do the steps highlighted above.

To perform this process, follow the same steps as above; however, when entering data into your CSV, be sure that both the Custom Field name (the column named "Group Name" in our above example) matches exactly to an existing custom field in Kindful. Then, be sure that the answer values (Group 1, Group 2, etc., in our above example) match exactly to the existing custom field answer values in Kindful. 

For example, if this is your existing Contact Custom Field setup:

Screen_Shot_2021-06-04_at_9.28.32_AM.png

Be sure to import the column on your CSV like this:

Screen_Shot_2020-01-14_at_7.24.28_AM.png


Still have questions?

Feel free to send our support team an email, or you can start a live chat with a team member found in the lower left hand corner of your Kindful Admin account.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments