Set the email sending all the information in numerical rows for 1 customer through workflow

[Hai_Anh_Nguyen]

Hello,

I would like to have one question in here:

Which action I should use to lessen email sending to the customer’s emails?

For example: I have an action to send the notification to my custome and I don’t want to send the numerical information to him like this:

I would like to send one mail which will sum up all the order name to one customer (picture below). Could you please give me some suggestions for this? Thank you.

Action I have used but I’m not sure about this. It would be great if you could help us on this. Thank you.

[Steve]

help.appsheet.com

Sending Email from a Workflow Rule or Scheduled Report

A Workflow Rule can send email when data changes. A Scheduled Report can send email on a schedule you specify.

[Hai_Anh_Nguyen]

Hi @Steve ,

Thank you for sending the reference to me. However, I couldn’t solve the problem for sending 7 test emails which has to be sent to the same customer in real life.

Could you please help me send the 1 email with essential information from 7 rows of order’s name (for example)? Scheduled reports seem not suitable with me. Thank you so much for helping me.

[Hai_Anh_Nguyen]

Here’s the workflow that I have set up:

And if the orders has increased in the number, it will send a lot of email to my customer:

It would be great if you could help me with this.

[Steve]

Please post a screenshot of the template you’re using.

[Hai_Anh_Nguyen]

Hi @Steve,

Here’s the template I have used in Google sheet:

• Customer’s sheet:

• Order’s sheet:

The action and the email sent will based on the Status column and the Delivered column. Our daily activities are normally processing many orders and sending to same person. Therefore, sending quite much emails to them is not a good idea with us.

On the app, I have set the workflow rule as below:

The orders completed will be sent as the bulk email because we have different timezone. Therefore, normally, we use one email to confirm all the essential information of the orders.

Thank you for your help on this.

[Steve]

None of the screenshots you posted are of a template. How are you generating the body of your email/

help.appsheet.com

Email Templates

Controlling the content and format of email messages with templates.

[Hai_Anh_Nguyen]

Hi @Steve,

Here is my body’s template for the email:

Thank you.

[Steve]

Your template looks fine.

Please post a screenshot of the email rule configuration for your workflow.

[Hai_Anh_Nguyen]

Hi @Steve,

Here is the rule for my email I have set:

Thank you.

[Steve]