How to email all the related contacts present in SubGrid?

(0) Share

Report

Posted on by nidnani

285

Hi, I have a workflow to send emails to all the contacts related to the store (custom entity) as soon as the lead is sold.

So far, I created the subgrid to list all the related contacts on the Store Form. Any suggestions??

Any help much appreciated.

I have the same question (0)

All responses (19)

Answers (3)

Sort by

Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hello,

You can use Kaskela Elements workflow toolkit for that purpose - kaskelasolutions.com/.../

Was this reply helpful? Yes No
nidnani 285 on at

Like (0)

Report
Copy link

Link copied!

Hi Andrew,

I already tried the Kaskela Elements workflow toolkit but it is unable to add related Contacts for a specific store when running from the workflow.

It adds all the related Contacts for all the stores. Below is the view, I am using to filter out related Contacts. Home depot is the store entity.

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hello,

The query that you use doesn't take into consideration the filter by your location. In order to do that build the proper FetchXml and use it in the step instead of the regular view.

Was this reply helpful? Yes No
nidnani 285 on at

Like (0)

Report
Copy link

Link copied!

Hi Andrew,

This is the Fetch XML query that I am using.

<?xml version="1.0"?>

<fetch distinct="true" mapping="logical" output-format="xml-platform" version="1.0">

<entity name="contact">

<attribute name="fullname"/>

<attribute name="contactid"/>

<attribute name="emailaddress1"/>

<order descending="false" attribute="fullname"/>

<link-entity name="rnu_homedepot" alias="aa" link-type="inner" to="rnu_homedepot_contact_store" from="rnu_homedepotid">

<link-entity name="contact" alias="ad" link-type="inner" to="rnu_homedepotid" from="rnu_homedepot_contact_store"/>

</link-entity>

</entity>

</fetch>

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hello,

You should combine that query with the following - kaskelasolutions.com/.../

Was this reply helpful? Yes No
nidnani 285 on at

Like (0)

Report
Copy link

Link copied!

Hi Andrew, I already tried but no luck. The query finds all the contacts related to all the Stores.

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Can you please provide the query that you used?

Was this reply helpful? Yes No
nidnani 285 on at

Like (0)

Report
Copy link

Link copied!

Thanks Andrew. Below is the Fetch XML Query and view as well.

<?xml version="1.0"?>

<fetch distinct="true" mapping="logical" output-format="xml-platform" version="1.0">
<entity name="contact">
<attribute name="fullname"/>
<attribute name="contactid"/>
<attribute name="emailaddress1"/>
<order descending="false" attribute="fullname"/>
<link-entity name="rnu_homedepot" alias="aa" link-type="inner" to="rnu_homedepot_contact_store" from="rnu_homedepotid">
<link-entity name="contact" alias="ad" link-type="inner" to="rnu_homedepotid" from="rnu_homedepot_contact_store"/>
</link-entity>
</entity>
</fetch>

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

I don't see the filter that was mentioned here - kaskelasolutions.com/.../ and I believe that's the main reason why your workflow doesn't work the way it supposed to.

Was this reply helpful? Yes No
nidnani 285 on at

Like (0)

Report
Copy link

Link copied!

Hi Andrew, there's no option of adding that filter without "Contains Data". As soon as a related entity is added, "contains data" pops up every time.

Was this reply helpful? Yes No