- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 23, 2024 01:05 AM - edited ‎Aug 23, 2024 01:07 AM
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:
- Add records as List - too long vertically, not useful at all.
- Add records as Grid - too long horizontally, same issue as above.
- Try to manually format as table with HTML/Markdown: didn't work
- 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.
- Tried using helper grid views and scripts, but couldn't approach problem in a meaningful way.
Many thanks,
Mo
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 23, 2024 02:01 AM
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
