Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I have lead forms coming from Facebook, pushing into Salesforce. 
The forms have Zip but no State. Salesforce will not input the zip code because it doesn’t have the state info.

How could I lookup the state by zip and create new ‘State’ field in my existing form before sending it to Salesforce.

FYI: I know nothing of programming, but Zapier logic makes sense to me.

Thanks,

Shannon D

Hi @ShannonD 

You either need to have a lookup table that has the Zip to State relationships.

Or you would need to use an API that can take a Zip and return a State. (https://app.zipcodebase.com/documentation)

Lookup Table resources:

 

Ok, I just read another reply you had on this subject previously.
Would that lookup table need to list each and every zip - 78681 = texas, and on and on?


Or could it list the range of zips per state similar to:
 

  if (zipcode >= 35000 && zipcode <= 36999) {

      st = 'AL';

      state = 'Alabama';

 

} else if (zipcode >= 85000 && zipcode <= 86999) {

      st = 'AZ';

      state = 'Arizona';

 

Thanks,
SD

@ShannonD 

If you want to use Code, then use the Code app: https://zapier.com/apps/code/help

Terms & Conditions