Email
Service_Creatio
7.17

Is it possible to create a filter on the "to" and "cc" and "bcc" columns of an email form when you are sending an email from a case?

Specifically I am looking for a filter based on some criteria from the case.

 

For example, if the Account for the case is Company A, then only show contacts in the "To" column of the email form if those contacts are from that account.

Like 1

Like

4 comments

Hello Mitch,

 

You need to test two following scenarios:

 

1) Create a lookupListConfig parameter for the "Recepient" attribute (should be created additionally) on the replaced EmailPageV2, creating a Terrasoft.FilterGroup in the parameter and specifying filtering conditions.

 

2)  Replace the getLookupConfig method from the base EmailPageV2 and override it in case the columnName is "Recepient".

 

One of these two approaches should work.

 

Best regards,

Oscar

Oscar Dylan,

Thanks for the insight.



I see these two business process are responsible for sending an email.

 

STEP 1 :  When a new case is created BP - Incoming email registration process : Triggered to send a notification to User 

STEP 2 : When the status of the case is modified/updated BP - Send email to contact on case status change, is triggered and this is linked to another Sub-Process BP - Send email to case contact.

 

I see that the reply is sent to all the recipients and I want reply email should be sent only to the sender (Who raised the request)

i.e., only for TO recipients and not for CC recipients

Hello Bhoonalan, 

Please enable Features CasesOnlyRespondToSender  and SendOnlyToContactEmail .  For MSSQL, use following script:

 

DECLARE @featureCode varchar(max) = 'Feature code',

 @featureId uniqueidentifier;

set @featureId = (select top 1 Id from Feature where Code = @featureCode);

IF @featureId is null

BEGIN

 insert into Feature

  (Name, Code)

 values

  (@featureCode, @featureCode);

 set @featureId = (select top 1 Id from Feature where Code = @featureCode);

END;

delete from AdminUnitFeatureState where FeatureId = @featureId;

insert into AdminUnitFeatureState

 (SysAdminUnitId, FeatureState, FeatureId)

values

 ('A29A3BA5-4B0D-DE11-9A51-005056C00008', 1, @featureId);



This script enables the feature , or creates the feature if it's not created on your instance 



Also, please enable sysSetting AutoNotifyOnlyContact.



Best Regards,

Yurii.

 

One workaround is to edit the 

VwRecepientEmail by adding the account name to the Contact Name field.

This way the user can search by account using the ContactName field.

 

Show all comments
Filtering
contacts
Email
Sales_Creatio_enterprise_edition
7.17

In the Contacts section, I need to filter all the contacts that ever got emails Titled "Thanks" (NOT bulk emails, just simple emails). These emails are displayed here:

I tried any available lookup, yet no success. Which object should be used?

Like 0

Like

6 comments

Maybe like this. But I'm not sure.

https://prnt.sc/z38p5x

That's Participant instead of Owner.

Dear Yuriy, 



The option proposed by Julius above should work for the described purpose. 

Please use Email Participants object to get list of contacts which were in the needed bulk email's audience.



Kind regards,

Roman

Julius,

Thank you! I specified the question: NOT bulk emails, but simple emails

Dear Yuriy, 



In this case you need to build filter like this:



Kind regards,

Roman

Roman Brown,

Roman, that doesn't work for me! That gives only a few contacts. For instance, Darren is not among them. I suspect the contacts don't have activities, just emails. What table stores the emails?

Yuriy Konstantinov,

Activities and emails are stored in the same object, but just in case try to remove type=email filter and check if it helps. 

 

Best regards,

Angela

Show all comments
Email
Email_attachements
Studio_Creatio

Is it possible to auto trigger an email with an attachment? 

Like 0

Like

1 comments

Hello Nicola,

 

Please check this Marketplace solution. I believe it has the exact functionality you are looking for.

 

Best regards,

Bogdan S.

Show all comments

When user tries to add email account an error pops up:



"This account already created by user . Change the email or request access to existing account."



Where can I see list of email accounts setup in the system and how do I change which user has access to a specific account?



 

Like 0

Like

1 comments

Hello Dmitry, 

 

You can check the information about all email accounts that already exist in the system by executing the query: 

 

select * from MailboxSyncSettings

 

This query will show you the list of the already connected mailboxes to the system.  There you also can check who is the owner of the mailbox by the "SysAdminUnitId" column via the next query:

 

select * from SysAdminUnit where Id='SysAdminUnitId_value_for_the_needed_record'

 

If the needed mailbox is already added to the system by another user, this user can set up a shared email account in case it solves your business task (more detailed information can be found in the Set up a shared email account Academy article) or the email account can be deleted from the system and added under the required user. 

 

Please, let us know in case any further information is required. 

 

Best regards, 

Olga. 

Show all comments
Email
Activity

I'd like an email to be sent out when a task/activity is due, but I can't figure out the trigger that looks for activities due today.

 

Does anyone have any ideas?

Like 0

Like

2 comments

Found it... added timer to start 'today' the read activities. 

Assuming this is the best way to do this?

 

Nicola Wall,

 

Yes, this approach can solve your business task.

 

Best regards,

Bogdan S.

Show all comments

Hi Community,

 

We are trying to add new contact via Email but there are few fields which are made mandatory in the contact section and without those field values, contact is not being created.

 

For Eg: the “Type” field is mandatory in the contact section but in the email even if we select enrichment from the incoming email, we won’t get that data for the "type" field. 

 

Question : In that case, what can be done to add the mandatory fields also while adding a new contact from an email?

 

Like 0

Like

1 comments

Hi Amritha,

 

