Jason Silver

Wednesday, September 23rd, 2009

A Couple New Scripts

This weekend I designed a new web site for Dundas Women's Softball Association. In the process I wrote a couple of new scripts which I hope will be of use to other people for their sites.

The first script is a modification of the ESC database/shopping cart. You see, the great thing about this shopping cart is that it is so completely flexible and customizable-- it can be used with any column names, and the data actually comes from Google Docs. You simply create a spreadsheet in Google Docs, fill in the fields, and viola! A searchable database is created on your site.... editable anytime through Google Docs.

So I made their baseball game schedule a spreadsheet on Google Docs, and now ESC shows that schedule dynamically on their site. You can click on any team name to see all the dates and times that team is playing.

I also wrote a little short script which calculates the standings of the teams automatically based on how many wins each team has had.

The other script I wrote is really cool: it's a "Meeting-Minutes" application. It shows all the minutes from all meetings as a list by date down the right side. Clicking on a date will display those minutes in a browser... it's also instantly searchable, so you can quickly find the results of a decision from years ago.

At some point in the next day or two I'll put the Meeting-Minutes script up for sale on Intelliscript.net. I'll likely sell if for $10.00. If you want it, and don't see it there, shoot me an email and I'll hook you up.

~Jason