Contents
How to autofill City and state with ziptastic?
Autofill City & State from Zip Code with Ziptastic. Most address fields on web forms ask for city, state, and zip code (or city and post code, outside of the US). But as us nerds often lament, city and state are redundant with zip code. Or at least they can be inferred from a correctly entered zip code.
How to automatically prefill City and state in Excel?
Open it with Excel and format it as a Table. Then use PowerQuery to separate the table into 3 tables of no more than 15000 rows each. Save each table with a different name in the same Excel file. I made mine Table1, Table2, and Table3.
How to make an autocomplete address field in Google Maps?
Google maps API v3 now provides address autocompletion. be careful using this as entry for a shipping address. for instance try entering ‘11960 iowa avenue #10, los angeles ca’. This address requires an apartment, but their API doesn’t know that and in fact won’t even let you go to that address.
How to get city and state from ZIP code?
Should the final value after a keystroke be a valid zipcode, we’ll attempt to get the city and state through Ziptastic and reveal the other fields. The is_int function is just some extra protection that the number is an integer (like all zip codes) in case the current browser doesn’t support the necessary HTML5.
How to parse ZIP code from a string?
It’s not code, because it’s pretty academic to write it, there’s no weirdness, just lots of string handling. Work backward. Start from the zip code, which will be near the end, and in one of two known formats: XXXXX or XXXXX-XXXX. If this doesn’t appear, you can assume you’re in the city, state portion, below.
Are there any paid plans for ziptastic API?
Enter Ziptastic, API for just that. Update April 2017: Ziptastic has paid plans now. From their FAQ, they say they still have a free version of the Version 2 API which is limited to 100 requests every 24 hours. Our demo will use that!