You can use this option when adding a contact upon record creation and then choose the contact type manually:

Also you can set some value for the contact type as a value by default in the "Contact" object settings for the "Type" column:

And as a result the contact will be automatically created with the "Type" column value being filled in.

 

These two approaches are easier than replacing the ContactEnrichmentSchema, adding the ContactType attribute and column into the modal window that is opened when enriching the contact.

 

Best regards,

Oscar

Show all comments
Email
email templates
attachments
cases
7.15
Service_Creatio

Is it possible to create an email template (email templates lookup) that has fixed attachments such as a ms word or ms excel file? For my use case this would be for emails being sent OUT of Creatio from a synced mailbox TO external customers who do not access Creatio, instead they just receive an email to their normal email service such as gmail or outlook. 

Like 0

Like

1 comments

Dear Mitch,

 

Unfortunately, it cannot be done since email templates do not have required architecture for storing attachments. As a workaround, you can use this application: https://marketplace.creatio.com/template/send-email-attachments

 

Best regards,

Angela 

Show all comments
Email
business rule
7.16
Studio_Creatio_enterprise_edition

Hi- 

How would I go about creating a business rule that does not allow users to save a certain email domain as an email address for a contact? 

For example- I don't want any emails that are for domain "ABC.com" 

Can I make a business rule that will not let them save that?

Like 0

Like

1 comments

Dear Heather,

 

To set up validation for email you can use Email address mask system setting - feel free to adjust the RegExp upon your needs.

 

Best regards,

Angela

Show all comments

Hi Team,

 

I have a business process that triggers an email.

 

Requirement in email Template:

1.A section records collection should be filtered by specific field. (say, Contact section records filtered by Account field) i.e. Collection of contact section records matching a specific Account value - Achieved by Read Data Element in business process.

 

2.Now all the filtered records in read data should be populated in the email body content in a table format (Rows and colums) - How to achieve this?

 

I need to insert the collection of records from Read Data element to email body in the table format and the table has to created dynamically depends on the number of records from the read data element.

 

I tried to create a "collection object" in the process parameter and set the collection records to the parameter as in the collectionParameter.png image but how to use this collection object value inside the body of email element and frame to display the values inside the object in table format.

 

Regards,

Bhoobalan P.

Like 0

Like

5 comments

Hi Bhoobalan,

 

This task cannot be achieved using the collection of records, but using a cycle in the process.

 

To achieve your business task you need to create a separate checkbox field in the contact edit page called "Is the record processed?" (just an example of the column name). This checkbox value should be modified by a separate process that should look like on the screenshot below:

Please note that you need to specify an account here contacts for which you need to process. Also please pay attention to the conditional flow conditions.

 

Once done you need to create one more process that will form a list of contacts and for example their emails. Like on the screenshot below:

Please note that you need to create a process parameter with the string data type where emails and contacts list will be stored. Also you need to specify the parameter value in the formula as:

 

[#List of full names and emails#]+ [#Read all contacts.First item of resulting collection.Full name#] + " and the email for this contact is " + [#Read all contacts.First item of resulting collection.Email#] + "<br />"

 

And then use this parameter in the send email process element. As a result this list will be received in the mailbox:

So you can test this approach on your end and check the result.

 

Best regards,

Oscar

Oscar Dylan, but if that data has to be sent in a tabular form , how will that be achieved ? 

Shailey,

 

You will input this formula as a parameter into the HTML-content of the "Send email" process element (please note that I am using <br />tag). You can also use <tr> and <td> tags in the formula to form the template correctly.

 

Best regards,

Oscar

Shailey,

You can see a sample of this method described by Oscar producing a table of data in an email in this article 

https://customerfx.com/article/emailing-a-list-of-multiple-records-from…

Ryan

Oleg Drobina,

Can we add image also from a list in this??

Show all comments
Email
timezone
scheduler
7.16
Studio_Creatio_enterprise_edition

Hello community!



I have a use case where I need to send a reminder email to all users of a certain organization role at 9 AM their morning as per the timezone they have chosen.

 

I cannot use the Start timer element in the business process as it only lets you choose one timezone and not the user's timezone. 

Like 0

Like

3 comments

Dear Shrikanth,

 

If for example organization role contains 50 users and each user has different timezone (not all of them have the same timezone) you will need to start the process 50 times and distinct "processed" users from "unprocessed". Since the amount of timezones is limited it will be easier for you to tag users who should receive an email by some role or other method and create a separate process for sending emails for each time zone instead of each user. 

 

Best regards,

Angela

Angela Reyes,

Hi Angela. Users can belong to any time zone (There are 110 in total) and new users will get added dynamically with maybe new time zones. Also, the time zone's of users can change depending on the user's global travel. 



Adding one BP per time zone is not maintainable down the line. Can I have one BP which will send Emails as per the time zone of the user?

Is there a way we can write code or use the Quartz.Net scheduler to achieve this?

M Shrikanth,

Usually, it is achievable by timer event but since you have many emails that can be sent in 1 day this cannot be done via one process - only several, according to main time zones (for example). Main timezones are 

From east to west they are Atlantic Standard Time (AST), Eastern Standard Time (EST), Central Standard Time (CST), Mountain Standard Time (MST), Pacific Standard Time (PST), Alaskan Standard Time (AKST), Hawaii-Aleutian Standard Time (HST), Samoa standard time (UTC-11) and Chamorro Standard Time (UTC+10). 

 

If you want to create task in quartz for each timezone it will greatly impact system performance due to the huge amount of data. 

 

Best regards,

Angela

Show all comments