CiviCRM Community Forums (archive)

Hello,  In CiviCRM you can make " Scheduled Reminders"

In the message, you can use custom data
(for example:
Straat + nr: {contact.street_address}
Postcode: {contact.postal_code}
Woonplaats: {contact.city}
Telefoonnummer: {contact.phone}
)

But i have some custom data for a activity, and how can i add this to the message..

I did go to the user fields, and when you hover on the edit button you see a ID in the url. So i used this in the message (for example {contact.custom_80} )
This won't work.

Has someone done this before and know how to use this?

Thanks!

Also, are you trying to include contact custom fields or activity custom fields?

sorry not understanding

if you go here http://drupal.demo.civicrm.org/civicrm/admin/scheduleReminders?action=add&reset=1

you will see it asks you what 'entity' - maybe i just don't see your answer for looking - but are you making a scheduled reminder for an Activity?

Administer ->Customize Data and Screens -> Custom Fields,
Add New Custom Field Set.
Used for Activities, And some specific type.
Save
Create a custom Field.

Now go to Administer --> Communication --> Schedule Reminders --> Add reminder
Choose the right activity,

Now you can add in the HTML format field, for a Tokan. Here i want to use the custom Field i have created (see above).
But this is not in the list of the options in the Tokan.

How can i use this field in the HTML Format field?

{activity.custom_##}  won't work.

Does someone knows how to use this??

it sounds like your testing is showing they are not available

i can confirm that the tokens don't get listed for custom Activity fields, while they do for custom Contact fields.

do you have any resources, coding or dollars, to help get this added?

What do you mean with "do you have any resources, coding or dollars, to help get this added?"

Hi I meant that I don't think this is currently available and hence needs to be developed. So if you having coding abilities within your team, then  jump on IRC for some technical help (which is beyond me) or if you can help fund this, then check the Professionals list to get some quotes.

I will check with Eileen on Monday to see if we have already cooked anything up that does this but it doesn't ring any bells.

I can't see any evidence of hooks being called - the relevant code is in CRM_Mailing_BAO_Mailing::commonCompose

    elseif ($className == 'CRM_Admin_Form_ScheduleReminders') {
      $tokens = array_merge(CRM_Core_SelectValues::activityTokens(), $tokens);
      $tokens = array_merge(CRM_Core_SelectValues::eventTokens(), $tokens);
      $tokens = array_merge(CRM_Core_SelectValues::membershipTokens(), $tokens);
    }

It could really do with some consolidation (& addition of custom tokens for all) - but I think you would need to sink some time in. If you enable smarty in mail
define('CIVICRM_MAIL_SMARTY', TRUE); you could use the {activity.activity_id} token to generate an api call within the smarty - which is not a nice solution either - but it might get you there.

@markjohan, I'm having exactly the same need you have. First, I tried to use the details activity field ({activity.details}) and it worked out but it was just a try. What I really wanted to do, was to use an activity custom field, so I'm having the same problem you're having. I've been taking a look at the code Eileen pointed and I've seen that, at CRM_Core_SelectValues::activityTokens() there is only a few activity fields being populated:

  static function &activityTokens() {
    static $tokens = NULL;

    if (!$tokens) {
      $tokens = array(
        '{activity.activity_id}' => ts('Activity ID'),
        '{activity.subject}' => ts('Activity Subject'),
        '{activity.details}' => ts('Activity Details'),
        '{activity.activity_date_time}' => ts('Activity Date Time'),
      );
    }
    return $tokens;
  }
I'm trying to see how difficult it is to add custom fields there, but it looks like something I can't do on my own.