2 Replies Latest reply on May 2, 2013 10:50 PM by 13b6ddb5d75795faf166c553c40c14d1236c9244

    State Auto-Populate from Area Code

      We keep our forms pretty short and don't ask for address, but need state in order for lead owner to be assigned in SFDC.  Is there a not too difficult way of having state autopopulate by area code when an individual enters their phone number?
        • Re: State Auto-Populate from Area Code
          Rafael Santoni
          In its current state you will need to do at least some type of mapping of all possible values that you want for the different possibilities. I would probably use a data augmentation service to integrate with the forms using some form of Javascript API service. Unless you have access to all possible values that you may need to map. And even then there is considerable effort. Good luck!
          • Re: State Auto-Populate from Area Code
            Kelly,

            If you're looking for real-time updating (i.e. you want the data to pass through with the form submit), you'll need to do some javascript work, or you could use a service like ReachForce SmartForms (disclosure: We're a partner of theirs and sell their products).  You can see it in action on one of our pages: http://www.pedowitzgroup.com/solutions/revenue-marketing-cloud/marketo. When you select your company, the data is passed through into our Marketo instance.

            If you can wait until the lead enters the form, you could create a smart campaign that sifts through all of the possible area codes and assigns a lead to a state. ie:

            IF Area Code EQUALS 919, 910, 704, 252 -- Change Data Value "State" to "NC" (and do this for every area code).

            It would be very time-intensive, but should work once you set it up.