Answers.Body: <p>That error appears when Drupal can't recognise your CiviCRM SQL Tables.</p>
  
  <p>You can find guidance on how to update your settings.php file here: <a href="https://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration" rel="nofollow noreferrer">https://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-06-07T20:21:23.347Z
Answers.Text: Kristine seems to be saying the custom field shows fine in a non-calendar based view, which suggests settings.php wouldn't be the issue.
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-06-07T09:59:38.113Z
Answers.LastActivityDate: 2017-06-07T09:59:38.113Z
Answers.UserDisplayName: Heather O.
Body: <p>Is there a way to display custom fields in a Views Calendar (Drupal 7, CiviCRM 4.7.18)? I have custom fields in a table assigned to a certain contact (with the option to add more rows). One of these fields, is a date/time field. I'm trying to display this field in Views Calendar. I tried going to "add view from template" and then choosing the option: "A calendar view of the 'custom_45' field in the 'civicrm_contact' base table." However, I'm getting the error:</p>
  
  <pre><code>SQLSTATE[42S22]: Column not found: 1054 Unknown column 'civicrm_contact.custom_45' in 'field list'
  </code></pre>
  
  <p>Weird because I am able to list all these fields in a table fine.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-05-04T18:42:30.637Z
Comments.Text: Hi Kristine - so you can display the civicrm date fields in a views format: table - but you can't get them into a views format calendar - is that right?
Comments.UserDisplayName: KarinG - Semper IT
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-05-04T20:45:00.697Z
Comments.Text: Yes, you're right! I'm also trying to figure out if this is a bug in CiviCRM Entity.
Comments.UserDisplayName: Kristine
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-05-25T10:29:15.823Z
Comments.Text: Did you update your settings.php with the new custom field?
Comments.UserDisplayName: pmoz
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-07-07T15:15:35.647Z
Comments.Text: If you are using CiviCRM Entity, and the version is old, you should upgrade to 2.0-beta8....CiviCRM Entity used to automatically create field handlers for custom fields that didn't work...by your sql there it looks like this may be the case...you should use the "stock" handlers....the custom fields are in separate groups, the name of of the custom field group...
Comments.UserDisplayName: jackrabbithanna
Tags: <custom-fields><drupal-views><calendar>
Title: Displaying Custom Fields in Views Calendar
ThreadText: # Displaying Custom Fields in Views Calendar
  
  (Asked by: username_0 on 2017-05-04)
  
  Is there a way to display custom fields in a Views Calendar (Drupal 7, CiviCRM 4.7.18)? I have custom fields in a table assigned to a certain contact (with the option to add more rows). One of these fields, is a date/time field. I'm trying to display this field in Views Calendar. I tried going to "add view from template" and then choosing the option: "A calendar view of the 'custom\_45' field in the 'civicrm\_contact' base table." However, I'm getting the error:
  
  ```
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'civicrm_contact.custom_45' in 'field list'
  
  ```
  
  Weird because I am able to list all these fields in a table fine.
  
  **Tags:** custom-fields, drupal-views, calendar
  
  > **Comments:**
  > **username_1**: Hi username_0 - so you can display the civicrm date fields in a views format: table - but you can't get them into a views format calendar - is that right?  
  > **username_0**: Yes, you're right! I'm also trying to figure out if this is a bug in CiviCRM Entity.  
  > **username_2**: Did you update your settings.php with the new custom field?  
  > **username_3**: If you are using CiviCRM Entity, and the version is old, you should upgrade to 2.0-beta8....CiviCRM Entity used to automatically create field handlers for custom fields that didn't work...by your sql there it looks like this may be the case...you should use the "stock" handlers....the custom fields are in separate groups, the name of of the custom field group...  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_4 on 2017-06-07. Score: 1
  
  That error appears when Drupal can't recognise your CiviCRM SQL Tables.
  
  You can find guidance on how to update your settings.php file here: <https://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration>
  
  > **Comments:**
  > **username_5**: username_0 seems to be saying the custom field shows fine in a non-calendar based view, which suggests settings.php wouldn't be the issue.  
  
  ---
  
  