Someone knows how to do a DB lookup on a web form

Congratulations go to today for web form usability. I’ve been filling out a lot of forms lately, and the ones that annoy me are those that seek city, state, and zip. Maybe they haven’t learned that zip codes are highly correlated with specific locations, like the towns we live and work in. For two weeks (longer!) I’ve been wondering why no one has just implemented a quick lookup of city and state against the zip code table (or, less desirable, the zip code lookup against the address table — but I don’t know if the USPS provides an API for that).

Today, though, Sittercity made me smile after I watched the magic happen: I put in my zip code and — Voila! — it automagically figured out my town and state. Good for them!

Okay, coders, why would you NOT do this? Error correction? That would be believable if I’d ever received an error correction warning: I assume my typos are not a null set.

(And speaking of error correction: if you’re going to require some password rules, how about telling the user first, maybe right next to the field? Not everyone will think that your job application page requires the same high security that you do.)

Leave a Comment