CiviCRM Community Forums (archive)

Hi,

Currently, we keep track of our members' volunteer hours on paper, in a table (see attached photo). This is necessary because there is a date, description, and category with each entry, and there may be as many as 20 entries in a year.

Is it possible to do something like this in CiviCRM and Joomla using custom fields and a profile? To members in the front end of Joomla, it would look something like a table you might see in a word document.  I'm not very knowledgeable about databases, so I don't know how to describe it better than this. I see there would be a one to many relationship going on here. There would be 3 fields associated with each record (date, description, category), and as many as 20 records, all associated with 1 member. Then I would need to do this for every year.

A simple alternative would be for me to create a whole bunch of fields, like: Date1, Description1, Category1, Date2, Description2, Category2, .....Date20, Description20, Category20, but that doesn't really work, especially since I need to do it every year.

Hope this makes sense to someone.

Thanks for any ideas you may have,
Phil

Hi Ken,

Thank you so much for the help. That's exactly what I'm looking for. The only problem I'm having is that these fields don't seem to be available to add to a profile in Joomla. I need this functionality in the front end so that members can fill in their own info.

Is this because I have them set to allow multiple records?

Phil

Thank you. I think I'll wait until this is implemented as a core functionality.

Phil