Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Nov 29, 2021 10:52 AM
Hi all, I have a csv file with a column that contains the name of the project associated with the client. So I have a csv file with 2 columns:
customer email, project name.
I have to import this file into the customer table on Airtable where the “merge field” is the email and the project name must be inserted in a multiselect field. The problem is that many customers already have projects in their multiselect field and doing this import is all overwritten and only the last imported project remains.
So the question is how is it possible to import (add) new values in “multiselect field” without overwriting the already existing values?
Thanks so much everyone for the help
Solved! Go to Solution.
Nov 30, 2021 07:06 AM
Hi,
add project_name values in a new text field
create another formula field with
ARRAYJOIN( existing_multiselect_field & ‘,’ & new_field, ‘,’)
ignore trailing commas, that may be present if one or both fields are empty
turn formula field into multiselect
Nov 30, 2021 07:06 AM
Hi,
add project_name values in a new text field
create another formula field with
ARRAYJOIN( existing_multiselect_field & ‘,’ & new_field, ‘,’)
ignore trailing commas, that may be present if one or both fields are empty
turn formula field into multiselect
Nov 30, 2021 10:36 AM
Fantastic! thank you Alexey!