1

I want to create an Event Participants View which displays both Participants Custom Data and Contacts Custom Data.

But when I want to add new fields, the Contact Custom Data are not proposed.

Isn't this feasible ?

I am on Drupal 5.57 / Civi 4.7.27

Improve this question

1 Answer 1

Reset to default
2

You need to add the Relationship (click open the Advanced fieldset on the right side in your View) to bring the Contact data to the party.

Here's how:

  1. Create a View: Show CiviCRM Participants

  2. Relationships: add CiviCRM Contributions: Contact Record ID

enter image description here

  1. That will bring the entire CiviCRM Contact with custom fields to the party

enter image description here

Improve this answer
4
  • Thk you Karin, but can you be more explicit : when I want to add a relationship, there is no Contact Custom Data Table proposed. (And I don't need a relationship to have the usual Contact Data : they are already included in the Participant View)
    – Jacques-Marie Moranne
    Commented Mar 18, 2018 at 7:37
  • Added some screenshots for you; this will make all Contact Custom Data available
    – KarinG - Semper IT
    Commented Mar 18, 2018 at 15:23
  • Waouh ! Great ! But not really self-explanatory. Many thanks Karin
    – Jacques-Marie Moranne
    Commented Mar 19, 2018 at 15:04
  • So you got it working then? Awesome!
    – KarinG - Semper IT
    Commented Mar 19, 2018 at 18:22

Your Answer

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

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