Zip code look up
I'm using FM Pro Advanced 13. I have a database of addresses with city but no zip code. How can find a way to look up the zip code and get it in it's own field? Thanks.
I created a sample database that retrieves the zip+4 and the mailing address from the USPS website.
Very nice Stacy!. Quick question, in the script UpdateAddress, the last step is grayed out and says 'unknown'. I'm still using FM ADV 12, is this a script step from a newer version?
Super cool custom function too...
Yea, this is great. Great job!
My sample was created using FM13, the update address box is in a popover button, so yes I'm sure that is the problem.
You could convert it to not use a popover button. It is designed to display the mailing address in the popover then click a button if you want it to update your database with the new address from the post office.
Interesting, I am scripting this to automate through a list and USPS.com seems to limit the inquires to about 5 seconds or 10 zips before requiring a break for 55 seconds. I'm thinking it only lets you do so many per minute. I just have it check if CorrectedZipCode is empty and restart the script over and over until it is filled.
I'm sure it is limited, even google maps limits their services to free users. I assume most user would verify a mailing address as they are keying the data in, which would limit slow the process.
Retrieving data ...