Cyclist Training Log Project

I’m curious to know if anyone would be interested in a small and *hopefully* simple project. From what I’ve read, it seems a pretty straight-forward customization using the forms module. However, I can also see that it is beyond my capabilities. I’m hoping that this task which seems intimidating to me might seem easy to an experienced programmer.

Here’s the gist of it…

We have a small group of cyclists using a simple table on Quickbase.com (online flatfile database service) to keep track of our training rides. Each member of the group has access to all records and can view and sort them in a few different ways and get some subtotals, nothing fancy… The most useful view is to see total mileage since the beginning of the calendar year, subtotaled by user. Views of prior years are also used for comparison.

There are about 10 fields:

Indoor/Outdoor: - pull down True/False type field
Date: - date
Hours: - number
Minutes: - number
Seconds: - number
- Hours, Min, Sec, three fields now, could be one but needs to be able to be used to calculate average speed
Miles: - number, 2 decimal places
Max Speed: - number, 1 decimal place
Avg Speed: - number, 2 decimal places (calculated by database)
Weight: - number, 1 decimal place
Picture: - link to photo (ideally uploaded at time of data entry, but this entire field could be separate or simply be eliminated if it complicates things)
URL: - url reference
Bike: - text
Comments: - text
Recent Purchases: - text

The only other nifty feature from Quickbase.com is that all users are notified by email when a record is added. It seems that the Drupal mailhandler, already in use at my site, should handle this.

If this is truly a simple application, the “wish list” I would have would expand functionality to allow multiple training groups to be setup in Drupal, each sharing data among themselves but not with other groups. Finally, it would be good to have a way for individuals to track their own training data and have it only accessible to themselves. Again, these items are far from critical and can be dropped if they complicate matters.

Given our modest fees to Quickbase, I could probably only justify $50 - $100 for such a project. If this is way out of whack, I’d be curious to know what the true cost of something like this would be. It’d be helpful as other ideas come up for my site, which hopefully will be expanding to a much wider audience next cycling season.

I'd appreciate any and all feedback. You can post a reply or reach me via email by looking up my contact info on this site.

Thanks,
Tom