Use custom fields in reminder messages

  • Paul Seyler
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 7 months ago #85846 by Paul Seyler
Use custom fields in reminder messages was created by Paul Seyler
We offer online courses where the course link is specific to each user. We have added a custom field OnlineMeetingLink, and now want to include that information in the customer's reminder email. How can we do that? The list of available tags under 'Emails and Messages' doesn't include that new field for Reminder Email', even though it does for the admin notification email.

Thanks!
Paul

Please Log in or Create an account to join the conversation.

  • Paul Seyler
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 7 months ago #85850 by Paul Seyler
Replied by Paul Seyler on topic Use custom fields in reminder messages
It turns out that the new custom field OnlineMeetingLink is included in the [Event_Details] data, but without any field title or description. How can I turn that on so customers will know what they're seeing?

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago #85903 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Use custom fields in reminder messages
You should use [REGISTRATION_DETAIL] tag in this case. Maybe the title of the fields are not being showed because your site is multilingual website but you haven't translated title of these custom fields into all languages yet? Look at eventbookingdoc.joomservices.com/multilingual and you will see what you need to translate to make the system works well with multilingual

I think that's the reason of the error. Please check it and get back to me so that I can check it further if needed

Tuan
The following user(s) said Thank You: Paul Seyler

Please Log in or Create an account to join the conversation.

  • Paul Seyler
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 7 months ago #85913 by Paul Seyler
Replied by Paul Seyler on topic Use custom fields in reminder messages
Thanks, Tuan. I added a translation for language en-GB and that UK field title now appears. It appears that my emails are using the en-GB (English-UK) translation, despite the fact that my Joomla site and my browser default to en-US or US-English. Where do I set the default language for the component, and particularly for the email messages?

Is there any way to re-send the reminder email for my test registrant and event? I tried changing the Remind Registrant days and disabling/enabling the plug-in but nothing triggers the reminder. Is there any way to test what we're doing here?

Thanks again. I appreciate the help!
Paul

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago #85937 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Use custom fields in reminder messages
Hi Paul

You will need to run a SQL command to update the data in #__eb_registrants table

UPDATE #__eb_registrants SET is_reminder_sent = 1 WHERE is_reminder_sent = 0

(Need to replace #__ with the correct database table prefix on your site)

After that, the system should re-send reminder emails to these registrants

Tuan
The following user(s) said Thank You: Paul Seyler

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago #85957 by Donal
Replied by Donal on topic Use custom fields in reminder messages

Tuan Pham Ngoc wrote: Hi Paul
UPDATE #__eb_registrants SET is_reminder_sent = 1 WHERE is_reminder_sent = 0
Tuan


I think that query should be the other way around.UPDATE #__eb_registrants SET is_reminder_sent = 0 WHERE is_reminder_sent = 1
The following user(s) said Thank You: Tuan Pham Ngoc, Paul Seyler

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago #85984 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Use custom fields in reminder messages
Yes. The query Donal mentioned is correct. Sorry for te typo, I must be tired at that time

Tuan

Please Log in or Create an account to join the conversation.

  • Paul Seyler
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 7 months ago #86017 by Paul Seyler
Replied by Paul Seyler on topic Use custom fields in reminder messages
Thanks, Tuan and Donal. That solved my problem.

Paul

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago #86023 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Use custom fields in reminder messages
Great. Thanks for confirming

Tuan

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc