Brian Dunning's FileMaker Custom Functions

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   Mark P
SIP Corporation
www.sipgrinder.com

Share on Facebook Share on Twitter

  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

  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   David, Tampa
Jan 19, 2010
You should definitely used URLencode for this function
 
Chuck   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   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   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   Mark P, Tampa
Feb 13, 2012
Function is updated as of 2.13.2012 as shown by Chuck
 
Macgyver   Macgyver, Los Angeles, CA
Jan 11, 2014
Doesn't seem to be working for me. Can someone outline the setup process?
 
Jack b   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   Jack b, Boca Raton, fl
Mar 3, 2014
found it
 
Jack b   Jack b, Boca Raton, fl
Mar 3, 2014
found it
 
Art C   Art C, Portland, OR
Dec 20, 2014
How do I get the result from the URL into my Zip Code field?
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.