Does anyone have a database with all cities in the world?

[miyazhang]

Does anyone have a database with all cities in the world? I'm hoping to use it so that people can select/search from a drop-down when selecting their location when filling out a form. I found one with all countries here.

Many thanks in advance!

[kuovonne]

I doubt you will find an Airtable base with all the cities in the world. While there are only a couple hundred countries in the world, there are far more cities. Depending on how you define a city, it could be several thousand to many times that number. 

[ScottWorld]

@miyazhang You can’t do this natively with Airtable, because Airtable bases have very strict record limits & value list limits. However, you can very easily do this with JotForm, which offers a drop-down menu of all the cities in the world. After your form is submitted in JotForm, you can use Make to transfer the submitted data into Airtable.