Zip code search tool that links to external pages

I am looking to build a zip code search tool that will match the inputted zip code and open an external link to match a zip code to a particular sales rep. I am hoping to create this with the ability to code it into my website. I am having an issue figuring out the data and workflow section of bubble to connect everything together and have it work.

I would like it to have this workflow:

  1. Enter zipcode
  2. Click arrow icon
  3. Searches zip code database to match zip code to link (sales rep)
  4. Opens an external link to the correct salesperson.

Thank you for any help provided!