What's the easiest way to add a Country column?

[Joel]

I want to create a Single Select field with a list of all countries so that users can fill it out in a form. What’s the easiest what to do this without having to add every single country individually?

Thanks!

[Mark_Molter]

A somewhat not so clean option: Create a Single table with a single Field. Copy and Paste country names so each country is a record. Use the link record functions and make sure to turn off multiple links options.

[Mark_Molter]

I’d love a option like this for States too!

[Joel]

Thanks! But yeah the idea of creating a table with no use that’ll stick around forever doesn’t feel great.
Is there really no way to paste multiple choice options?

[David_Skinner]

Get all of the country names in a text editor (or a spreadsheet) with each country on a separate line (or row). Select all and copy. Now go to your airtable base. Go to the record at the bottom of the table. Click on the single select country field. Paste the country values in. Choose to expand the table. This will create a new record for each country. You can now delete those records and the single select options will remain in the field.

[Alex_Wolfe]

Here’s a thread where the first link may be helpful (at least for the US states):

Helpful Pre-Made Data Tables, Formulas, and Routines Show and tell

These are static tables I find myself using frequently when building bases for clients, so I keep a copy of them on their own in my account so I can easily copy-paste them into bases when needed. I’m creating this wiki to share them in case other people might want to use them, or contribute their own reusable pre-mades. To make use of these, open the base through the links below, then use the “Copy base” button (top right corner) to add a copy of it to your own workspace. Then, you can copy (⌘/…

[Monica_Ferro1]

David_Skinner You are the best!! Thank you! Thank you! Thank you! You have solved the biggest problem I’ve had with Airtable. This works beautifully! Airtable MUST add this to their tips and tricks. Will use it for other information like state/provinces and more

[Alice_Gardner]

David_Skinner you rock!!! It works. There is a God. :slightly_smiling_face:

[Faisal_Khan1]

You’re a god send. Anytime you want a drink. Lemme know.

[Curtis_Duggan]

I have a link to public base with all the Countries, Capitals, Currencies and Flags. You can copy the Countries column or whatever you need. Just scroll down here:

curtisduggan.com

Curtis Duggan - Personal Website — Startups, Entrepreneurship, Creation

Curtis Duggan is a entrepreneur and creator from Canada. He has been involved in one startup exists (Blue Mesa Health sold to Virgin Pulse in January 2020) and is CEO of Streamline Genomics.