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 using this method.
- Go to the Contacts overview page in your account and click on “Export.”
- Open your CSV file and remove all fields except for the email address field and the field you wish to copy into a new field:
- From the Contacts overview page, click “Import.”
- Click “Import from file.”
- Choose your file from your hard drive.
- Map the column in your csv file to the new field in ActiveCampaign. In this example, I’m going to create a new field to store this information in right from the Import page. To do that, choose “Add New Field” from the Map into field dropdown. Then select the Field type from the modal pop up and click “Next.”
- Give your new custom field a name and click “Save.”
- For this update, you do not need to select any lists or add tags as we are only copying the value of one custom field and adding it another.
- Click “Update Existing Contacts” and then click “Import Now.”
- As you can see, the value of my Custom Date field “Webinar” has been pasted into a custom text input field called “Upcoming webinar”:
This option uses a webhook and an automation that will automatically update your 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 phone field.
- Go to the Automations Overview page in your account and click “New Automation.”
- Select “Start from Scratch” and click “Continue.”
- From the trigger modal, select “Field Changes” by clicking it.
- 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.”
- 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.”
- This is how our trigger looks:
When ready, click “Save Start.”
- Open a new tab or window in your browser and log into your Zapier account.
- Click “Make a Zap!”
- Choose “Webhooks” for your Zap trigger:
- Select “Catch Hook” and click “Continue.”
- Zapier will generate a webhook URL for you. Click “Copy to clipboard.”
- Go back to your ActiveCampaign automation and click the node (+). Then select Conditions and Workflow > Webhook.
- Add your Webhook URL generated from Zapier into the URL bar and click “Save.”
- 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 our automation looks:
- 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.
- Go back to your Zapier account to return to setting up your Zap and click “Continue.”
- On the next screen, click “Continue” again to proceed to the “Test this step” step
- Click “OK, I did this” to run a test:
- Click “Continue” on the next screen to proceed with setting up your action.
- Select “ActiveCampaign” from the list of available apps.
- Select “Create/Update Contact” and click “Continue.”
- Connect your ActiveCampaign account to Zapier if it’s not yet connected:
- On the next page, you will be required to select a List and map the email address field.
- 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.”
- On the next page, click “Create & Continue” to test your action:
- Once the test is complete, click “Finish.”
- 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.