1

I have created a Drupal view which is used to show any emails sent through CiviCRM to the currently logged in contact. To list the emails, the view shows activities for that contact where the activity type = 'email'. I am able to show the title, subject, details and date and the view works fine. However, everytime I try to add in the Activity Source Contact field, suddenly the view has no results. I am assuming that the Activity Source Contact field is the 'Added By' field in CiviCRM for the activity (which is the 'From' field for the email)? If it is, I can't understand why suddenly the view has no results when I add the field.

The other strange thing is, in the Activity Source contact field settings in the view, there is a numeral formatter, which is strange for a text field. See the attached image.

Can anyone suggest how I can display the Activity "Added by" field in the Drupal view?

enter image description here

Improve this question

1 Answer 1

Reset to default
1

Look at using the 'relationships' feature in drupal views (on right under Advanced) which should allow to add the Activity Contact, specify that you want to filter it to 'Source' and then add a Display Name field and use that Relationship

Improve this answer
1
  • Excellent - glad you could follow my shorthand explanation - if you think it could be improved by all means offer a clearer step by step instruction and I can update the Answer to make it more useful for others
    – petednz - fuzion ♦
    Mar 22, 2018 at 18:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.