6

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 results: Output this field as a link -> to the webform URL with case-worker-form?cid2=[contact_id]&aid=[id] and bootstrap classes btn to make it a button] -> the ...


3

Try adding cms integration in your backdrop settings.php CiviCRM >> Administer >> System Settings >> CMS Integration. Step by step documentation : https://docs.civicrm.org/sysadmin/en/latest/integration/backdrop/views/


2

It appears the View you are using is starting from the entity CiviCRM Relationship. This is unusual in my experience. I would be building a View based on Contacts and then adding the Related Contacts by using the View Relationships to pull them in.


2

Having "Update Existing Activity" setting turned on, prefills the form with the matching activity based on Type and Status. In case of multiple activities, it prefills/updates the first one. Adding '&activity1=activityID' in your webform url, irrespective of the 'Update Existing Activity' setting, will prefill and update the activity (with id=activityID)...


2

Thanks Jaap, I now added it by this PR: https://lab.civicrm.org/dev/drupal/issues/95 From CiviCRM 5.21 i guess this will be included.


2

Mostly when working with complex form requirements in Drupal, folk are opting to use webform_civicrm as the flexibility it provides opens up many new options. For example in your case you could use Webform Conditionals to determine which fields show based on the choice of Membership Type (or type an existing user has if they are logged in or using a ...


2

This happens when you have separate database for civicrm tables. Below patch in civicrm_entity module fixes problem for 'Base table or view not found:' diff --git a/src/CivicrmEntityViewsData.php b/src/CivicrmEntityViewsData.php index 51db201..ffbb31d 100644 --- a/src/CivicrmEntityViewsData.php +++ b/src/CivicrmEntityViewsData.php @@ -17,6 +17,8 @@ class ...


2

You can already do this (manually) by searching for the contacts with a certain membership (advanced search) and then select the action register participants for an event.


2

You might find this module even better than you expect: Views Selective Exposed Filters (views_filters_selective) "Restrict exposed filter values to those present in the result set." Whenever you're looking at a selection (or subselection), it'll filter the select options to only those options that are in the result set. So you never have the issue of ...


2

Good questions. As you say, age is a calculated field and afaik won't be available. Either you need to adjust how the DoB field is displayed which may be via js. Only other option, for display purposes, would be to build (you guessed it) a Drupal view block and show that instead.


2

Views CiviCRM Expose Tables might work for you.


2

Okay, I think I got it. First, start with Pradeep's answer and Laryn's in the comments. There's a bug in the output text from Administer >> System Settings >> CMS Integration. It starts the block of text with $database_prefix = array( but it still needs the code as listed in the documentation (in an uncopyable screenshot): $databases['default']['default']['...


2

If you're on D7, you can use the Views CiviCRM Expose Tables module.


1

Unfortunately there is no relationship being handled in views between contribution and payment(financial trxn table). You can do this by writing a small module implementing hook_views_data() hook with civicrm entity module.


1

The answer is No, you do not, at least for Drupal 7. What I was missing was to first, add a new View, selecting CiviCRM Activities, not CiviCRM Contacts. I discovered clues starting on page 169 of The CiviCRM Cookbook by Tony Horrocks.


1

We find a 'drush cc all' or 'clear all caches' via the UI sorts these situations post-upgrade


1

The answer is to update the Drupal settings file with the tables listed in menu Administer/System Settings/CMS Database Integration. There have been new & removed tables. I then cleared the Views cache, and all was well.


1

Or any other solution someone found, like limiting the dropdown to used countries only ? In a Views filter of Country you should be able to select the ~50 that you want listed, and then set the option that says something like "limit to selected items only"


1

I just checked and this is working using the latest D8 CiviCRM Entity - it is under development, so best to use the latest directly from its GitHub Repo: https://github.com/eileenmcnaughton/civicrm_entity/tree/8.x-3.x If you're interested in helping us to advance/accelerate this development - consider becoming a Maker/sponsor of the D8 integration projects ...


1

Somebody who is searching for this answer can use the following civcrm extensions. https://civicrm.org/extensions/event-calendar-extension and https://civicrm.org/blog/totten/experimenting-activity-calendars I have not tested "Activity Calendars" though.


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