Answers.Body: <p>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. </p>
  
  <p>Here's how:</p>
  
  <ol>
  <li><p>Create a View: Show <strong>CiviCRM Participants</strong></p></li>
  <li><p>Relationships: add <strong>CiviCRM Contributions: Contact Record ID</strong> </p></li>
  </ol>
  
  <p><a href="https://i.sstatic.net/rU9mL.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/rU9mL.png" alt="enter image description here"></a></p>
  
  <ol start="3">
  <li>That will bring the <strong>entire CiviCRM Contact with custom fields</strong> to the party</li>
  </ol>
  
  <p><a href="https://i.sstatic.net/dfFhq.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/dfFhq.png" alt="enter image description here"></a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-18T07:37:57.247Z
Answers.Text: 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)
Answers.UserDisplayName: Jacques-Marie Moranne
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-18T15:23:41.723Z
Answers.Text: Added some screenshots for you; this will make all Contact Custom Data available
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-19T15:04:11.470Z
Answers.Text: Waouh ! Great ! But not really self-explanatory. Many thanks Karin
Answers.UserDisplayName: Jacques-Marie Moranne
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-19T18:22:31.647Z
Answers.Text: So you got it working then? Awesome!
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-17T18:22:20.760Z
Answers.LastActivityDate: 2018-03-18T15:12:52.027Z
Answers.LastEditDate: 2018-03-18T15:12:52.027Z
Answers.UserDisplayName: KarinG - Semper IT
Body: <p>I want to create an Event Participants View which displays both <strong>Participants</strong> Custom Data and <strong>Contacts</strong> Custom Data.</p>
  
  <p>But when I want to add new fields, the <strong>Contact</strong> Custom Data are not proposed.</p>
  
  <p>Isn't this feasible ?</p>
  
  <p>I am on Drupal 5.57 / Civi 4.7.27</p>
  
Tags: <custom-fields><drupal-views>
Title: How can I have both Participants Custom Data and Contacts Custom Data in a Drupal View
ThreadText: # How can I have both Participants Custom Data and Contacts Custom Data in a Drupal View
  
  (Asked by: username_0 on 2018-03-17)
  
  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
  
  **Tags:** custom-fields, drupal-views
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2018-03-17. Score: 2 | Accepted answer
  
  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](https://i.sstatic.net/rU9mL.png)](https://i.sstatic.net/rU9mL.png)
  
  3. That will bring the **entire CiviCRM Contact with custom fields** to the party
  
  [![enter image description here](https://i.sstatic.net/dfFhq.png)](https://i.sstatic.net/dfFhq.png)
  
  > **Comments:**
  > **username_0**: 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)  
  > **username_1**: Added some screenshots for you; this will make all Contact Custom Data available  
  > **username_0**: Waouh ! Great ! But not really self-explanatory. Many thanks Karin  
  > **username_1**: So you got it working then? Awesome!  
  
  ---
  
  