Skip to main content
17 votes
Accepted

How can Members download their own Membership Certificate/Card in Drupal 7?

No custom code required! If you're on Drupal Views integration, which ships with CiviCRM - all that's required here are Drupal modules Views, Views PDF and installation of two libraries for the PDF ...
KarinG - Semper IT's user avatar
11 votes
Accepted

Calculate Contact age in a Drupal view

In your view, pull in the CiviCRM birth date field. Under date format, select Time ago. This will present the D.O.B. field as 40 years 7 months To remove years and months from the output you can ‘...
Anil's user avatar
  • 1,963
9 votes
Accepted

How to put your CiviCRM Contacts on a Leafleft Map in 5min?

Leaftlet is an open-source JavaScript Library for interactive mobile friendly maps. It only takes a few minutes to put your CiviCRM Contacts on a Leaflet Map if you're using Drupal. Here are some of ...
KarinG - Semper IT's user avatar
9 votes
Accepted

How to get CiviCRM Views to work in Drupal 8 with separate CiviCRM database

I had the same problem today, so I looked in the source code. In civicrm.install there's a function called _civicrm_get_db_config. It's looking in the $databases array for an element with a key ...
Jon G - Megaphone Tech's user avatar
7 votes

Managing multiple CiviCRM relationships in a Drupal View: A case study for A->C plus B->C relationships

Here's my solution for achieving the three goals outlined in the question. I may edit this a bit as I find errors and where commenters declare confusion. First, the caveats. Second, some info about ...
Lewis's user avatar
  • 457
7 votes

Prefill webform with civicrm activity data

Below please find some screenshots to illustrate how to do this: 1. This is a View of Activities. Each Activity has an Update button [that's a Global: Custom Text field -> Text Update; Rewrite ...
KarinG - Semper IT's user avatar
6 votes
Accepted

Use Drupal Views to select Organisation and display contacts with a particular relationship to Organisation

To create a Drupal relationship in a View for contacts A - B or B - A you need to add 2x Drupal relationship. In the case of starting with the Org assuming it as at the B end of the relationship, ...
petednz - fuzion's user avatar
  • 28.3k
5 votes
Accepted

Drupal Views - Show "Contribution" + Drupal User fields

Nevermind, figured it out - had to create a Relationship to CiviCRM Contacts: Drupal ID. Issue resolved.
Alex Katayama's user avatar
5 votes

How to create a Drupal View with multiple CiviCRM relationships?

This is an update to the answer given by petednz - fuzion. In my case I needed to create a view which showed a list of all employees of the organisation employing the currently logged in employee. In ...
Ben's user avatar
  • 946
5 votes

How can I bulk update a collection of recurring contributions to set the next scheduled contribution to a specific date?

Since yesterday you can now do that if you're using Drupal! @jackrabbithanna (Mark) added some code to CiviCRM Entity Project, which now exposes civicrm_contribution_recur as an Entity in Drupal so ...
KarinG - Semper IT's user avatar
5 votes
Accepted

Views: Filter results by current logged-in user

Found it! To limit views results to the current user, you want to: Create a relationship Go to Advanced > Relationships > Add 'CiviCRM Contacts: Drupal ID' Add the filter criteria User: ...
termdark's user avatar
  • 609
5 votes

Why have all my custom Civi fields stopped showing up in Drupal view?

In most cases this is fixed by running drush cc all. I don't know what the circumstances are that causes the upgrading 'clear caches' to not suffice but this seems to be the fix. If 'Clear Caches' ...
petednz - fuzion's user avatar
  • 28.3k
4 votes

is it worth switching from Joomla to Drupal for better CiviCRM integration?

Developers tend to prefer Drupal over Joomla. But each CMS has it's pros & cons. You need to figure out which one is better for you. For example if you have a Joomla extension that gives you ...
Sanjay Jain's user avatar
  • 2,826
4 votes

Civicrm fields in Views, present with editable fields?

(edited) Thanks for triggering me to retest this module ;-) Some quick testing on the drupal module Editable Views for D7 shows this now works. Note1: site tested on also using CiviCRM Entity so ...
petednz - fuzion's user avatar
  • 28.3k
4 votes
Accepted

Spouse relationship in a Drupal view

