Creating a custom table/grid with multiple rows in email automation

[mohsin]

Hello,

I have a Table that captures customer orders information through an Airtable form. Each order can contain anywhere between 1 to 20 products. Gist of problem and my data below with just 2 products:

Ref #	1: Name	1: Size	1: Color	2: Name	2: Size	2: Color
Order 001	Product X	S	Blue	Product O	XXL	Red
Order 002	Product K	M	Black	Product C	S	Black

I have an email automation that gets triggered when a form is submitted. I somehow want the information in email in following format.

Order 001 summary: 

Name	Size	Color
Product X	S	Blue
Product O	XXL	Red

What I have tried:

1. Add records as List - too long vertically, not useful at all.
2. Add records as Grid - too long horizontally, same issue as above.
3. Try to manually format as table with HTML/Markdown: didn't work
4. Current workaround: Add 20 separate grids (attached pic), but if order has only 3 products, 17 empty grids are in the email. Excerpt from automation below.
5. Tried using helper grid views and scripts, but couldn't approach problem in a meaningful way.

Many thanks,

Mo

[Workflow_heroes]

Hi! 

I think this article might be of interest : https://community.airtable.com/t5/automations/can-i-use-conditional-logic-in-automation-emails/td-p/...

By applying conditional logic (like IF statements) you can create the body to your specs. It also mentions an integration for emails.

Hope it helps