Hi,
CRM by default have text fields for Zip, City, State in Account, Contact, Lead entities etc..you might have to create entities. If to auto pupulate the data on excel import the you have to develop a plugin register on Pre-Create Cperation
for Cretae Message that will retrieve the City, State etc fields via RetrieveMultiple webservice call from the Zip code entity and then can set in to the entity fields i.e. Account entity fields
Follow the steps:
1. Create the Zip Code Entity (Settings->Customizations->Customize the System->Entities->New) which can contain (Country, City, State fields, if you will create country, city, state new fields then new lookup fields (new custom entities for State,
City etc and then related with a Zip code entity) will not be used by Outlook and will not syncrhonize with Outlook contatcs)
2. Create Zip Code Entity 1:N relationhip (Settings->Customizations->Customize the System->Entities-> Zip Code->1:N Relationship, click on new button and select Account in drop down) with entity (i.e. Account) where you want
to select the Zip Code lookup
3. Place Zip Code lookup field on Account Entity Form (Settings->Customizations->Customize the System->Entities-> Account->Form->Main, Drag the new lookup field Zip Code on form, save form and then Publish entity)
4. On Zip Code lookup On Change event write JScript SOAP SDK or REST retrieve code (Can reffer the sample code:http://worldofdynamics.blogspot.com/2011/06/microsoft-dynamics-crm-2011-retrieve.html)
or (http://mileyja.blogspot.com/2011/03/crm-2011-retrievemultiple-calls-in.html) to retrieve fields Country, City, State fields from the Zip Code
entity and assign them to Account entity fields
5. Publish Entity Customizations
Jehanzeb Javeed
http://worldofdynamics.blogspot.com
Linked-In Profile |CodePlex
Profile
If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
