CiviCRM

I needed to be able to add a new activity record to every contact in my search results.

Here's how I used a CiviCRM hook to add a function to the list of tasks you can perform on a set of search results.

When you create a custom fieldset in CiviCRM, a new table is created, but the table name and field names are not altogether obvious. Here's a function that finds them out. All you need to know is the name you gave the fieldset (and the names you gave the fields).

So you might have created a field set to keep a record of contacts' favourite music called "songs". You may have given fields "Artist", "Title"...

CiviCRM is a full featured database right out of the box, and has lots of ways to extend it. For example, you can create extra set of fields for certain types of contacts, and these can even have a one-to-many relationship. Here's how I ran a report on from this extended dataset.