I'm building a form with Zoho Creator for users to register. Users might be from all around the world, so I want the form to offer different pulldown menues to chose from depanding on their input of the My Country field.

E.g. if a user chooses USA another pulldown field shows up to select a state - for UK a pulldown menu shows up to select a county etc. It all gets stored in the form data table.

I was able to achieve this functionality by the "On User Input" script for Country where I hide or show the respective fields for USA_states, UK_counties etc.

In the same form I also have a "Range" field for user to select range in Km or Miles (depanding on his country) - this is done the same way with "range_km" and "range_miles" fields.

The problem is, that the resulting view is a mess and difficult to work with, because its dificult to search users from given state or county because these are in different columns with half of them empty.

Please what would be better way to go about this?

I just want to be able to simply find a user that matches given criteria no matter if she is from US, UK, Ireland or Canada.

At the same time I want to keep the user friendliness for data input (state/county; miles/km, etc)

Thank you for a tip

-Peter