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.

  • Home
  • Get Help
  • How Do I
  • How can I change state misspellings in an address form to the correct US Post Office abbreviations?

What is the bast way to identify a multitude of misspellings in a form for state in an address and convert it to the standard 2 capital letters used by the US Post office

Hi @IULMAN 

AI via ChatGPT/OpenAI will be your most flexible option.

 

Action: Formatter > Text > Uppercase

Come on Mr. Obvious read the question there’s more to it than just capitalization. 

@IULMAN 

Try AI as suggested.

AI via ChatGPT/OpenAI will be your most flexible option.

@IULMAN 

Best would be to address the formatting by making the input list a standardized dropdown list on the form.

Yes that is the logical solution but unavailable in this instance. I understand that there is a way to access a list or sheet of data (the proper abbreviation) and have it used to replace a list of misspellings? However the syntax escapes me. That is what I seek here. 

@IULMAN 

Try prompting AI to reference the input value against the list of values and return the derived value.

@IULMAN

Try prompting AI to reference the input value against the list of values and return the derived value.

This is the right idea but I am a novice, can you specify the zap trigger and action (I think those are the terms). Any additional help would be greatly appreciated.

 

Thanks,  Peter

@IULMAN 

You would need to specify the app you are trying to use for the Zap trigger step.

 

List of available Zap triggers/actions:

ChatGPT: https://zapier.com/apps/chatgpt/integrations#triggers-and-actions

OpenAI: https://zapier.com/apps/openai/integrations#triggers-and-actions

 

It can take some testing and tweaking to get the AI prompt right for the desired output.

 

 

I guess I’m going to have to roll up my mental sleeves on this one. Thanks.

Terms & Conditions