Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: ImportingExporting
1656 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Andres_Felipe_V
4 - Data Explorer
4 - Data Explorer

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 looksCaptura de Pantalla 2021-03-15 a la(s) 5.44.01 p. m. Captura de Pantalla 2021-03-15 a la(s) 5.44.35 p. m.

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 2
arielleroot
4 - Data Explorer
4 - Data Explorer

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.