CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Custom Fields Feasibility Question
Pages: [1]

Author Topic: Custom Fields Feasibility Question  (Read 1111 times)

nigelt

  • Guest
Custom Fields Feasibility Question
July 24, 2009, 07:53:28 pm
Hi everybody,

I'm new to CiviCRM and this board so please be patient...

Anyways, I've recently setup a local CiviCRM testing environment to see if I can use it in conjunction with our drupal install to manage our volunteer organization. Let me tell you a little about what I'd like to get out of CiviCRM:

We hold a number of volunteer events and currently use a drupal event module to allow registered users to signup to volunteer. This system has worked well enough for us in the past. However, we also keep track of member participation by assigning points to volunteers for participating in various events. This system is currently maintained by hand but I would like to use CiviCRM and its custom fields to manage this. More specifically, what I would like is for the event coordinator to be able to (1) assign a point value to an event and (2) automatically assign the point value to the participants whose status has been changed to confirmed attendance. Furthermore, the points are cumulative during a year long period so if a volunteer participates in two events I would like the point values from those two events added together and displayed on the users' profile page (I suppose I'll also need a way to reset points every year too). It would be nice if I could breakdown the total by event but this isn't as important as doing what I previously discussed. Another thing I might want to do in the future is have the ability to archive points for display on users' profiles.

Getting to my question... Is this feasible with CiviCRM and can anyone provide some tips on how to get started? Adding a custom field for points for events seems easy enough, but I'm not sure where to start with a custom field to display an individuals accumulated points in their profile.

Thanks very much for any help you can give me

Edit: I should probably add what versions of everything I'm running:

CiviCRM: 2.2.7
CMS: Drupal
MySQL: 5.0.41
PHP: 5.2.6

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Custom Fields Feasibility Question
July 24, 2009, 11:06:19 pm

You should be able to do this with a combination of custom fields, hooks and custom search:

1. Use a custom field on participant to store the points per confirmed event attendance

2. Use a civicrm_post hook on the participant object to update the custom field for the participant when attendance is confirmed (or changed)

3. Use a custom search to display the current points for a contact. You can put the year logic out here. You can also cache this on a custom field in contact and cache that value there

You'll need a fair amount of expertise with php/mysql/drupal to do the above.

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Custom Fields Feasibility Question

This forum was archived on 2017-11-26.