- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 03, 2024 10:47 PM
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?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 04, 2024 08:12 AM
Rather than concatenate in a formula, pull in your fields into the email body field in your automation. You can do formatting there.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 04, 2024 08:12 AM
Rather than concatenate in a formula, pull in your fields into the email body field in your automation. You can do formatting there.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 04, 2024 09:54 PM
Ahh duh. Thanks so much, so simple I completely missed you could add fields into the email body field 😂
