Hey Jesse, 

Since I responded originally, we've launched our node-based app (more specifically Meteor.js), and have been using it this season with few problems. Now that Meteor 1.2 is out, I'm going to be rewriting it to use React.js, and add a few additional features.

Providing ongoing support always needs to be considered, so I'm thinking of following Freehub's model with the next version and providing a hosted version of the app. It would be much better if there were more than 1 dev on the project, so if anyone has an interest in Meteor, please get in touch!  Depending on 1 random internet guy to keep your shop system running seems like a bad idea...

I can probably set up a demo if folks are interested in playing with the current version.

Current Features

Records
-Visitor records including name, waiver acceptance, and equity credit.
- Timelogs (sign-in / sign-out) which can be volunteering (generates an equity credit transaction), stand time (generates a cash or equity debit transaction), or other activities that don't generate transactions
- Transactions (either equity or cash). Cash transactions just create a notification so the cashier knows how much to charge in our Square (technically, there is a way to hand it off straight to Square, but we want to keep Square's reporting for now). Equity transactions add or subtract from the visitor's balance.

Login / Logout Kiosk
A screen that visitors use to sign in and out, and say what they're doing in the shop. Also replaces our paper registration/waiver.

Shop Dashboard
For the front desk worker. Shows who is volunteering, who is on stand time, etc. Also shows today's recent sign-outs. Provides access to create equity transactions (e.g. purchasing parts on equity),  notices about cash transactions to run, as well as access to browse all people, timelogs, or transactions.


New Features (for the next version)

Bikes
For bikes in our workflow. This will help us track which bikes aren't selling or getting fixed, and let customers browse bikes without needing to make it to our limited open shop hours. It will also give us some nice metrics on how well we're processing bikes.

Shifts
Schedule shifts, and link all timelogs to the shift in which they occur. This will let us set which activities are permitted depending on the kind of shift (e.g. self-signin volunteering only on volunteer night; free stand-time on women's night, etc). This will automatically generate a shift report that we put together manually right now (volunteers, attendance, etc).

Inventory
Put our parts prices into the system to make adding up a equity purchase easier, as well as give us a full picture of what parts are in highest demand (right now we only know which parts are purchased with $ through Square).

Nice-to-haves
- Better reporting, for things like volunteer retention and recruitment. I want to get a notice when someone volunteers for the first time, or hits a certain milestone of volunteering. 
- Purchase requests: stuff we need to buy, either for a specific bike, or just general consumables.
- Print-outs for bikes (holds, purchase waivers, evaluations, etc).




On Mon, Sep 21, 2015 at 10:09 PM, Jesse Cooper <jessecooper0@gmail.com> wrote:
Hey Folks!

  It's been a couple of years since I first asked about a database / software for sign ins and stuff. 

 Has there been any progress on this front for any shops out there yet?
 We are interested in Freehub but we need for people to be able to sign out to accurately track hours, something which Freehub doesn't do. 

 Can anyone give us (our community bikes) leads on applications that can allow sign ins / outs, and take info like name, email, whether or not they want to be emailed, dates, exporting data sheets, distinguish between staff / volunteer / member or other categories we deem we need, etc? 

 Or is anyone able to make a "Freehub" that has in addition to everything a sign out option?

 help?

 Jesse

  

On Thu, Nov 7, 2013 at 11:09 AM, Jesse Cooper <jessecooper0@gmail.com> wrote:

 Hey Folks!

So at Our Community Bikes in Vancouver, we're thinking it's time to set up a proper sign in / sign out system, combined with a membership and volunteer database.

 Ideally we would like to know what software is out there that can track people coming in and using our space, a simple laptop or desktop kiosk where folks can type in info, and it would enter our database.

 Also to serve as a database that members can register into, and again wherein volunteers can sign up, and log their hours, and tasks accomplished.

 sooo.. any ideas?

 Jesse Cooper


____________________________________

The ThinkTank mailing List
<a href="http://lists.bikecollectives.org/options.cgi/thethinktank-bikecollectives.org">Unsubscribe from this list</a>