Hi Experts,
I want to add an Auto-complete feature on "City" field in CRM. So if user types "A" it should show all the cities in the world with that initial.
How should I accomplish that in CRM? Auto-complete part is doable but my question is how to get list of cities in the world?
*This post is locked for comments
Hi New Bee,
You can achieve this with JavaScript that runs OnChange of the "City" field. The JavaScript will need to call an API with a list of cities such as the World Cities API, and use the information to populate the "City" field. The World Cities API returns city, state and country in JSON format.
Hi,
You can't do this for CRM field directly but you can build a html web resource where you can try to connect to google api and then store selected city to internal CRM field.
check these references may it will help you:
stackoverflow.com/.../how-to-limit-google-autocomplete-results-to-city-and-country-only
Hi Ravi, Thanks for the response.
Yes I am looking for using google API and if there is any alternative to it for this.
We don'T want it to be hard coded or do not have all cities listed in CRM as entity.
Hi,
If you know about the auto complete feature, you may already know that the auto complete works on the source of teh list. You need to either have this list within your CRM as entities, or you need to have it hard coded or you need to get this list from some other external api.
It is up to you how you you decide on the data source for the cities. You can refer below links to get some more idea about this-
www.inogic.com/.../design-auto-complete-text-controls-in-dynamics-crm-2016
gis.stackexchange.com/.../free-api-or-database-for-continent-country-city-region-state
www.quora.com/How-can-I-get-cities-and-states-of-a-country-through-Google-API
Hope this helps.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (