By Foonaka on

Hopefully I am posting this in the proper forum...

I am attempting to set up a table for a community council that will hold their meeting minutes, agendas, and summaries. I am still new to Drupal and I am just trying to figure out the best way to tackle it.

I have been using WebFM (attaching the files to nodes), CCK, and Views, but I can only get it to show one document or all documents in a single cell. I just can't figure out how to separate the different documents into different cells and have them show up in the proper space.

I also need to note that all three docs in each row will be uploaded at different points in time. We generally post the agendas before the meetings and then post the minutes after the meeting.

Here is an image sample of what I'm trying to do. Hopefully this makes sense. The date would be the date of the meeting and the links would show the names of the documents.

www.home2stay.com/council-table.jpg

Does anyone have any suggestions on the best way to tackle this? Any help would be greatly appreciated!

⋅ Categories: Drupal 6.x

Comments

Foonaka’s picture

Foonaka commented

I forgot to mention that I am using Taxonomy to organize the docs.

Foonaka’s picture

Foonaka commented

I'm sorry to be a pest, but I am still really struggling with this. I was able to get them to group by date based on a CCK field (Date of Meeting), but that's not exactly what I want to do. Does anyone have any ideas at all?

Foonaka’s picture

Foonaka commented

I got it! In case anyone else is wondering, basically I ditched WebFM and attached the docs directly to nodes. I added a CCK field called "Meeting Date", then used Views to filter by Taxonomy, Node Type, Published nodes, and by the year of the meeting. I then used a node reference field to attach the Minutes to the Agendas (not vice versa). I had to leave the Minutes unpublished, because I couldn't figure out another way to hide the duplicates (still new to this). I then used the filters I needed based on CCK fields and Node types to get the results I wanted and laid it out in table format.

Anyway, it worked and I have a layout that resembles the image I attached to my original post. The only thing I can't figure out is how to get the header to show up in the agendas and minutes columns without attaching a title to each file, which is not what I want.

So that's how I did it. If anyone wants more detail or has any better ideas on how to accomplish this, please let me know.

yangke’s picture

yangke commented

What do you mean by the headers you can't get to show up?

Foonaka’s picture

Foonaka commented

Sorry, I meant the table heading for each column. The way I have it set up in Views is to rewrite the output of the Node Title as "[field_document_attachment_fid]", and then I excluded the Document Attachment field from display because I wanted to show the title of the Node in the table as opposed to the name of the file (i.e., 123009-council-agenda.pdf). In doing that, I now can't figure out how to get the column heading to show "Agenda".

As I said, I am new to this, so I'm sure there's a better way to do it, but it was the only way I could get it to work and have it laid out the way I want it.

Is there a way to get it to display the taxonomy term as the header?