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 »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Drupal view to show staff availability
Pages: [1]

Author Topic: Drupal view to show staff availability  (Read 616 times)

rjb

  • I post occasionally
  • **
  • Posts: 63
  • Karma: 2
  • CiviCRM version: 3.3.5
  • CMS version: Drupal 6
  • MySQL version: 5.1.44
  • PHP version: 5.3.1
Drupal view to show staff availability
January 26, 2011, 04:50:26 am
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

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Drupal view to show staff availability

This forum was archived on 2017-11-26.