Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [drupal-views]

Questions about CiviCRM's integration with the Views module in Drupal.

Filter by
Sorted by
Tagged with
9
votes
2answers
99 views

How do I add a currently unsupported field to Views?

For example, the email_greeting_display field of the civicrm_contact table is not available as a field in Views. How do I add that to a View? See also How to include a token in a view?
8
votes
3answers
654 views

How to create a Drupal View with multiple CiviCRM relationships?

I would like to create a Drupal View showing an organization and several individuals who are related to the organization in different relationships. The wording on the CiviCRM Drupal relationships ...
8
votes
3answers
918 views

How do I use Views with CiviCRM?

Can someone tell me what I need to use Views with CiviCRM? Is it the regular Drupal Views module with another module that provides integration? Also, how would I use Views to display a count of how ...
8
votes
5answers
339 views

How to display a Drupal view in a CiviCRM tab

I'm trying to display a drupal view in a CiviCRM contact tab. I've tested out my tab function with the code snippet on hook_civicrm_tabs and it will show the contribution tab correctly, and I've ...
8
votes
2answers
828 views

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

To summarize: someone asked me to post this here - so that he can give it a try! put a PIN based on latitude/longitude of the CiviCRM Contact put CiviCRM Contact data in the bubble pop-up color the ...
6
votes
3answers
555 views

How do I use custom fields in Drupal views?

[EDIT] Totally editing this question. Custom fields do not work in my Drupal views, at all: The interface to add the custom field worked just fine. It's only the generated sql thats wrong. Its ...
6
votes
1answer
532 views

How can Members download their own Membership Certificate/Card?

This is a request I get quite often. Below is my favourite solution for it.
6
votes
2answers
246 views

Views Proximity Search on Latitude / Longitude

Has anyone used a proximity filter or sort in Drupal Views based upon a contact's geocoded address? I think it would be doable with the GeoPHP module and a special handler, but I don't know if it has ...
6
votes
2answers
178 views

How could I use CiviCRM for sponsorship

We have a node called sponsorship that is a person, place, or thing. Person is likely a child, but it could be a teacher, nurse, etc. A person generally has one donor that pays a monthly amount. A ...
6
votes
1answer
87 views

Global Dashboard

I just created a new dashlet via Views to show a list of case managers. Is there a way I can add this dashlet to all my current users' dashboards? I know there is the Default Dashlet extension, but ...
5
votes
3answers
83 views

How to show civicrm toolbar in drupal also?

I have created some drupal views for civicrm. But the views pages are opening inside the drupal set up, where the civicrm toolbar is not showing. Now, how can i show the civi toolbar in the drupal? ...
5
votes
2answers
105 views

Use Drupal views to generate contact Reports in Civicrm

I have several different types of report's layouts/formats to print for Civicrm contacts. I know that, we can generate reports by 'Report' menu in Civicrm. But i want some suggestion about how much ...
5
votes
2answers
210 views

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

When setting up a Drupal 8 with separate CiviCRM database, the Drupal views cannot read the CiviCRM database: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxx.civicrm_contact' ...
5
votes
2answers
130 views

Is there a way to add a custom field to the Inbound SMS activity type?

I'm working on a Drupal site that includes a view showing unanswered SMS messages. The view shows activities of the Inbound SMS type that have not been revised or deleted, plus a custom PHP filter ...
5
votes
1answer
174 views

How do I create a Drupal View to display last activity date.

I'm trying to set up a View of Clients, Case Managers and date of last activity. Most of the clients have many activities, but I only want the most recent one displayed. Normally, I would use the ...
5
votes
5answers
167 views

How do you approach “things that you would use Drupal views for” in WordPress?

Coming from a Drupal 7 background but wanting to do more work with WordPress, I am looking for ideas on how people approach "the things that you would normally use Drupal views for". For any ...
5
votes
1answer
51 views

Report or export in xml format

