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

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

  • 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 Mar 18 '18 at 7:37
  • Added some screenshots for you; this will make all Contact Custom Data available – KarinG - Semper IT Mar 18 '18 at 15:23
  • Waouh ! Great ! But not really self-explanatory. Many thanks Karin – Jacques-Marie Moranne Mar 19 '18 at 15:04
  • So you got it working then? Awesome! – KarinG - Semper IT Mar 19 '18 at 18:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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