Skip to main content

Add Masive Options to Multiple Select o Single select

  • March 1, 2021
  • 6 replies
  • 217 views

Forum|alt.badge.img+3

Hi,
I am using the Typeform integration and one question (single select) has 750 options.

In Airtable: It is possible to massively add options to the single selection or multiple selection. Instead of paste it the 750 options one by one.

thanks

6 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9808 replies
  • March 1, 2021

If you import all of your options into a “single line text” field as 750 different records, you can then convert your field to a “single select“ field afterwards, and it will convert your records into the single select options.

However, 750 options is a lot of options. You may want to consider keeping your options as individual records in their own table, and then using a linked record field instead of a single select field to select the appropriate option.

Also, the most important thing to note here is that Typeform is not the best form software for integration with Airtable, unless you’re using Make’s Typeform integrations to get your data into Airtable. Make will let you connect your form directly to your single select field, as long as you enable the “Smart Links” option in your Airtable modules in Make  

But instead of jumping through all of these hoops, your #1 best bet for external form integration with Airtable is Fillout’s advanced forms for Airtable, because it directly communicates with Airtable and can easily do everything that you requested.

Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a formcreate custom PDF files from a form submissionaccept payments on formspre-fetch dynamic data from an Airtable recordcustomize the style and branding of your formcustomize a theme for your form, display Airtable lookup fields on forms, create new linked records on a formadd a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 2 replies
  • March 1, 2021

If you import all of your options into a “single line text” field as 750 different records, you can then convert your field to a “single select“ field afterwards, and it will convert your records into the single select options.

However, 750 options is a lot of options. You may want to consider keeping your options as individual records in their own table, and then using a linked record field instead of a single select field to select the appropriate option.


Thanks @ScottWorld
nice trick that converts single line text to single selection. But sadly, it doesn’t recognize all fields as unique. The 750 fields were only separated into 3.

In the other way you proposed it´s actualli the better. But I think I need to configured the integration through single or multiply select first. And then via automation linking the record. So I think that I both cases I will need to find the way of add the 750 record to the “multiple select”

Please let know if I´am understanding correctly

thanks!


Forum|alt.badge.img+19
  • Inspiring
  • 3263 replies
  • March 1, 2021

If you import all of your options into a “single line text” field as 750 different records, you can then convert your field to a “single select“ field afterwards, and it will convert your records into the single select options.

However, 750 options is a lot of options. You may want to consider keeping your options as individual records in their own table, and then using a linked record field instead of a single select field to select the appropriate option.


Also know as purely insane. :winking_face: But sometimes there are good reasons to act insanely passionate. The bigger worry is if there are 750 options today, will there be 1200 tomorrow?


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9808 replies
  • March 1, 2021

Not sure… you might need to put quotation marks around each option.

Although, as I mentioned above, it does seem like the “linked record field” idea might be better for you in order to manage this lengthy list better.

2025 Update:

You will want to switch away from TypeForm and use Fillout instead, which is 100% free and fully integrated with Airtable.


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9808 replies
  • March 1, 2021
 
ScottWorld:

However, 750 options is a lot of options.

Also know as purely insane. :winking_face: But sometimes there are good reasons to act insanely passionate. The bigger worry is if there are 750 options today, will there be 1200 tomorrow?


Bill.French:

The bigger worry is if there are 750 options today, will there be 1200 tomorrow?

Right! This seems like a better project for an entire table’s worth of records, which is why linked records is better.

And using Fillout instead of TypeForm is the winning move.


Forum|alt.badge.img+1
  • New Participant
  • 1 reply
  • June 16, 2025

If you import all of your options into a “single line text” field as 750 different records, you can then convert your field to a “single select“ field afterwards, and it will convert your records into the single select options.

However, 750 options is a lot of options. You may want to consider keeping your options as individual records in their own table, and then using a linked record field instead of a single select field to select the appropriate option.

That’s one fine trick there, sir! Thanks