Answers.Body: <p>Nope.  That is not expected behavior.</p>
  
  <p>If you have two separate databases, one for Drupal and one for Civi, then you'll need to add the tables to the settings.php file.  Until you add them, Views will show the fields as available but will display an error that the table could not be found.</p>
  
  <p>Every time you add a new custom set of fields, you'll need to go to Admnister/System Settings/CMS Database Integration, copy the code there and paste it into your settings.php file.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-09T20:32:29.307Z
Answers.Text: The field I tested has 16 entries
Answers.UserDisplayName: pmoz
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-10T00:20:29.550Z
Answers.Text: I figured it out. It appears that when a multi-field is being shared with another fieldset ("Reuse an existing set") the labels don't show, values only. I created a new set of options with my 15 entries and now Views is displaying the labels.
Answers.UserDisplayName: Kristine
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-08T19:29:38.523Z
Answers.Text: You may also need to clear Drupal caches as sometimes the fields still don't show immediately I find. Also I have started spotting that a number of fields are being displayed in the Views field list twice, once with a comment about 'help not being available' (or some such) and another with the description. be sure to use the latter.
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-08T21:57:37.653Z
Answers.Text: Hmmm.  I haven't seen that.  Good info Pete.  I'll keep my eyes out for it.
Answers.UserDisplayName: pmoz
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-09T04:33:14.600Z
Answers.Text: Thank you -- it looks like Drupal and Civi are in the same database. I cleared the cache and the fields are showing now. However, for the multi-select field, the value is showing numbers (correct), but the label is also showing values (incorrect). The label should be showing the label of the field. Any thoughts?
Answers.UserDisplayName: Kristine
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-09T11:31:58.030Z
Answers.Text: I tested a multi-select field by creating a new view, selecting a multi-select field and it listed the labels separated by a comma.  Check how the options are defined in the custom field set.  Label (human readable value) should be in the label field while value and order should be a number.  So for my label, I had Diabetes/Sugar in the label field, 1 for both value and order.
Answers.UserDisplayName: pmoz
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-09T11:32:54.300Z
Answers.Text: Also Pete I did notice the dual listing with the help not available description.
Answers.UserDisplayName: pmoz
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-09T18:25:07.590Z
Answers.Text: I think my issue could be a bug. The labels are showing for one field but not the other. The multi-select field I'm trying to display the labels for have 15 options. Perhaps this is causing the problem. I will file a bug once I can confirm.
Answers.UserDisplayName: Kristine
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-08T11:34:55.153Z
Answers.LastActivityDate: 2015-11-08T11:34:55.153Z
Answers.UserDisplayName: pmoz
Body: <p>I'm on Drupal 7 and CiviCRM 4.6.10. In Views, I am trying to show all the activities and their custom fields (multiple choice options). However, I'm not able to get any results, the custom field was added but the field is blank. Is this an expected behavior?</p>
  
Tags: <custom-fields><drupal-views>
Title: Display Custom Fields in Activities in Views
ThreadText: # Display Custom Fields in Activities in Views
  
  (Asked by: username_0 on 2015-11-08)
  
  I'm on Drupal 7 and CiviCRM 4.6.10. In Views, I am trying to show all the activities and their custom fields (multiple choice options). However, I'm not able to get any results, the custom field was added but the field is blank. Is this an expected behavior?
  
  **Tags:** custom-fields, drupal-views
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-11-08. Score: 2 | Accepted answer
  
  Nope. That is not expected behavior.
  
  If you have two separate databases, one for Drupal and one for Civi, then you'll need to add the tables to the settings.php file. Until you add them, Views will show the fields as available but will display an error that the table could not be found.
  
  Every time you add a new custom set of fields, you'll need to go to Admnister/System Settings/CMS Database Integration, copy the code there and paste it into your settings.php file.
  
  > **Comments:**
  > **username_2**: You may also need to clear Drupal caches as sometimes the fields still don't show immediately I find. Also I have started spotting that a number of fields are being displayed in the Views field list twice, once with a comment about 'help not being available' (or some such) and another with the description. be sure to use the latter.  
  > **username_1**: Hmmm.  I haven't seen that.  Good info Pete.  I'll keep my eyes out for it.  
  > **username_0**: Thank you -- it looks like Drupal and Civi are in the same database. I cleared the cache and the fields are showing now. However, for the multi-select field, the value is showing numbers (correct), but the label is also showing values (incorrect). The label should be showing the label of the field. Any thoughts?  
  > **username_1**: I tested a multi-select field by creating a new view, selecting a multi-select field and it listed the labels separated by a comma.  Check how the options are defined in the custom field set.  Label (human readable value) should be in the label field while value and order should be a number.  So for my label, I had Diabetes/Sugar in the label field, 1 for both value and order.  
  > **username_1**: Also Pete I did notice the dual listing with the help not available description.  
  > **username_0**: I think my issue could be a bug. The labels are showing for one field but not the other. The multi-select field I'm trying to display the labels for have 15 options. Perhaps this is causing the problem. I will file a bug once I can confirm.  
  > **username_1**: The field I tested has 16 entries  
  > **username_0**: I figured it out. It appears that when a multi-field is being shared with another fieldset ("Reuse an existing set") the labels don't show, values only. I created a new set of options with my 15 entries and now Views is displaying the labels.  
  
  ---
  
  