Skip to main content
Topics#Sales And MarketingJuliane Santos の質問
Juliane Santos が「#Sales And Marketing」で質問
2014年4月23日 19:22

how do I populate geo into lead records

Does anybody out there have a formula or ingenious (free) way to get GEO populated into the lead record? I want to sort leads by GEO but don't want to manually enter them into each lead record. I was hoping a formula could do it...

 

I was toying with case formulas or IF formulas but I'm thinking there's a better way..or at least i hope there is! 
4 件の回答
  1. Amitkumar Bangad (Crowdstrike Inc)
    2014年4月25日 17:44
    Hi Juliane, 

     

     

     

    there are multiple ways to handle this, depends on  your decision on flexibility/maintainence :

     

    1. Create a GEO formula field, return type text and mention the mapping in in a big CASE formula.

     

    https://help.salesforce.com/htviewhelpdoc?id=customize_functions_a_h.htm&siteLang=en_US#.CASE

     

    CASE(Country,

     

    "US", "Americas",

     

    "South America", "Americas",......

     

    "Global")

     

    (High Maintainence , 5000 charater limit of formula field expression, good to handle 70-80 countries mapping)

     

    2. Create a custom setting and mention mapping over there. Write an apex trigger to populate the GEO from custom setting to a Geo field on Lead. Fairly simple trigger. (Leass MAintanence,fairly simple trigger)

     

    thanks,

     

    Amit
回答を記入...
0/9000