You need to add the relationship from the contact ID B?
ErikH - CiviCooP's user avatar
4 votes
Accepted

How to create a Drupal View that calculates activity end time by duration

The template file is just to change how this one field is displayed. Create a view of civicrm activities. Add the Scheduled Activity Date field three times. First to display the date. Second to ...
pmoz's user avatar
  • 1,821
4 votes
Accepted

Civireport vs Views

A basic difference is that CiviReport is CMS-independent whereas Views is a Drupal module so those running WordPress or Joomla don't have that choice. (Yes, OP knows that ... some readers might not!) ...
Aidan's user avatar
  • 13.5k
4 votes
Accepted

Views : SQLSTATE[42S02]: Base table or view not found (concerning a Custom Value Table)

This error usually means .... "Drupal doesn't know the table exists" ... which either means 1/ you have your civicrm tables in a different database and need to update the list of tables that you ...
petednz - fuzion's user avatar
  • 28.3k
4 votes
Accepted

Only Exposing CiviCRM Contact from Active Group in Drupal Views?

When you remove someone from a group, the status of their group membership is changed from 'Added' to 'Removed', so try adding another filter on status: CiviCRM Groups: Contact Status (= Added)
Aidan's user avatar
  • 13.5k
4 votes

Phantom contact record

Most likely, the contact is deleted, but your view isn't filtering out deleted users. You may want to check that in your view. You can search for deleted contacts from Search menu » Advanced Search ...
Jon G - Megaphone Tech's user avatar
4 votes
Accepted

How do I get Views working with CiviCRM and Backdrop?

Getting Views working with Backdrop is essentially the same as getting Views working with Drupal, although there can be one extra step. So first, follow these instructions to get CiviCRM's tables into ...
Laryn's user avatar
  • 8,253
4 votes

Drupal Views Filtering on Subtype

I think I might have figured out what's going on here... The tables that are trying to be used in the view have been created after the table details were taken from sites/all/modules/civicrm/install/...
Mo-ster's user avatar
  • 283
4 votes

How can I show a list of events with summaries and either a register link or message saying they are full?

As with many problems with Drupal integration civcrm_entity is the answer. Install the latest civicrm_entity module for Drupal in the usual way (Recommend using Drush if you can).You'll also need to ...
joewickert's user avatar
4 votes
Accepted

Creating Membership Directory using Views in Drupal 7

If you have separate databases then you need to enable CiviCRM Drupal views integration you need to add some information to the sites settings.php file. Visit - /civicrm/admin/setting/uf?reset=1 ...
Anil's user avatar
  • 1,963
4 votes

How do you stop names from doubling - Views

If I had to guess, I'd say your "Look up Leaders" functionality is built with Views in Drupal or Backdrop, and it shows up double because there are two different "Other" phone numbers for these ...
Laryn's user avatar
  • 8,253
4 votes
Accepted

Drupal Views and Case Relationships

Ok, once again I should have looked more carefully at the suggested answers If contact has multiple cases, how do I filter a view to show only case roles associated to that case type Start with a ...
Craig Almond's user avatar
  • 2,037
4 votes
Accepted

Drupal 9 View Shows Permission Denied For CiviCRM Tables

Remove ` symbol added to the database name in settings.php eg $databases['default']['default']['prefix']= array( 'default' => '', 'civicrm_acl' => '`civicrm_prod`...
Pradeep Nayak's user avatar
4 votes

Drupal 9 Views: rich text fields render with all HTML tags visible

Based on feedback from Skvare's Mark Hanna on chat.civicrm.org you need to rewrite the field output, using the _value version and add |raw in the twig. For the event description field, this looks like:...
Nic's user avatar
  • 530
4 votes
Accepted

Include a CiviCRM role into Drupal View (custom dashboard)

I'd start with a case relationships view. Filter by relationship type, and case type. Bring in the case details via a views relationship And bring in the two contacts (A and B, from the relationship) ...
Craig Almond's user avatar
  • 2,037
4 votes

SearchKit - can I return the first four characters of a string?

I've put up a PR to make LEFT(), RIGHT() and SUBSTRING() available. If you don't want to wait for the release with these, just put a copy of those files into the right place. That will let you show ...
Aidan's user avatar
  • 13.5k

Only top scored, non community-wiki answers of a minimum length are eligible