CiviCRM Community Forums (archive)

Hello,

Bit of a biggie this one, but hopefully we might get something good from it.

We're investigating the possibility of producing a calendar in drupal views to display the availability of staff members in the database. What we'd like it to do is search through assigned activities and a series of custom contact fields to produce a calendar view of everyone who ISN'T busy on that day.

For example:

Admin searches for anyone who:

- Is contact type 'staff'
- Is qualified in X & Y (multiselect options from a custom contact field)
- Has no activities assigned for XXX date

At present, I'm seeing three obvious hurdles for this:

1) Custom fields for contacts don't seem to be available in drupal views of type "Civicrm Activities", only in views of type "CiviCRM Contacts". Is there any way of exposing custom contact fields to an activities view?

2) Assignee name / id doesn't seem to be a field option in activity type views - only contact name / id (which is the person who added the activity). While we *could* cludge it by asking admin staff always to put the assignee name in the 'Added By' field when creating / editing an activity, it would be much better to pull through the 'Assigned to' name for the view.

3) It's easy enough to produce a calendar (with exposed filters) to display the names of people or a certain contact type who have activities on any given date (notwithstanding the caveat in '2' above). But would it be possible to produce an opposite view: ie, rather than showing people who *have* activities on a given date, show people who *don't* have any and are therefore available?

It's early days for this but, if anyone has any ideas or pointers, I'd love to hear them.

Huge thanks,

R