So I have a set of data in a Google Docs spreadsheet of SF Bay Area Farmer’s Markets. Each market has data for the following columns: Day, County, Location, Hours, Months, Intersection, City, State, ZIP, Phone, URL. There are entries for over 100 markets.
What I want is a simple web page (ideally iPhone-friendly) that will have a few text input fields: ZIP, City, Day (or even a pull-down menu for each one). Then based on those inputs, the program would pull the five nearest farmer’s markets and list them (and ideally plot them on a Google Map).
Example:
Today is: Tuesday
I’m in: Oakland
My ZIP is: 94618
Click here to show me the markets!
I think this should be pretty easy. It doesn’t need to be fancy, just functional. Who can do this and/or show me how to do it myself?