I work for a small nonprofit. Our funding body previously required reports in csv format. they now want them in xml. Of course they are not providing any funds! Can this be done via a custom report or ...
4
votes
3answers
127 views

How to access multiple CiviCRM website fields for a contact in Drupal Views?

I have two website fields for my contacts, a work website and a personal website. I am creating user profile pages (NOT CiviCRM profiles) for each of our members and want to display both website ...
4
votes
1answer
156 views

Activity Report in Views

On Drupal 7, how would you display a list of CiviCRM activities and show the two types of contacts (the activity related to the client and the user who created the activity)? Views is pretty tricky ...
4
votes
1answer
26 views

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

Title says it all really. Sometimes, mostly after an upgrade in my experience, I will go to edit a View that uses CiviCRM Custom Fields and will find messages like 'broken handlers' etc. How can I fix ...
4
votes
2answers
144 views

Displaying a Views block with a CiviCRM-enabled webform

As an alternative to "How can I display an info only field in a webform", we are displaying a read-only View block on a CiviCRM-enabled webform page via Context because one of the fields of the View ...
4
votes
3answers
663 views

How should I generate a report (or view) showing contacts and people they have relationships to?

I would like to create a view, or custom report, whoever is easier, to show the following: -The names of all contacts in a specific group -Some of their contact information -The names of all contacts ...
4
votes
4answers
111 views

How do I sort by Case Type Title instead of id in a Drupal View?

We frequently need to sort Drupal Views by Case Type. It works, but sorts by id not the title field. I believe it has to do with the pseudoconstant references in civicrm.case.inc and civicrm.core....
4
votes
2answers
71 views

How do you stop names from doubling - Views

I have a membership database and a View of Local Leaders info, but it is showing each person twice in the View's list. I have tried to delete the contacts and input them back in they still show up ...
4
votes
3answers
703 views

What is the recommended Wordpress equivalent for drupal-views

CiviCRM manual mentions X-Data Toolkit as a potential substitution to drupal-views. However X-Data Tookit has not been updated in years and its documentation is not available anymore. What other ...
4
votes
2answers
157 views

Select and register multiple people for a pre-selected event

In a Drupal/Civicrm setup, how do I create a page which Lists all members of a group Allows user to select certain members and register them for an pre-selected event to record attendance This is ...
4
votes
2answers
71 views

Spouse relationship in a Drupal view

I currently have a Drupal View Displaying the current user and his/her spouse (AKA Drupal User and CiviCRM Contact B) For some reason it will only Display the Drupal User and spouse if the spousal ...
4
votes
1answer
248 views

Can Drupal Views filter contacts based on Smart Groups

Taking the liberty of creating this new ticket since the previously similarly titled (since retitled by me) post was not really addressing the issue. Laryn is correct when he said on the above post ...
4
votes
2answers
36 views

Cannot see On Hold column in Views 3

I am trying to create a view in Drupal listing all contacts marked as 'on hold' due to their email bouncing. I am unable to find this 'on hold' field for selection in Views. Is this by design or is ...
4
votes
2answers
87 views

custom fields not adding to Drupal views

I'm trying to build a drupal view and pull in rm custom data For both contact (client) and case (view for case contact, relationships include case contact id-case id, and case contact id- contact id) ...
4
votes
1answer
89 views

Activities and Nodes in One Calendar

I currently use Drupal's Calendar module to display CiviCRM activities on a Views Calendar. I also have another content type that displays nodes on a Views Calendar. Is it possible to display both ...
4
votes
1answer
131 views

Drupal View filtered with a custom individual data field

I have a Drupal View that I'm using to display in a directory a list of individuals that are employed by a group of organizations. I saw no way to filter a View based on employer names so I created a ...
4
votes
1answer
239 views

CiviCRM Multi-day Events + Drupal Calendar + Views

How can I show CiviCRM Multi-day events on drupal calendar module (Not fullcalendar), civicrm Entity module and views in drupal 7 ? I am trying to achieve something like this: https://www.drupal.org/...
4
votes
2answers
168 views

