Country –> City form field query

Forums Designer Building applications Country –> City form field query

  • Post
    Frenck Smit

    Best Community,

    One of our applications we’ve built contains a CRM module.
    Within this module users can manage their customer relations, and therefore they need to insert their relations.
    Of course we also want to document the address of a specific relation, so they need to fill in the Country & Place (city/village).

    Since there are millions of cities in the world, the ‘Cities’ table will be huge.
    We already did some testing after importing a lot of places, and we find out that it even takes up to 15 seconds sometimes to load all cities when opening a drop-down form field.
    This is not weird of course, since you are loading thousands of records, but it is not very user-friendly.

    Therefore we were wondering if some of you have found a different (better) approach to this, so that users do not have to wait half a minute before they can select a city on a form.
    I suppose we are not the only one who will experience this issue, since address information is used in a lot of applications.

    Let me know if you have a more user-friendly solution for this 😀

    Best Regards,

Viewing 2 replies - 1 through 2 (of 2 total)
  • Replies
    Eddie Heijblom

    Hi Frenck,

    The solution for this issue is to filter the selection as much as possible. So first selecting a country will help, since you can only show cities within that country. In the US you’d still have a lot of cities left, so an additional filter on State would help there as well.

    Could that help solve this situation?

    Frenck Smit

    Hi Eddie,

    Thanks for your response!
    It seemed that through an import error we had some performance issues on our instance.

    Currently it is working at the speed of light again 😀

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Country –> City form field query’ is closed to new replies.

Get started for free and experience the power of the Triggre platform.

By signing up for your free account, you agree to receive e-mails from Triggre.

By using our site you agree to our use of cookies to deliver a better site experience.