Does Hypha have an independent country list not included with Address

Is it possible to have a populated country list drop down as a field in application forms?

1 Like

My recommendation is to use the “Category Questions” for this is.

You create as many you need in Wagtail admin “Apply → Category Questions”.

Then add a “Category” field from the “Custom” section on application forms and set the “Category Questions” it should use.

I have seen it used to add list of Countries, Regions, Focus areas etc.

Thank you for the direction. Now to get to typing all 200+ countries :smiley:

INSERT INTO "public"."categories_option" ("sort_order", "value", "category_id") VALUES
(NULL, 'Afghanistan', 1),
(NULL, 'Aland Islands', 1),
(NULL, 'Albania', 1),
(NULL, 'Algeria', 1),
(NULL, 'American Samoa', 1),
(NULL, 'Andorra', 1),
(NULL, 'Angola', 1),
(NULL, 'Anguilla', 1),
(NULL, 'Antarctica', 1),
(NULL, 'Antigua and Barbuda', 1),
(NULL, 'Argentina', 1),
(NULL, 'Armenia', 1),
(NULL, 'Aruba', 1),
(NULL, 'Australia', 1),
(NULL, 'Austria', 1),
(NULL, 'Azerbaijan', 1),
(NULL, 'Bahamas', 1),
(NULL, 'Bahrain', 1),
(NULL, 'Bangladesh', 1),
(NULL, 'Barbados', 1),
(NULL, 'Belarus', 1),
(NULL, 'Belgium', 1),
(NULL, 'Belize', 1),
(NULL, 'Benin', 1),
(NULL, 'Bermuda', 1),
(NULL, 'Bhutan', 1),
(NULL, 'Bolivia', 1),
(NULL, 'Bosnia and Herzegovina', 1),
(NULL, 'Botswana', 1),
(NULL, 'Bouvet Island', 1),
(NULL, 'Brazil', 1),
(NULL, 'British Indian Ocean Territory', 1),
(NULL, 'British Virgin Islands', 1),
(NULL, 'Brunei', 1),
(NULL, 'Bulgaria', 1),
(NULL, 'Burkina Faso', 1),
(NULL, 'Burundi', 1),
(NULL, 'Cambodia', 1),
(NULL, 'Cameroon', 1),
(NULL, 'Canada', 1),
(NULL, 'Cape Verde', 1),
(NULL, 'Cayman Islands', 1),
(NULL, 'Central African Republic', 1),
(NULL, 'Chad', 1),
(NULL, 'Chile', 1),
(NULL, 'China', 1),
(NULL, 'Christmas Island', 1),
(NULL, 'Cocos (Keeling) Islands', 1),
(NULL, 'Colombia', 1),
(NULL, 'Comoros', 1),
(NULL, 'Congo (Brazzaville)', 1),
(NULL, 'Congo (Kinshasa)', 1),
(NULL, 'Cook Islands', 1),
(NULL, 'Costa Rica', 1),
(NULL, 'Croatia', 1),
(NULL, 'Cuba', 1),
(NULL, 'Curaçao', 1),
(NULL, 'Cyprus', 1),
(NULL, 'Czech Republic', 1),
(NULL, 'Denmark', 1),
(NULL, 'Djibouti', 1),
(NULL, 'Dominica', 1),
(NULL, 'Dominican Republic', 1),
(NULL, 'Ecuador', 1),
(NULL, 'Egypt', 1),
(NULL, 'El Salvador', 1),
(NULL, 'Equatorial Guinea', 1),
(NULL, 'Eritrea', 1),
(NULL, 'Estonia', 1),
(NULL, 'Ethiopia', 1),
(NULL, 'Falkland Islands', 1),
(NULL, 'Faroe Islands', 1),
(NULL, 'Fiji', 1),
(NULL, 'Finland', 1),
(NULL, 'France', 1),
(NULL, 'French Guiana', 1),
(NULL, 'French Polynesia', 1),
(NULL, 'French Southern Territories', 1),
(NULL, 'Gabon', 1),
(NULL, 'Gambia', 1),
(NULL, 'Georgia', 1),
(NULL, 'Germany', 1),
(NULL, 'Ghana', 1),
(NULL, 'Gibraltar', 1),
(NULL, 'Greece', 1),
(NULL, 'Greenland', 1),
(NULL, 'Grenada', 1),
(NULL, 'Guadeloupe', 1),
(NULL, 'Guam', 1),
(NULL, 'Guatemala', 1),
(NULL, 'Guernsey', 1),
(NULL, 'Guinea', 1),
(NULL, 'Guinea-Bissau', 1),
(NULL, 'Guyana', 1),
(NULL, 'Haiti', 1),
(NULL, 'Heard Island and McDonald Islands', 1),
(NULL, 'Honduras', 1),
(NULL, 'Hungary', 1),
(NULL, 'Iceland', 1),
(NULL, 'India', 1),
(NULL, 'Indonesia', 1),
(NULL, 'Iran', 1),
(NULL, 'Iraq', 1),
(NULL, 'Ireland', 1),
(NULL, 'Isle of Man', 1),
(NULL, 'Israel', 1),
(NULL, 'Italy', 1),
(NULL, 'Ivory Coast', 1),
(NULL, 'Jamaica', 1),
(NULL, 'Japan', 1),
(NULL, 'Jersey', 1),
(NULL, 'Jordan', 1),
(NULL, 'Kazakhstan', 1),
(NULL, 'Kenya', 1),
(NULL, 'Kiribati', 1),
(NULL, 'Kosovo', 1),
(NULL, 'Kuwait', 1),
(NULL, 'Kyrgyzstan', 1),
(NULL, 'Laos', 1),
(NULL, 'Latvia', 1),
(NULL, 'Lebanon', 1),
(NULL, 'Lesotho', 1),
(NULL, 'Liberia', 1),
(NULL, 'Libya', 1),
(NULL, 'Liechtenstein', 1),
(NULL, 'Lithuania', 1),
(NULL, 'Luxembourg', 1),
(NULL, 'Macedonia', 1),
(NULL, 'Madagascar', 1),
(NULL, 'Malawi', 1),
(NULL, 'Malaysia', 1),
(NULL, 'Maldives', 1),
(NULL, 'Mali', 1),
(NULL, 'Malta', 1),
(NULL, 'Marshall Islands', 1),
(NULL, 'Martinique', 1),
(NULL, 'Mauritania', 1),
(NULL, 'Mauritius', 1),
(NULL, 'Mayotte', 1),
(NULL, 'Mexico', 1),
(NULL, 'Micronesia', 1),
(NULL, 'Moldova', 1),
(NULL, 'Monaco', 1),
(NULL, 'Mongolia', 1),
(NULL, 'Montenegro', 1),
(NULL, 'Montserrat', 1),
(NULL, 'Morocco', 1),
(NULL, 'Mozambique', 1),
(NULL, 'Myanmar', 1),
(NULL, 'Namibia', 1),
(NULL, 'Nauru', 1),
(NULL, 'Nepal', 1),
(NULL, 'Netherlands', 1),
(NULL, 'Netherlands Antilles', 1),
(NULL, 'New Caledonia', 1),
(NULL, 'New Zealand', 1),
(NULL, 'Nicaragua', 1),
(NULL, 'Niger', 1),
(NULL, 'Nigeria', 1),
(NULL, 'Niue', 1),
(NULL, 'Norfolk Island', 1),
(NULL, 'North Korea', 1),
(NULL, 'Northern Mariana Islands', 1),
(NULL, 'Norway', 1),
(NULL, 'Oman', 1),
(NULL, 'Pakistan', 1),
(NULL, 'Palau', 1),
(NULL, 'Palestinian Territory', 1),
(NULL, 'Panama', 1),
(NULL, 'Papua New Guinea', 1),
(NULL, 'Paraguay', 1),
(NULL, 'Peru', 1),
(NULL, 'Philippines', 1),
(NULL, 'Pitcairn', 1),
(NULL, 'Poland', 1),
(NULL, 'Portugal', 1),
(NULL, 'Puerto Rico', 1),
(NULL, 'Qatar', 1),
(NULL, 'Reunion', 1),
(NULL, 'Romania', 1),
(NULL, 'Russia', 1),
(NULL, 'Rwanda', 1),
(NULL, 'Saint Barthélemy', 1),
(NULL, 'Saint Helena', 1),
(NULL, 'Saint Kitts and Nevis', 1),
(NULL, 'Saint Lucia', 1),
(NULL, 'Saint Martin (French part)', 1),
(NULL, 'Saint Pierre and Miquelon', 1),
(NULL, 'Saint Vincent and the Grenadines', 1),
(NULL, 'Samoa', 1),
(NULL, 'San Marino', 1),
(NULL, 'Sao Tome and Principe', 1),
(NULL, 'Saudi Arabia', 1),
(NULL, 'Senegal', 1),
(NULL, 'Serbia', 1),
(NULL, 'Seychelles', 1),
(NULL, 'Sierra Leone', 1),
(NULL, 'Singapore', 1),
(NULL, 'Slovakia', 1),
(NULL, 'Slovenia', 1),
(NULL, 'Solomon Islands', 1),
(NULL, 'Somalia', 1),
(NULL, 'South Africa', 1),
(NULL, 'South Georgia and the South Sandwich Islands', 1),
(NULL, 'South Korea', 1),
(NULL, 'South Sudan', 1),
(NULL, 'Spain', 1),
(NULL, 'Sri Lanka', 1),
(NULL, 'Sudan', 1),
(NULL, 'Suriname', 1),
(NULL, 'Svalbard and Jan Mayen', 1),
(NULL, 'Swaziland', 1),
(NULL, 'Sweden', 1),
(NULL, 'Switzerland', 1),
(NULL, 'Syria', 1),
(NULL, 'Taiwan', 1),
(NULL, 'Tajikistan', 1),
(NULL, 'Tanzania', 1),
(NULL, 'Thailand', 1),
(NULL, 'Timor-Leste', 1),
(NULL, 'Togo', 1),
(NULL, 'Tokelau', 1),
(NULL, 'Tonga', 1),
(NULL, 'Trinidad and Tobago', 1),
(NULL, 'Tunisia', 1),
(NULL, 'Turkey', 1),
(NULL, 'Turkmenistan', 1),
(NULL, 'Turks and Caicos Islands', 1),
(NULL, 'Tuvalu', 1),
(NULL, 'U.S. Virgin Islands', 1),
(NULL, 'Uganda', 1),
(NULL, 'Ukraine', 1),
(NULL, 'United Arab Emirates', 1),
(NULL, 'United Kingdom', 1),
(NULL, 'United States', 1),
(NULL, 'United States Minor Outlying Islands', 1),
(NULL, 'Uruguay', 1),
(NULL, 'Uzbekistan', 1),
(NULL, 'Vanuatu', 1),
(NULL, 'Vatican', 1),
(NULL, 'Venezuela', 1),
(NULL, 'Vietnam', 1),
(NULL, 'Wallis and Futuna', 1),
(NULL, 'Western Sahara', 1),
(NULL, 'Yemen', 1),
(NULL, 'Zambia', 1),
(NULL, 'Zimbabwe', 1);

If you are comfortable with SQL this should save you some time.

Thank you so much! I’m very comfortable with SQL. You guys have done an amazing job with this piece of software!

1 Like

I’m glad you find it useful!

Do not hesitate to ask question here or create issues on gitHub.

Thank you! We are moving into a new granting phase and I stumbled upon this amazing tool so trying to integrate it into the existing workflow and seeing whether it can eventually replace it

We’re excited to learn that you’re using Hypha! Please do not hesitate to reach out to us here or on GitHub if you have any questions about the platform. We love to get feedback from new adopters.

The populated geographic location list drop down field on application forms could render multiple ways depending on how you create the form. Here are examples:

Example 1:

Screen-recording-2022-05-24-12.02.48-PM

Example 2:

The above examples are category questions added to an application form. Both are set to “Multi select”.

They look different since one has less than 32 options and the other 32 or more. This is done to get the best user experience.

Rendering a country field with some 200 options as checkboxes would take a lot of space and be hard to navigate.

With only a few option (less than 32 in case of Hypha) checkboxes give the user a quick and easy experience.

If 32 is optimal I do not know but it is somewhere around there.