I want to create a table in my send email automation because there are several features that I want to put in the email and formatting as a table makes it easy to understand.
I tried creating a table using markdown and HTML but it isn't working.
+12You can insert a table easily using the Find records action. You can set conditions or views of the records you want to include in the table. Then, when creating the email, click the +, "Find records", "Grid", and select the fields you want to include. If the table is the same every time, you could just create a "Master" record and "find" that each time with a record ID, or even create a new table with the variations and an ID number, tie the ID number to a customer, and customize the email that way. There's multiple ways to do this but hopefully this get you headed the right direction.
+12@Ron_Williams Can you please elaborate on it more?
@mshah72 Sure. Without more info on the features you want to include or their location, let's assume you have 2 tables-one for the customer and one for products with features. Create an automation that triggers by checking a checkbox "send email" to that person. Then, use "Find Records" to create a list of the products.
Next, add send an email. In the body, press the plus in the top right, and select "use data from(left side)"-"find records"-"Grid(right side)", then select the fields you want to include in the table.
This will place a table in the email body showing whatever fields you select from the found records. If the fields you want to show are all in the original table with the email, just use the find records and for the condition, use the record ID from the record that triggered the automation (the record ID in the first step).
Let me know if you need any additional clarification.
+5You can insert a table easily using the Find records action. You can set conditions or views of the records you want to include in the table. Then, when creating the email, click the +, "Find records", "Grid", and select the fields you want to include. If the table is the same every time, you could just create a "Master" record and "find" that each time with a record ID, or even create a new table with the variations and an ID number, tie the ID number to a customer, and customize the email that way. There's multiple ways to do this but hopefully this get you headed the right direction.
Thanks a lot @Ron_Williams your guide was very helpful.
+8Is there a way to do a grid for each record in the list of records so only the results of that record are shown?
+28Hey
Do you mean for example:
Find Records action finds 10 records.
Email action will include in its body 10 different individual grids, each showing only one record?
If so, unfortunately that is not possible.. If you really need this you can probably achieve this via third party automation tools such as Make or n8n (more on these tools here).
Feel free to reach out if you need any help setting this up!
Mike, Consultant @ Automatic Nation
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.