Custom Function: Automatically populate the State, City and Country based on the ZIP code (only for US)

Custom Function: Automatically populate the State, City and Country based on the ZIP code (only for US)

Scenario: Automatically populate the State, City and Country based on the ZIP code (only for US)

When a contact, lead or an account is created, you have to fill in the address details manually.

You can save time by populating the value for State, City and Country based on the ZIP code you enter. You just need to enter the ZIP code and the rest will be populated automatically.

Right now, we have done this custom function only for United States ZIP code.

Please follow these steps:

  1. Log in to Zoho CRM with administrative privileges.
  2. Click Setup > Automation > Workflow > Create Rule.
  3. In the New Rule page, choose Leads module from the drop-down list and provide other rule details.
  4. Under Execute On, choose Create or Edit and then click Next.
  5. Specify the Rule Criteria as Zip Code is not Empty. Add additional criteria, if required.
    The     rule will triggered only when     a record meets the criteria mentioned here.
  6. In the Actions section, click on the Add button for Call Custom Functions.
  7. In the Configure Custom Function popup, click Write your own.
  8. Specify a name for the function.
  9. Build the Deluge Script based on the code given below.

Deluge Script:

  1.  

void workflowspace.Auto_State_City(string leadId,string zipcode)


  1. {


    pinresp=((getUrl("http://zipfeeder.us/zip?key=<zipfeederAPIKEY>&zips=" + input.zipcode))).toString();//Calling 


    zipfeeder api to get the information


    state = pinresp.executeXPath("/root/zips/state/text()");//Getting State info from the zipfeeder response


    city = pinresp.executeXPath("/root/zips/city/text()");//Getting city info from the zipfeeder response


    county = pinresp.executeXPath("/root/zips/county/text()");//Getting city info from the zipfeeder response


    upresp = zoho.crm.updateRecord("Leads",input.leadId,{ "State" : state, "City" : 


    city,"Country":"USA","County":county});//updating zohocrm lead

    }

Note: This custom function is for the Leads module and this can be used in any module where you want to automatically populate the State, City and Country information based on the Zip Code. You just need to modify the module name and field names in the custom function.


Please refer to the following link to know more about this feature:

https://www.zoho.com/crm/help/automation/custom-functions.html