Home Page

Chicago Woodturners Signup Sheet
DEMO! It's just an idea!

Signup Sheets on This Page:

Trent Bosch Demo May 6, 2006
Trent Bosch Hands-On May 8, 2006
CWT Meeting May May 9, 2006
Bert Marsh Demo June 4, 2006

Development Notes

Development note: only the buttons on the Trent Bosch Demo do anything!

Trent Bosch Demo
May 6, 2006

Ice  
Soda  
Coffee  
Donuts Chuck Young  
Cleanup
1
Cleanup
2
Cleanup
3

 

Trent Bosch Hands-On
May 8, 2006 - May 9, 2006
Signup Starts 3/1/2006
Signup Ends 5/8/2006
Only 5 slots available. If more than 5 sign up before 4/1/2006 then we'll have a drawing.

Student 1
  2
  3
  4
  5
  6
  7

 

CWT Meeting May 2006
May 9, 2006

Gallery Review  
Demonstrator Steve Sinner  
Cleanup
1
Dave Forney
Cleanup
2
Mariano Martinez
Cleanup
3
Chuck Young

 

Bert Marsh Demo
June 4, 2006

Ice  
Soda  
Coffee  
Donuts  
Cleanup
1
 
2
 
3

 


Development Notes
Idea: sign up for events & volunteer over the web! Click on a Sign Up button. It will ask your name and email address. If the signup is marked for confirmation, it will send email with a link on it. Open the email and click the link to confirm that you signed up (prevents other people from signing you up). Administrator can use a web browser to set up new event or print out a list of volunteers / enrollees. Email confirmation drag to calendar?

Programming Notes / File Layout

Events Table
key=Event ID

Event ID   system assigned ID
Event Name    
Event Description    
Event Start Date    
Event End Date   optional
Fields Req'd   This is the number of categories, or in a simple list the number of participants
Signup Start Date    
Signup End Date    
Event Delete Date    
Admin Notices Email   If present, admin gets email for every entry
Admin Confirms   If present, confirmation required by admin
Require email confirmation   If set, will send email to person signing up. They will click on a link to confirm
Type of Signup   Volunteer / Signup / Waiting List

Event Fields Table
key:event ID+field ID

Event ID Field ID field name 1 # positions Example 1: Ice Example 2: Person 1
Event ID Field ID field name 2 # positions Example 1: Soda Example 2: Person 2
Event ID Field ID field name 3 # positions Example 1: Coffee Example 2: Person 3
      Note:0=unlimited    
           
           
           

Event Details Table

key:Event ID+ Field ID+ Instance ID

Event ID Field ID Instance ID Person 1 name email address Entered Date Entered Time Entered IP Confirm ID Confirmed?
Event ID Field ID Instance ID Person 2 name email address Entered Date Entered Time Entered IP Confirm ID Confirmed?
IEvent ID Field ID Instance ID Person 3 name email address Entered Date Entered Time Entered IP Confirm ID Confirmed?
                   
                   
                   
                   

Control Table

Signup Sheet Display Page Title    
Signup Sheet Display Page Description    
Signup button name    
Logo name    
Entry Page Title    
Summary of signups at top? (useful when the page gets too long)    
Signup Sheet Start date: default 0 (today) -1 for yesterday, 2 for day after tomorrow    
Signup Sheet End date: added to todays date, default 90 (~3 months)    

Language Table
Paramatarize the entries on sheets and forms for language adjustment.