How do I insert the value of one contact field into another contact field?

There are two different methods you can use to copy the value of one contact field into another contact field:

If you wish to copy the value of a contact field into a deal custom field instead, see this help article.

Export/Import your list

This option requires you to export your contacts to a CSV file and re-import them, making sure to map the field in your file to a new field in your account.

In this example, we’re going to take the value of a date field, and move it over to a text input field. 

1. Click the “Export” button located on the Contacts Overview page.

2. The CSV file will begin to download immediately. Open the file and remove all fields except for the email address field and the field you wish to copy into a new contact field:

3. Next, click the “Import” button located on the Contacts Overview page.

4. Click the "Import from file" button.

5. A file browser appear. Navigate to the file you wish to import and click it to select it.

6. On the import page, click the "Map Into Field" dropdown for the field you wish to import then click "[Add New Field]."

A modal window will appear and you will be asked which type of field you'd like to create. Click the field type, then click "Next."

Next you'll need to give your field a name and provide answer options (if applicable).

When finished, click "Save."

7. Skip both the List Selection and Add Tags section on the Import page.

Since you are only taking the value of one contact field and adding it to another contact field, you do not need to select a list or add any tags at this time. In addition, if you select a list in this step, you risk giving any unsubscribed contacts an "Active" status for that list.

8. Click “Update Existing Contacts” and then click “Import Now.”

The value of your original contact field will be added to your other contact field.

Zapier

This option uses a webhook and an automation that will automatically update your contact field. This option requires that you have an ActiveCampaign account and a Zapier account.

In this example, we’re going to update the system phone field with the value of a custom contact phone field.

1. Go to the Automations Overview page and click “New Automation.”

2. Click "Start from Scratch" then click "Continue."

3. The Automation Trigger modal will open. Click "Field Changes" then click "Continue."

4. Select the custom phone field from the field dropdown. Next choose if you want this trigger to run if this field changes ever or to a specific value. In this example, we’re going to choose “ever.”

5. Next, you can choose how often this trigger will run.

In this example, we’re going to choose “the first time” the contact is “added or updated.”

6. Click "Add Start."

7. Open a new tab or window in your browser and log into your Zapier account.

8. Click “Make a Zap!”

9. Choose “Webhooks” for your Zap trigger.

10. Select “Catch Hook” and click “Continue.”

11. Zapier will generate a webhook URL for you. Click “Copy to clipboard.”

12. Go back to your ActiveCampaign automation and click the node (+).

13. Click Conditions and Workflow > Webhook.

14. Add your Webhook URL generated from Zapier into the URL bar and click "Save."

15. Click "Active" on the top right of your screen to turn your automation on. (Zapier will need you to run a test contact through this automation.)

This is how the automation will look:

16. Add a test contact to your automation. To do so, select a contact with a phone number in the custom phone field from the Contacts Overview page. Then click “Add” in the automations section of the contact’s profile page.

17. Go back to your Zapier account to setting up your Zap and click “Continue.”

18. On the next screen, click “Continue” again to proceed to the “Test this step” step.

19. Click “OK, I did this” to run a test.

20. Click “Continue” on the next screen to proceed with setting up your action.

21. Select “ActiveCampaign” from the list of available apps.

22. Select “Create/Update Contact” and click “Continue.”

23. Connect your ActiveCampaign account to Zapier if it’s not yet connected:

24. On the next page, you will be required to select a List and map the email address field.

25. On that same page, locate the Phone Number field. This is the field that can be used with the SMS feature. Then map that to your custom phone field. Then click “Continue.”

26. On the next page, click “Create & Continue” to test your action:

27. Once the test is complete, click “Finish.”

28. Give your Zap a name and click the toggle to turn it on.

Your Zap is now set up. Now, the first time a contact is added/updated with a value for the custom phone field, they will be entered into your automation where they hit your webhook step. That webhook will send information to Zapier, and Zapier will update the system phone field with the value of your custom phone field. This will all be done automatically.

Have more questions? Submit a request