Convert 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).


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

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.  


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 


Still have questions?

Feel free to send our support team an email, or you can call the phone number found in the lower left hand corner of your Kindful Admin account to speak to a team member. 

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

Comments