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 ...
- 15.1k
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 ‘...
- 1,938
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 ...
- 15.1k
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 ...
- 38.6k
7
votes
Accepted
How do I use custom fields in Drupal views?
Saw the same issue here.
We noticed that the field appeared twice in the list of fields. We'd selected it as CiviCRM Contact: My Field - but it also appeared as CiviCRM Custom: My Field.
When we ...
- 2,365
7
votes
Accepted
Activity Report in Views
No aggregation necessary.
Under relationships add two relationships for activity contacts. Select one to be the source and the other to be the target.
Once you've got those relationships, you can ...
- 1,821
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 ...
- 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 ...
- 15.1k
6
votes
Accepted
Adding Case Role to CiviCRM Cases Views
Actually you'll need to start with a CiviCRM Relationships View.
If you start with a view of CiviCRM Cases, you may get bad data if they have multiple open case types with different case managers.
...
- 1,821
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, ...
- 28.1k
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 ...
- 924
5
votes
How to show Users their Membership status so that even users without a membership status get to see the block
I believe you can connect your civiContact view to the membership fields without using that smart group.
I have had success (in views 3) in the past with a civiContact based view using a relationship ...
- 1,499
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.
- 571
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 ...
- 15.1k
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: ...
- 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' ...
- 28.1k
4
votes
Is Drupal Views affecting CiviCRM performance?
Views also offers 'caching' so you could set that if you do have proof that it is the View display that is slowing down your page load.
- 28.1k
4
votes
Is Drupal Views affecting CiviCRM performance?
Views has an option to display the exact query it generates, so you can get a rough idea by running that query alone with a tool that allows you to time it. Ideally a single query should execute in a ...
- 17.5k
4
votes
Cannot create CiviCRM view in Drupal "Error: Base table or view not found: 1146 Table drupal.civicrm
This is because you don't have civicrm_participant as a key in the array defined under CiviCRM Views Integration section. To make sure copy all the tables listed in UF Integration page to settings.php ...
- 6,936
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 ...
- 28.1k
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 ...
- 2,826
4
votes
Accepted
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 ...
- 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!)
...
- 12.9k
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 ...
- 28.1k
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)
- 12.9k
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 ...
- 38.6k
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 ...
- 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/...
- 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 ...
- 254
Only top scored, non community-wiki answers of a minimum length are eligible