Loom content in formula field

[Heather_Kleinsc]

Hi! Wondering if there's any way to make this work...

I have a formula field that pulls info from multiple fields & concatenates it all together to create an email (content) to be delivered to the person associated with that record.

I want to include a Loom video gif in these emails. (To be clear: This is one shared video link/gif which is going out to everyone. Not unique videos for each person.)

Is there any way to do this within Airtable? 

I'm aware that I could simply paste in the Loom URL. I'm hoping for a way to insert the video's gif file if possible.

Thanks in advance!

[ScottWorld · Accepted solution]

You would need to send an HTML email, so you would need to be sending your email in such a way that it supports HTML code.

From Loom’s website, you can get the HTML code leading to the GIF thumbnail by clicking on the “Share” button, then “Embed”, then “copy thumbnail code”.

This is the HTML code that you will need to embed within your HTML email.

You can use a variety of online text to HTML converters to convert your entire email into HTML code.

However, it can be extremely challenging to put HTML code within an Airtable formula field because you would need to escape all the quotation marks (and possibly other characters) — and even more importantly, I don’t think that Airtable’s automations can use the contents of a formula field as actual HTML code within an email.

So it would be best to just directly paste in the HTML code into wherever you are sending your email from.

Airtable’s email automations support a subset of HTML tags, and Make’s email automations for Airtable support all HTML tags. (Make might even be able to use a formula field as the HTML code, too.)

p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consultant — ScottWorld 

[Heather_Kleinsc]

Thank you, this is helpful!

[ScottWorld]

You’re welcome! Glad I could help! 🙂 If you don’t mind, could you please mark my comment above as the solution to your question? This will help other people who have a similar question in the future, because it should rise to the top of the search results. 🙂 

[TheTimeSavingCo]

Yeap, just grab the Loom thumbnail code, remove all the new lines and dump it into your Send Email action:

And my automation looks like this:

Your thumbnail code will look something like this once you've removed the new lines:

<div><a href="https://www.loom.com/share/e6eea99e121a4349acb3409afc135d36"><p>The platform to build next‒gen apps | Airtable - 12 February 2024 - Watch Video</p></a><a href="https://www.loom.com/share/e6eea99e121a4349acb3409afc135d36"><img style="max-width:300px;" src="https://cdn.loom.com/sessions/thumbnails/e6eea99e121a4349acb3409afc135d36-with-play.gif"></a></div>

Here's a base where I've got that automation set up so you can copy it!