I’m trying to import new data to my existing list of contacts in Active campaign, Data is in excel spreadsheet and I can save it in CSV file.
Problem is that one of the fields in AC is a multiple choice checkbox custom field. I need to tick some options on some of the contacts. I have this new information in external file.
When I run the import contacts option, the value in this custom field gets completely overwritten. I loose past data. I want to e.g. add new choice to customer but keep the existing options checked as well.
I tryed to add || in front of the value in the CSV file but it doesn’t work. Is there any other special character which AC can interprete? One for adding choices and maybe one for deleting them?
I searched the knowledge base but cant find any solution.
Thanks for help,
P.S.: We are planning to automate the process of adding information through an API, but until we do this we just have to do it semi-automatically