Skip to main content

How to paste data in a "Multiple select field" and get multiple choices, and not single ones


Forum|alt.badge.img

Hello,

I have a table with +400 records, and I want to ask a question about a “Multiple Select” column. How can I upload (or paste) separate records that I have in a CSV file, and put all of them as different categories in a “Multiple Select” column?

The context of this is that I have a Form in FormAssembly and currently in the Multiple Select column I have countless records of unique categories, that include records that merged several categories (we had pre-defined 12 options).

Here is a screenshot of how it currently looks

I’m trying to solve this in a separate Spreadsheet where I created a CSV file with this column, I separate it but with formula and manually into different columns, and now I want to go back to Airtable and organize the “Multiple Select” column.

Does someone have any advice for how to do this?

2 replies

Forum|alt.badge.img+1
  • New Participant
  • 2 replies
  • March 19, 2024

Bump.

Did you ever figure this out? I have this same question.


Forum|alt.badge.img+1
  • New Participant
  • 2 replies
  • March 19, 2024
arielleroot wrote:

Bump.

Did you ever figure this out? I have this same question.


Oh I figured it out! You just needed your semicolons to be commas.


Reply