Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Automation Help | Email Notifications

273 3
cancel
Showing results for 
Search instead for 
Did you mean: 
FPX
6 - Interface Innovator
6 - Interface Innovator

Hi all 

I want to send out weekly email notifications to all my customers which shows only the records (orders) which relates to them (i.e. I dont want to show one customer someone elses orders and ) and where status of the order is NOT complete and ETD (date or formula) is on or before the last day of the current month.

The records (orders) are found in my order line items table with the information (quantity dispatches, quantity remaining, ETD,  etc)

I have a 'look up' customer email address field in this table so I would think this is how this could work? Note that my customers and suppliers both sit in the same table called 'Locations'

I also want this to be in one automation (i.e. I dont want to create an automation per customer) so is there a way to send out to all customers? 

Any suggestions @TheTimeSavingCo @kuovonne ?

Thank you!

3 Replies 3

This is a common scenario. In general ...

- Use a "at scheduled time" trigger to get the automation to run once a week.

- Have a "find records" action that looks for records in the [Customers] table. Use a conditional rollup field to determine if a customer has any open orders that meet your requirements. (See my post on your other thread about the dates.)

- Use a repeating action group for each customer found.

- Within the repeating action group, do another find records to find the orders to include. Then have the send email action.

FPX
6 - Interface Innovator
6 - Interface Innovator

Thanks for the quick reply.

Could you please help with the repeating action part for each customer? I dont follow this sorry...

Hello,

Here are some screen captures to illustrate Kuovonne's solution that works perfectly.

Table client

Add a field "Weekly orders":

Pascal_Gallais_0-1727690642552.png

This field is a formula to count the number of orders that match "reporting conditions":

Pascal_Gallais_1-1727690709303.png

Automation

Trigger in this example is not "at scheduled time", but it does not change the logic of the automation

We start with a "Find records" action on table client to get the list of clients for whom there is something to report:

Pascal_Gallais_2-1727690900622.png

We then add a repeating group action set on the input list from previous "find records" action:

Pascal_Gallais_3-1727691001633.png

We add a new "Find records" action to find "opened orders" for the current client:

Pascal_Gallais_4-1727691082439.png

Where the client_id is identified with the repeating group's current item:

Pascal_Gallais_5-1727691167562.png

Finally, we add the "Send an email" action:

Pascal_Gallais_6-1727691239249.png

"Mail To" comes from the current item:

Pascal_Gallais_7-1727691302953.png

Mail's content is a grid from the second "Find records" action:

Pascal_Gallais_8-1727691370351.png

Here is what the mails looks like for client A:

Pascal_Gallais_9-1727691411674.png

Regards,

Pascal