Including multiple records in automations

[Olivia_Martin]

I am creating an automation that sends a reminder email if a task is not complete within a certain date. That being said, some users have multiple tasks to complete and receive an individual email for each record they’re attached to.
Is there a way I can have a reminder email sent with multiple records condensed into one message so the owner does not receive multiple emails?

[Databaser]

I don’t think there is. Zapier does however has a own zap called “digest” that does that trick.

https://zapier.com/apps/digest/help

[JonathanBowen]

Hi @Olivia_Martin - have a look at this thread:

Script or Automation? Development and integrations

Hi @Harvey_Mason Yes, you can do this with an automation. It sounds like you are doing this manually, but there is a “last modified time” field which would update automatically when the record is updated - maybe one to consider if you are not already using this. To answer the main question though - some of this might come down to your base design. Do you have a table for owners and a table for properties (with a linked field)? If so, I think you are going to need to use a script (which coul…

There isn’t a way to do this directly, but with a script you could get the details of multiple outstanding tasks and send these in one email.

[kuovonne]

Do you have a user table that is linked to the tasks? You can use formula and conditional rollup fields to rollup the overdue tasks in the user record.

Then you need to use a trigger that includes a time component. For example, you could use a formula in the users table that checks the current hour and returns a value only at a specific hour.

Use the “when record meets conditions” trigger and include two conditions: one for the hour, and another that makes sure the roll up of overdue tasks isn’t empty.

Finally have the email action send the value of the rollup field.

[Lauren_Ober1]

Yes - there is a way to do this - you would just use the find records instead of update record and choose records plural - then pick list or grid and the values you wish to add to the output.

[Dimitris_Goudis]

Hi there,

I guess that you want to share an email in which the content will include the all uncompleted task in a message right?

My recommendation is to develop a function field which tracks the un competed tasks. Then create a field in which you track the deadline, ideally by comparing it with today().
So in automation the trigger will be like “when deadline is above…” then send email to with “the message you want”

Does it help you?

[Joanne_Georges]

Did you ever find a fix for this?  I think I have a found solution that might be simple and align with your goal.