I’m new to Softr and am creating a form with about 10 questions - one is to select a country from a drop down. What is the best way to do this without manually putting in every country that exists? Is there a shortcut? Also, for people who pick the United States, we would like there to be a sub drop down with all the states. Thoughts?
Hi @nyckara - I’m not sure if there is a better way, but I’ve been creating tables for Country, Province/State, and City or Region, and linking them together with related fields. I’ve been manually populating the tables. I don’t need every city or state so inputing the data doesn’t take too long. One thing you could do is using something like Claude or OpenAI to generate a list of countries and the related states/Provinces you want and import them into the tables. I wish there was a better way, but I’m not aware of one.
1 Like
Yes if this form is connected to a database you have 2 great options to generate this dropdown field:
- adding a “select” field in your database table, with 1 value per country. To avoid writing them all, you can ask the AI co-builder to add all countries as options for this field.
- storing all options in another table, 1 record per country
That way, when you connect your form to this field (select or related record), the options will load automatically.
And if for the US specifically you want to show a follow up question, you can use the “conditional logic” feature of the form block which allows to show more questions based on previous input.
Hope this helps!