Check Zip ( Address ; City ; State ; Zip )
Creates the URL for the USPS Check Zip Code Web Page
Average rating: 3.9 (41 votes) Log in to vote
|
Mark P SIP Corporation www.sipgrinder.com |
Sample input:
Check Zip ( APVE::Mailing Address ; APVE::Mailing City ; APVE::Mailing State ; APVE::Mailing Zip )
Sample output:
https://tools.usps.com/go/ZipLookupResultsAction!input.action?resultMode=0&address1=TF344BC
PO Box 96019&city=Charlotte&state=NC&zip5=28296-0019
PO Box 96019&city=Charlotte&state=NC&zip5=28296-0019
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This is used with the web viewer to automatically enter the selected address into the USPS check zip code page.
Comments
 |
David Jan 19, 2010 |
|
| You should definitely used URLencode for this function | ||
 |
Chuck, Crown Point, IN Feb 13, 2012 |
|
| Has the URL changed for this script, the USPS web site doesn't fill in the address fields automatically anymore. | ||
|
Chuck, Crown Point, IN Feb 13, 2012 |
|
| Answering my own question. Here's the new URL you should use: "https://tools.usps.com/go/ZipLookupResultsAction!input.action?resultMode=0&address1=" & Address & "&city=" & City & "&state=" & State & "&zip=" & Zip |
||
|
Chuck, Crown Point, IN Feb 13, 2012 |
|
| I don't know why the system added a space between "input.action" and "?" above. It should not be there. | ||
|
Mark P, Tampa Feb 13, 2012 |
|
| Function is updated as of 2.13.2012 as shown by Chuck | ||
|
Macgyver, Los Angeles, CA Jan 11, 2014 |
|
| Doesn't seem to be working for me. Can someone outline the setup process? | ||
|
Jack b, Boca Raton, fl Mar 3, 2014 |
|
| I am also having difficulties. Somewhere in the calling sequence parameters are needed to indicate the street address field and table from the database to be passed to the web site. (e.g. membertbl::street). | ||
|
Jack b, Boca Raton, fl Mar 3, 2014 |
|
| found it | ||
|
Jack b, Boca Raton, fl Mar 3, 2014 |
|
| found it | ||
|
Art C, Portland, OR Dec 20, 2014 |
|
| How do I get the result from the URL into my Zip Code field? | ||
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.