Suggestions for an Attendance Tracking application?

Hi Jerry,

This all looks good. My only suggested change would be at point 3, instead of using a text field I would use a multi value list field that gets options from the attendees section to store who attended a lecture in the lecture section. This way you will be able to easily manage the  records in CMS Builder. 

Let me know if you have any questions.

Thanks!

Greg

Hi Greg,

I'm sure that you're right, but I'm not sure exactly what you have in mind.

Could you elaborate a bit more?

Jerry Kornbluth

Hi Jerry

You could also reverse the methodology:  Enter the date of the event, then enter all attendees first & last names.  The resultant check against the database would list the returning attendees with a checkbox (filled in) against their names confirming the event.  New attendees would end up with a "create new user" checkbox and you could create one at a time.

Just a thought...

--

northernpenguin

Interesting idea.

Thanks.

I'll have to think on that

Jerry Kornbluth

Hi.

Well, I made a great deal of progress over the weekend.

I set up a multi record editor to hold records for each participant.

There’s a checkbox field for each lecture series to indicate that a participant as attended at least one session of a series (this could probably go away and I could test if the date fields for a lecture series was not empty)

Dates attended are entered into a text field reserved for each series, in the format mm-yy (lectures are only held once in any month)

There’s a multi record editor with lecture series titles and another for lists of dates.

The attendance report page (attached) pulls date search options for each lecture series from the dates editor and searches the appropriate “dates attended” field.

STILL TO GO... Ideas gratefully accepted.

1) Since the lecture series list is dynamic, how can I add fields to the participant editor dynamically when a lecture series title is added to the “Class Title” editor.

Once that’s set up, I think I’ll be able to populate the search selects dynamically.

THE SIGN IN PROCESS

2) How can I choose which “lecture series attended” text field to append the current year and month to, from the front (or back) end, so the code in the form doesn’t need to manually be changed.

3) How can I append data to the end of a text field.

Thanks for your help,

Jerry Kornbluth

Hi Jerry,

1) Since the lecture series list is dynamic, how can I add fields to the participant editor dynamically when a lecture series title is added to the “Class Title” editor.

Is the "lecture series list" a pulldown?  If so you can have a separate table of lecture titles and have it load from there (I think I'm probably not understanding correctly, though).

2) How can I choose which “lecture series attended” text field to append the current year and month to, from the front (or back) end, so the code in the form doesn’t need to manually be changed.

It's difficult to visualize your setup, but if you had tables for: lectures, attendees, and attendance_log you could add records to "attendance_log" with the attendee num and lecture num and represent it in the backend with related records fields.

3) How can I append data to the end of a text field.

In MySQL UPDATE statements you can say yourfield = yourfield + 'new value' or just load the old value and set it at the same time such as: yourfield = mysql_escapef($_REQUEST['old_value'] . $_REQUEST['new_value']);

Usually how I start with something like this is by creating different sections in the CMS backend and moving them around until I'm happy with the layout of the backend, so that if someone needed to they could just use that.  Then I create the front-end to submit data to the backend.  

Hope that helps!

Thanks Dave,

I've got a better idea how to proceed now. I think the easiest approach for the lecturer might be to have a separate sign in form for each lecture series and use current date to generate the date information.

Still a few details to work out, but the related records and possibly the show/hide dependent fields plugins and the  MySQL UPDATE statement will be very helpful.

I'll post my solution here for others to use and comment.

Jerry Kornbluth

Hi Jerry,

I've attached an updated version of salon-sign-in-mmm.php. This is the main update I've added to it:

    $loggedInUser = mysql_get('attendance_test', $_REQUEST['attendee_number']);
    $salon_name = @$loggedInUser['salon_name'];
    if(!$salon_name){
      $salon_name = 'MMM';
    }elseif($salon_name == 'AWC' ){
      $salon_name = 'AWC/MMM';
    }

Also on lines 37, 59 and 80 I've added the amended the MySQL statement to look like this:

salon_name       = '$salon_name',

This is code is untested, so you might have to make a few changes to get it working. 

So the mysql_get function (highlighted in blue) retrieves the users data if they have got past the error validation stage. Then the code sets the value of salon_name for the user to the salon_name variable.

Then an if statement checks if any value has already been set to $salon_name, if it hasn't it changes to MMM. If the current value is AWC, it sets a value of AWC/MMM to $salon_name. Finally if MMM or AWC/MMM has already been set to the value it does nothing.

The $salon_name variable is used to set the salon_name variable in the MySQL statement.

Let me know if you have any questions.

Thanks!

Greg