I am maintaining a contacts CRM database for my supervisor in Airtable. We imported LinkedIn contacts, however, now with everyone changing jobs, the companies and positions are not updated. I attempted to download the connections from LinkedIn and then do an Import CSV merge so that the contacts can update. Zapier does not have a linkage between LinkedIn and Airtable for this kind of trigger.
However, my supervisor has many contacts that have similar last name, first names that are repeated. The Last Name and First Name columns were originally separated, I then tried to combine them with a formula into a new column.
When I import the CSV file and try to find the drop down menu for merging, the new 3rd formula column is never available. (I had already formatted the CSV file to have a “Last Name, First Name” column with a space between the comma, etc.) So the CSV cannot find the right columns to merge with. Since there are 1000+ contacts, I did not want to copy and past everything. Is there a solution? In Import CSV Merge settings, can you merge with a new column that is made from a formula?