Skip to main content
Best answer

Convert Address

  • December 11, 2019
  • 2 replies
  • 889 views

I have a WPform that has an address field, including one for US States. I'm sending the information on to Salesforce, The form has abbreviations for the states names, salesforce likes them spelled out. Is there a way in zapier to convert the the abbreviations to spelled out state names?


Best answer by AndrewJDavison

Hi @iclifford

It's a little cumbersome to setup, but you'll want to use a "Formatter->Utilities->Lookup Table"

Screen Shot 2019-12-12 at 13.08.37.png

As I've exampled above, you'll want to use the "State" field from the form as the "Lookup Key" then add a line for each state.

I hope that makes sense?



This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

AndrewJDavison
Forum|alt.badge.img+11
  • Zapier Solution Partner
  • Answer
  • December 12, 2019

Hi @iclifford

It's a little cumbersome to setup, but you'll want to use a "Formatter->Utilities->Lookup Table"

Screen Shot 2019-12-12 at 13.08.37.png

As I've exampled above, you'll want to use the "State" field from the form as the "Lookup Key" then add a line for each state.

I hope that makes sense?




  • Author
  • Beginner
  • December 12, 2019

That makes sense -- thank you!