Dear colleagues

 

If I want to add dynamic links in an email template, I tried to do adding a button to click to product with the URL to open the Web page get from a macro (URL is on a field on contact table), didn’t work, didn't add the tracking tokens, for example:

Normal button:

 "Dynamic" Button:

Any ideas how toe enable adding the tracking tokens to the "Dynamic" Button?

 

Thanks in advance

 

Best regards

Julio Falcón

Like 0

Like

3 comments

Hello Julio,

 

At this moment full macros link will not work for tracking, but there is a workaround with a link+macro tail.

 

So at this point instead of [#Contact.UsrButtonProdID2#] you will proceed with https://www.implementos.cl/[#Contact.UsrButtonProdID2#]?bpmtrackid=4

 

The domain of the website will be the same for the recipients, but the content will be dynamic.

 

Thank you for bringing this issue to our attention. We will consider making this mechanism more user-friendly in future releases.

 

Best Regards,

Dan

 

Thanks to anticipate the solution Dan, I will document it also

 

It appears when Creatio “see“ where must be a URL, a non-URL string, as is the case of a macro, it “think” there aren't any URL to track, and didn’t add the tokens, to complement Dan comment, what I did to solve the problem:

* In images I introduce, on the image address, the first part of the image URL “https://images.ClientWebStore.com/” and add the field using macro to complete the URL with the specific image address, getting something like this in the Image URL: https://images.ClientWebStore.com/[#Contact.UsrImgProdID2#], in the UsrImgProdID2 field I have the rest of the URL, like this "img/1000/HERCAR0005-1.jpg"
 
* For the Product, in Link to Open add “https://www.ClientWebStore.com/” and later the rest of the product URL from the macro, resulting value getting something like this https://www.ClientWebStore.com/[#Contact.UsrButtonProdID2#]  and works as is expected, Creatio add all the expected tokens. In the UsrButtonProdID2 field I have the rest of the URL to open the product page in the store, like "inicio/productos/ficha/gata-hidraulica-32-toneladas-HERCAR0005"

 

IT WORKS! thank you very much!

Show all comments

Hello,

 

Somebody knows how can I add data from a detail connected to the contact who belongs an email?

 

I'm trying to compose a bulk/trigger email including some data on contact details, but no one detail is available from the template editor

 

Any ideas?

 

Thanks in advance

Regards

Like 0

Like

6 comments
Best reply

Hello Julio,

SalesUp has a marketplace add-on that might work for your needs. See https://marketplace.creatio.com/app/salesup-enhanced-template-macros-cr…

Ryan

Dear Julio,

Unfortunately, it is not possible to insert information from details into macros. One account can have many records in the detail and the macro can only use one record. 

The "Connected objects" list displays only the objects that are present as columns in Contacts\Account.



We already have a task registered for our R&D to implement such functionality in future updates.

Sorry for the inconvenience.

Thanks Pavlo, would be great to have the possibility to add a detail of Recommended Products, to contact, in the email, for example.

Hello Julio,

SalesUp has a marketplace add-on that might work for your needs. See https://marketplace.creatio.com/app/salesup-enhanced-template-macros-cr…

Ryan

Ryan Farley,

Thanks Ryan, I'll try it!

 

Regards

Julio

Ryan Farley,

Sorry, I didn't see your previous reply :-(

Thanks Ryan, I told with SalesUp guys, and they confirm me, specifically what we need is not possible with the app, as they answers me: " The main function of our solution is to use data, taken from details (tables, lists...) to create templates with the help of macros. "

Show all comments

Hey,



I'm trying to implement business task when we need to send a datalist/table in email template.

I was surfing the academy and came into this https://community.creatio.com/questions/how-display-datalist-email-template 



But i faced a little problem,

When inserting my macros to email template, the message itself not recognizing the html code.



Any suggestions how to fix it? 

Thanks

Like 0

Like

6 comments
Best reply

Oleksii Protsiuk,

 

Hello,

 

&amp;lt; means that there should've been < in the code. I believe there is an issue with the html code translation in your template. You need to replace:

 

&amp;lt; with <

&amp;gt; with >

&amp;gt with > either

 

using Notepad++ replacement for example (I've modified the code you sent using this text editor). As a result I received a correct code, but after that the HTML should be checked. This can be done via the tests in Visual Studio and receivig the HTML code result and verifying it for example here. You can use some test values instead of entity.GetColumnValue(colPercentage.Name).ToString() to verify the code.

Dear Oleksii,

 

Thanks for reaching out.

 

Could you please provide us an example of macros you are trying to insert into your email template?

 

Thanks in advance. 

 

Best regards,

Anastasiia

Anastasiia Marushenko,

namespace Terrasoft.Configuration
{
	using System;
	using Terrasoft;
	using Terrasoft.Common;
	using Terrasoft.Core;
	using Terrasoft.Core.Entities;
	using Terrasoft.Core.DB;
	using Newtonsoft.Json;
 
	public class NewEmailMacros : IMacrosInvokable
    {
        public UserConnection UserConnection {
            get;
            set;
        }
        public string GetMacrosValue(object arguments) {
//        	var sjson = JsonConvert.SerializeObject(arguments);
//        	var templ = new {Key = String.Empty, Value = String.Empty};
        	var currencyId = "c1057119-53e6-df11-971b-001d60e938c6";
        	var esq = new EntitySchemaQuery(UserConnection.EntitySchemaManager, “Object"); 
            var colCode = esq.AddColumn("Column1"); 
            var colPercentage = esq.AddColumn("Column2"); 
            var colCurrency = esq.AddColumn("Column3");
            var colType = esq.AddColumn("Column4");
            var colDate = esq.AddColumn("Column5");
	        var colDay = esq.AddColumn("Column6"); 
          	var CurrencyFilter = esq.CreateFilterWithParameters(
    		FilterComparisonType.Equal, "Column3.Id", currencyId); 
	          esq.Filters.Add(CurrencyFilter);
           EntityCollection entities = esq.GetEntityCollection(UserConnection);
 var html = "&amp;lt;table&amp;gt;&amp;lt;tr&amp;gt;&amp;lt;td&amp;gt;Percentage&amp;lt;/td&amp;gt;&amp;lt;td&amp;gt;&amp;lt;th&amp;gt;Code&amp;lt;/th&amp;gt;&amp;lt;/td&amp;gt;&amp;lt;td&amp;gt;Currency&amp;lt;/td&amp;gt;&amp;lt;td&amp;gt;Type&amp;lt;/td&amp;gt;&amp;lt;td&amp;gt;Date&amp;lt;/td&amp;gt;&amp;lt;td&amp;gt;Day&amp;lt;/td&amp;gt;&amp;lt;/tr&amp;gt";
            foreach (Entity entity in entities) {
 	          	html += "&amp;lt;tr&amp;gt;";
 	          	html += "&amp;lt;td&amp;gt;" + entity.GetColumnValue(colPercentage.Name).ToString() + "&amp;lt;/td&amp;gt;";
            	html += "&amp;lt;td&amp;gt;" + entity.GetColumnValue(colCode.Name).ToString() + "&amp;lt;/td&amp;gt;";
     	      	html += "&amp;lt;td&amp;gt;" + entity.GetColumnValue(colCurrency.Name).ToString() + "&amp;lt;/td&amp;gt;";
      	     	html += "&amp;lt;td&amp;gt;" + entity.GetColumnValue(colType.Name).ToString() + "&amp;lt;/td&amp;gt;";
         	  	html += "&amp;lt;td&amp;gt;" + entity.GetColumnValue(colDate.Name).ToString() + "&amp;lt;/td&amp;gt;";
				html += "&amp;lt;td&amp;gt;" + entity.GetColumnValue(colDay.Name).ToString() + "&amp;lt;/td&amp;gt;";
            	html += "&amp;lt;/tr&amp;gt;";
            }
				html += "&amp;lt;/table&amp;gt;";
            	return html;
        }
    }
}

 

Anastasiia Marushenko,

I dont know why it kept changing the code, and adding the amp*

html += "&lt;/table&gt;";

 

 

Oleksii Protsiuk,

 

Hello,

 

&amp;lt; means that there should've been < in the code. I believe there is an issue with the html code translation in your template. You need to replace:

 

&amp;lt; with <

&amp;gt; with >

&amp;gt with > either

 

using Notepad++ replacement for example (I've modified the code you sent using this text editor). As a result I received a correct code, but after that the HTML should be checked. This can be done via the tests in Visual Studio and receivig the HTML code result and verifying it for example here. You can use some test values instead of entity.GetColumnValue(colPercentage.Name).ToString() to verify the code.

Oleg Drobina,

Thank you very much!

That helped.

You can use the Enhanced template macros for Creatio app from Marketplace.

You won't need to write additional code.

https://marketplace.creatio.com/app/enhanced-template-macros-creatio

Show all comments

Hello



It is very common situation, when designer is managing Email templates, but should not have access to other Lookups

But currently system doesn't allow him to do that until he has access acces to that Operation persmission

There is a simple way to remove this check for any lookup (you can see this in City), but the problems with Email templates is that this is not lookup, but Base object.



And check for CanManageLookups permsission is done by not very good way - it is not possible to overwrite Script in the process

 

Could you please make very easy fix - move this script to process method, like it is done in Base lookup?







Or can you suggest another solution/workaround?



Thank you!

Vladimir

1 comments

Hello Vladimir,

 

Thanks a lot for your post and comments. 

 

We have registered the corresponding idea for our R&D team and assigning this post to the project in order to increase its priority.

Show all comments

Creatio Community,

 

Is it possible to format a custom macro field on an email template? I need to display a date with the long format date on an email (eg. August 25, 2022) 



The email definition that has the date looks like this:



The details of this fee were [#UsrPatientContactPreference.UsrEmailText#] to the patient or dispute submitter, on [#UsrRequestForAdditionalInformationSentOn#]



The  last field is the one I need to format.

 

Thanks,

Jose

Like 0

Like

1 comments
Best reply

Hi Jose,

 

Unfortunately, of now, there is no such functionality, but our R&D already has plans to implement it in future versions of Creatio!

 

As a workaround you can add a macro handler into the template:

https://academy.creatio.com/docs/developer/application_components/email…

Hi Jose,

 

Unfortunately, of now, there is no such functionality, but our R&D already has plans to implement it in future versions of Creatio!

 

As a workaround you can add a macro handler into the template:

https://academy.creatio.com/docs/developer/application_components/email…

Show all comments

Hello,



I am trying to set up an action for a button in my email template. I want to create a "forward this email" button that opens up an email client when the user clicks it but there doesn't seem to be a way to do this. I can see that you can set up a text hyperlink that will open up an email to specific address, but that isn't quite what I'm after.



Does anybody know a way to do this?

Like 0

Like

4 comments

Hello Evie,

What do you mean by "opens up an email client"? Do you want to create a similar button to the base one but in the template itself? 

Dmytro Vovchenko,

Hiya,



Yes, that's it – by email client I mean whatever the end user has on their desktop for opening emails. I want the button to act as a forward button as you have shown, so that when they click it it opens their emails automatically. Do you know if that can be done?



Thanks!

Evie Cobbin,

Please take a look at this conversation, I believe this is exactly what you need.

Dmytro Vovchenko,

Hiya,



Thanks for your help but I found the conversation in the link a bit confusing to be honest. I'm wondering if there is a bit of a simpler way to do it?



Thanks,

Evie

Show all comments

When we try to send an email directly from the contact's 360 view, the default email signature gets removed when a template is selected. Is this an out of the box feature? How to make the signature remain at the bottom even when a template is selected as the body of the email?

Like 1

Like

1 comments

Hello Suman,

 

We investigated this behaviour and currently, the system behaves correctly since you can add a macro in the signature so it could fit the template or depend on some value.



I informed our R&D department about this case so they could consider enhancing the following functionality in the upcoming releases.



Best regards,

Bogdan

Show all comments

Hi Community,

 

We are creating email templates in DEV environment. In the DEV, we are adding link to object in the template and it works perfectly on DEV. But the issue comes when we migrate the changes to higher instances, it still shows the link to DEV.

 

How we can show the link for the same application from which the email is being sent? Really appreciate any suggestions.

 

Regards,

Sourav Kumar Samal

Like 1

Like

4 comments

Hello Sourav,

 

It seems that you are typing the whole link in the string value. Perhaps it would be suitable to replace them with macros and use Website Url (system setting for example) value to populate it. 

 

If your case does not allow you to use macros - please provide more details and screenshots along with step-by-step recreation of the misbehavior and a description of the expected behavior you want to achieve.

 

I hope this reply was helpful to you.

 

Best Regards,

Dan

Denis Bidukha,

 

We are using templates from Template section. We are using the link to object in the template as shown below,

 

 

Regards,

Sourav

Sourav Kumar Samal,

 

Unfortunately, the link to the object is absolute and not website-dependent. You should either modify it manually after migration or use the macros that was mentioned above. It is planned to change this in future versions, but there are no details available yet.

 

Best Regards,

Dan

Hi, is in the R&D plan to solve this?

Show all comments

Hello there,

I've got a question about email templates in business processes and the signature configured in the mailbox settings.

Is it possible to remove the signature from emails with templates?

Our problem is that the signature is bound to the left and the templates is in the middle, so the signature won't fit style wise. 

On normal emails the signature should still be filled in automatically.

Like 0

Like

1 comments

Hello Markus,

 

We investigated this behaviour and currently, the system behaves correctly since you can add a macro in the signature so it could fit the template or depend on some value.



We have already registered the idea for our R&D team to implement this functionality in further releases. I will assign your case to this project in order to increase its priority. 



Best regards,

Bogdan

Show all comments

Is there a table I could query that would show me all the email templates that have been used?

Like 0

Like

1 comments

Hello Mitch,

 

Could you please elaborate on the task you are trying to do?

 

Thank you,

Artem.

Show all comments