I'm trying to create a drupal site to track very specific attendance info for some student music groups I direct. I believe I can do this in drupal, but I'm having some difficulty getting my head around all the complications. So far I have content types for: ensemble member (content profile), rehearsal (ensemble, date & time), and attendance record (references both an ensemble member & a rehearsal and will include attendance info such as arrival & departure time). All this I can do (I think), but beyond that, I'd like to set up a table-type view that I can use to actually record the attendance info for a whole group rather than editing one node at a time. It seems the editview module can do this, but I'm just starting to experiment with it. Here's what I'd like my view to be like:

- It should have an exposed filter to select which rehearsal I'm going to take attendance for.
- Once the filter is set, all of the members of that ensemble should be listed in the view (each ensemble member is associated with one or more ensembles using content taxonomy).
- Next to each name should be fields for their attendance info (times, excuses, etc.)

So, is this at all possible? Can anyone give me any clues?

Anthony

Comments

anthonym’s picture

I've been fiddling with this a little more on my own and I'm realizing that I have some more questions/challenges to deal with in the conception of this thing. This is more or less the workflow I'd like to have:

- Create a user with profile for each ensemble member.
- Create a rehearsal node for each rehearsal.
- Then I'd like a view (I'm assuming views is the way to go with this.) that lists all the ensemble members that are in that ensemble which is rehearsing. (I guess this can be done with arguments, but I'm very unsure of how to do that.)

A big question is this: If I use my attendance record content type to contain all the information I need for each student's attendance, I'll need one record for each student at each rehearsal. Is there a way to have these automatically created, one for each student every time I create a new rehearsal record?