Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Automated email by pulling from different fields in a table

Topic Labels: Automations Formulas
Solved
Jump to Solution
965 2
cancel
Showing results for 
Search instead for 
Did you mean: 
raffy
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Community. I'm new to Airtable automations so apologies for what may be an overly complex workflow - any suggestions to improve it are welcome. 

Goal: send an automated email when someone "invites a friend" on a website. Email will say "Hi {friend's name}, your friend {user's name} {user's email} recommended you join this site", etc. 

How I've set it up so far: 

  • Airtable table with fields Friend's name, Friends email, User's name, User's email 
  • Concatenate formula to combine the above fields into a message something like "Hi {friend's name}, your friend {user's name} {user's email} recommended you join this site"
  • Automation to send an email using the text from the Concatenate formula 

Problem: there doesn't seem to be a way to format the text so when the email sends, it's just a long string of unformatted text. 

Does anyone know a better way to set this up? 

1 Solution

Accepted Solutions
Dan_Montoya
Community Manager
Community Manager

Rather than concatenate in a formula, pull in your fields into the email body field in your automation.  You can do formatting there.  

See Solution in Thread

2 Replies 2
Dan_Montoya
Community Manager
Community Manager

Rather than concatenate in a formula, pull in your fields into the email body field in your automation.  You can do formatting there.  

raffy
5 - Automation Enthusiast
5 - Automation Enthusiast

Ahh duh. Thanks so much, so simple I completely missed you could add fields into the email body field 😂