Help

Paste sets of number data into a multiselect field

Solved
Jump to Solution
1657 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Dev_Ops
5 - Automation Enthusiast
5 - Automation Enthusiast

I need to copy sets of data from Google sheets over to Airtable’s mulitselect field.

I have successfully copied the Example A sets of data into a multiselect and it works. But for some reason Example B data copies only 1 set of data, not the entire data set.

How can I achieve the same results as example A for example B.

Example A
contentIdComplete:
5ff7f3ea61d89c3d4f1a00f6,5ff7f40f4d6d0a37a3879004,601bdf764ac7ca3c4ae31211,601be02d58c9a36f26a0f9b8,60226b2bca657c6d5a43ccd1,60226d622a2f924017052bcc,

Example B
contentIdCompleteDate :
1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,

Watch the Loom video
https://www.loom.com/share/825d9c899c7c4762817030d95def3ad1

1 Solution

Accepted Solutions
Alexey_Gusev
13 - Mars
13 - Mars

Hi,
maybe i don’t understand something, but it seems like you are triyng to copy the same number repeated many times which of course will result in a single value in a multiselect field
Like this (when i copy ‘numbers’ to multiselect field)
image

See Solution in Thread

5 Replies 5

Welcome to the community, @Dev_Ops!

That’s very bizarre. This could be a bug in Airtable. What if you change the multiselect field to a linked record field (which is linked to a new table where the first column is text or number)? Does it work then?

Alexey_Gusev
13 - Mars
13 - Mars

Hi,
maybe i don’t understand something, but it seems like you are triyng to copy the same number repeated many times which of course will result in a single value in a multiselect field
Like this (when i copy ‘numbers’ to multiselect field)
image

Oh, that’s correct, thanks! Values cannot repeat in a multiselect.

Simple yet I missed this. Thanks Alexey.

Case solved and closed.

Thank you Scott. I appreciate the help.