Skip to main content
Solved

Paste sets of number data into a multiselect field

  • February 5, 2022
  • 5 replies
  • 31 views
D

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

Best answer by Alexey_Gusev

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)

    5 replies

    ScottWorld
    Forum|alt.badge.img+35
    • ScottWorld
    • Genius
    • 9822 replies
    • February 5, 2022

    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
    Forum|alt.badge.img+25
    • Alexey_Gusev
    • Brainy
    • 1261 replies
    • Answer
    • February 6, 2022

    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)

    ScottWorld
    Forum|alt.badge.img+35
    • ScottWorld
    • Genius
    • 9822 replies
    • February 6, 2022

    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)


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

    D
    • Dev_Ops
    • Author
    • New Participant
    • 3 replies
    • February 6, 2022

    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)


    Simple yet I missed this. Thanks Alexey.

    Case solved and closed.

    D
    • Dev_Ops
    • Author
    • New Participant
    • 3 replies
    • February 6, 2022

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


    Thank you Scott. I appreciate the help.


    Terms & ConditionsAccessibility statement