Prefill webform with civicrm activity data

Question

I want to prefill a webform with data from a specific CiviCRM activity in order to edit the activity using the webform. I want to do this by having an "Edit" link in a Drupal View of CiviCRM activities. These activities may or may not be associated with a case, so let's assume they aren't. I've turned on "Update Existing Activity" in the webform for all of the statuses.

Can someone confirm that I can do this, and if so, what is the proper form of the URL for the link in the view? I've tried a bunch of different ones and can't seem to get it.

Answer 1

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 URL that is constructed is case-worker-form?cid2=41218&aid=19153

2. The webform case-worker-form -> receives this data. That form is set up such that cid1 = the logged in user (the social worker); cid2 = the client; aid = activity id of the activity to be updated;

3. Let's edit the subject e.g. ->

4. Result:

5. Note the Webform just has Update Existing Activity set to None (as we're matching by aid)

Add on: I've double checked that this is (still) working on our latest webform civicrm 5.x

root@f4d0afb6c36d:/var/www/html/sites/default/modules/webform_civicrm# git log
commit 76b444bf5192ddf4663a0222540684a230d8e39e
Merge: b54ddfd ef2a518
Author: Karin Gerritsen <KarinG>
Date:   Thu Sep 12 11:24:26 2019 -0600
    Merge pull request #251 from colemanw/rel7
    Use api to retrieve relationship data

Add - on config notes:

• ensure your views field is configured such that commas are stripped from cid and aid before passing them into the webform

• ensure your webform is configured to allow an activity of the type you want updated -> setting it to -user select- will ensure that

Answer 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).

In case of revisioning you might need to provide latest activity ID in url or it might not work. Think you could have some custom code or configuration in view to fetch the latest activity id for a contact, to make it work.

Answer 3

This should work but is a bug in the latest version of Webform CiviCRM. Will open a ticket. (Update) Webform requires that the form is configured a certain way on the civicrm tab for activities in order to load the activity. It appears that at least 1 contact on the form needs to be set as a participant on the webform for the autoload to work. nb. I'm going to investigate further if other combinations will or will not work.