Country Lookup Idea

[ality]

I have a field that requires a country input, however this needs to be mapped to an actual values (correct spelling etc). Does anyone have a good way to validate a answer as a country from a list? I understand that there would be quite a high error rate in people typing in thier own country

[DanielBeckett]

You could store a list of countries (like this one) inside Google Sheets and then when the user enters a country you can search the sheet for a match. If no match is found you could loop back to asking the question again.

For example, here’s my Google Sheet: (link)

I ask the user to let me know what country they’re from and then use their answer to search the sheet:

If no match is found I let the user know and ask if they want to see the list of supported countries:

Finally, the flow loops back to asking them to provide the country again.

Here’s an example flow (you’ll need to link up the Google Sheet manually):

Validate Country - Flow XO