How to include a token in a view?

The CiviCRM Views integration (Drupal) provides a way to create a View using data from Civi fields. Is there a way to include the output from a Civi token in the View? The use case is that I have a ...
4
votes
0answers
60 views

CiviCRM date fields in Drupal views

I want to make a Drupal view showing CiviCRM Relationships and I want to expose the start and end date as exposed filters. I want the user to have a nice GUI for picking the start and end date so I ...
3
votes
5answers
176 views

Duplicate entries in Views

I'm using Views to display lists of CiviCRM contacts (4.5.2). I'm finding that several contacts appear in Views twice. Any ideas what might be going on here?
3
votes
5answers
302 views

Error from CiviCRM code when I try to install other Drupal modules

Drupal version 7.34, CiviCRM version 4.5.5 Hi, When I try to install Views and CTools on our Intranet installation, I am getting the following error from Drupal: Exception: API error: DB Error: ...
3
votes
5answers
394 views

How do I add CiviCRM Activity attachment to View

Trying to set up an activity view that displays attachments uploaded to activities. I can't seem to find the field to add. Any ideas?
3
votes
2answers
141 views

Calculate Contact age in a Drupal view

I'm exposing civi contact data in a drupal view. I can expose date of birth, but not the contact age field. Anyone know of a module/ combination of modules that will allow me to calculate age in ...
3
votes
3answers
265 views

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

I have been trying to work out how to create a Drupal View to allow end users to select an Organisation and then it displays Contacts given a specific relationship type. eg Select Employer Name (...
3
votes
2answers
52 views

Is Drupal Views affecting CiviCRM performance?

I have created a Drupal Views block, which aggregates some CiviCRM values. This block I have on most pages. How (if any) is this affecting the performance of the CiviCRM site? (How does Drupal Views ...
3
votes
1answer
416 views

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

Here is the fruit of my journey so far with multiple CiviCRM relationships in Drupal Views. My original question that sparked this question is here: How to create a drupal 'contact me' link ...
3
votes
4answers
320 views

How to create a Drupal View of CiviCRM Activities with an edit link to the corresponding Webform?

Goal is to have a filterable and sortable Drupal View of CiviCRM Activities (not a view of Webform Submissions) created with a Webfom with a link to edit the webform submission. I can painstakingly ...
3
votes
6answers
362 views

Cannot create CiviCRM view in Drupal "Error: Base table or view not found: 1146 Table drupal.civicrm

Drupal 7.41 CiviCRM: 4.6.9 Hi, new to CiviCRM and Drupal. Maybe I'm overlooking something but no matter what I try I cannot create a View from Drupal of any Civi data structure. For example, to show ...
3
votes
1answer
59 views

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

If you're using the iATS Payments Extension you control the schedules of recurring contribution from within your CiviCRM. You can already edit a given recurring series and change the next scheduled ...
3
votes
2answers
55 views

Any best practices/tips for creating a query view against contacts to used with webforms?

I've created a view to query up existing contact and I was able to create a link to a webform with a specific id. I added a combined filter for first name, last name and email. Before it filters you ...
3
votes
1answer
104 views

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

We are collecting registrations for a conference and have a number of optional workshops on one of the afternoons. I want to create a summary page of available workshops for participants with a link ...
3
votes
1answer
20 views

Phantom contact record

I have a view that displays civiCRM contact records according to Contact Type. The displays needs to change every Fall, and the way we do this is by changing the contact type (but keeping the record). ...
3
votes
1answer
117 views

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

I want to create a View based upon civi_participants, including Participant Custom Fields. I can Add the custom fields, but I get the following message : SQLSTATE[42S02]: Base table or view not ...
3
votes
1answer
59 views

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

I'm trying to create a Drupal View table of CiviCRM activities that calculates the end time of the activity based on start time and duration.So far I've got the unix start time of the activity, a math ...