Help

Re: How to batch update "multiple select" fields via CSV import?

Solved
Jump to Solution
1062 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Citizen_Univers
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a base with a “multiple select” field type — and I would like to update some of the fields based on data from a CSV import.

I’ve looked into three angles…

  1. As I understand it, CSV imports can’t update a field, just override it. But my fields have existing data that I want to add to, not override.
  2. It’s also not possible to merge fields (if I were to import the data into a new column, I couldn’t combine with the existing data).
  3. Because I only want to update certain records, I can’t do a batch update (which would apply to all fields).

Am I misunderstanding any of these pathways — or is there something else I don’t know about yet? Thank you!

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Oh, I misunderstood what you wanted to do with the CSV import. Right, it will never append to a field, but it will leave other fields alone if it updates an existing field upon matching.

I always use Make.com to import CSV fields and merge data at the same time, but that’s a highly advanced tool so I wouldn’t recommend it if you’re brand new.

Instead of using the concatenate function, I find it easier to just put the & symbol in between what you want to concatenate. For example:

{Field 1} & "," & {Field 2} & "," & {Field 3}

See Solution in Thread

4 Replies 4

Welcome to the community, @Citizen_University!

I believe that the CSV import extension will update existing fields for matching records, if you set it to match records. I didn’t test this today, so this is just off the top of my head.

The batch update extension will let you perform a wide variety of batch updates to your records.

There are several ways to merge data:

(1) You could create a formula field that combines data from multiple fields, and then change that formula field to another type of field afterwards.
(2) You could create an automation that merges data.
(3) You could write a script that merges data
(4) You could use an automation tool like Make.com to merge data.

There are probably many other ways as well that I’m not thinking of.

Thanks for the quick reply, @ScottWorld!

I just did another CSV import test, and it overrode the existing fields with matching & merging. (See screenshots below.)

I looked into the CONCATENATE formula feature, but wasn’t able to figure it out for merging multiple select field types. Any tips?
Screen Shot 2022-07-14 at 3.32.38 PM

Screenshot examples of the CSV import:

Screen Shot 2022-07-14 at 3.21.21 PM
Screen Shot 2022-07-14 at 3.21.41 PM
Screen Shot 2022-07-14 at 3.21.57 PM

ScottWorld
18 - Pluto
18 - Pluto

Oh, I misunderstood what you wanted to do with the CSV import. Right, it will never append to a field, but it will leave other fields alone if it updates an existing field upon matching.

I always use Make.com to import CSV fields and merge data at the same time, but that’s a highly advanced tool so I wouldn’t recommend it if you’re brand new.

Instead of using the concatenate function, I find it easier to just put the & symbol in between what you want to concatenate. For example:

{Field 1} & "," & {Field 2} & "," & {Field 3}

Citizen_Univers
5 - Automation Enthusiast
5 - Automation Enthusiast

Ah ok I figured it out! I used that formula to merge, then I changed the field type to multiple select. Thanks for walking me through it!