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

Share on Facebook Share on Twitter

  Sample input:
Check Zip ( APVE::Mailing Address ; APVE::Mailing City ; APVE::Mailing State ; APVE::Mailing Zip )
  Sample output:!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.



David   David
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:

"!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 Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: