Skip to main content
Solved

One Email per Record - Monthly Automation

L

I see several posts that are similar to my question, but I haven't been able to find the actual solution yet.  

I have a database of all our locations, and at any given time we have about 40 pending locations. I'd like to send an automated email to the listed manager each month asking for an update until the status is changed from pending to open.  

Some managers have multiple pending locations at one time so I'd like to only send one email per manager rather than multiple if there are several pending in their area. There's probably a few ways to do this, but for now I have a rollup column on a different table that breaks down by district all the pending locations.

Any thoughts?

Best answer by kuovonne

Do you have a table of managers that is linked to their locations? If not, make one. Include a conditional rollup field that says if any of the manager's locations are pending.

In your scheduled automation, have a "Find Record" for each manager that has a pending location (based on the rollup field). Then have a repeating group based on the found records. Inside the repeating group, Use the "send email" action inside the repeating group.

View original
Did this topic help you find an answer to your question?

5 replies

kuovonne
Forum|alt.badge.img+17
  • kuovonne
  • Brainy
  • 5993 replies
  • Answer
  • March 27, 2023

Do you have a table of managers that is linked to their locations? If not, make one. Include a conditional rollup field that says if any of the manager's locations are pending.

In your scheduled automation, have a "Find Record" for each manager that has a pending location (based on the rollup field). Then have a repeating group based on the found records. Inside the repeating group, Use the "send email" action inside the repeating group.

Ben_Young1
1 person likes this
  • Ben_Young1
    Ben_Young1
L
  • LeighAnnMoltz
  • Author
  • Known Participant
  • 15 replies
  • March 27, 2023

I do have that rollup set already. I think I set this up the way you recommended. 

 

 

My concern is that it looks like it's sending to the "group" and not per individual. 

 

How do I fix that? 

kuovonne
Forum|alt.badge.img+17
  • kuovonne
  • Brainy
  • 5993 replies
  • March 27, 2023
LeighAnnMoltz wrote:

I do have that rollup set already. I think I set this up the way you recommended. 

 

 

My concern is that it looks like it's sending to the "group" and not per individual. 

 

How do I fix that? 


When configuring the “to” email address from the current list item, not the “Find records” result. 

L
  • LeighAnnMoltz
  • Author
  • Known Participant
  • 15 replies
  • March 27, 2023

Oh my gosh ..... so obvious. Thank you!!! 

J
Forum|alt.badge.img+2
  • jeans886
  • Participating Frequently
  • 6 replies
  • March 19, 2025

​@LeighAnnMoltz I’m struggling still with something similar. Would you be able to share how you created your rollup table of managers and what your find records details are for the action part of the automation?

Reply


Most helpful members this week

Terms & Conditions