Automation Email - use hyperlinks

[Gordon_Rothman]

My base has a field formatted for URLs. When I use automation to send the URL for a given record, how do I make that reference a clickable link in the email? It looks like I should be able to do that with Markdown, but I haven’t figured out the details. Thanks in advance!

[ScottWorld · Accepted solution]

Markdown is different than HTML. It is formatted like this:
[Click on this link to go to Apple’s website](https://www.apple.com)

Airtable supports limited HTML tags. If you’d like to use full HTML tags in your email, I would highly recommend using Make’s advanced automations and integrations for Airtable.

All of Make’s email modules support full HTML.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread.

For example, here is how you would instantly trigger a Make automation from Airtable by using a custom webhook.

I also give live demonstrations of how to use Make in many of my Airtable podcast appearances here.

For example, in this video, I show how to work with Airtable attachment arrays in Make.

.Hope this helps!

— ScottWorld, Expert Airtable Consultant

[Gordon_Rothman]

YES!!! Thank you ScottWorld and Kuovonne!!

[localemagazine]

I've tried this, but when I click on the URL in the email preview it brings me to a broken airtable site, instead of the actual URL...

[FPX]

@ScottWorld @kuovonne 

Any idea what I am doing wrong? I cant seem to shorten the hyperlink. I am using outlook email 

[kuovonne]

FPX, You are including a list of URLs, not a single URL. The syntax for a markdown link only works with a single URL. See this thread for more info.

[FPX]

@kuovonne - Thanks for this. I seem to be missing something...Can you please see why nothing is populating below?

[kuovonne]

@kuovonne - Thanks for this. I seem to be missing something...Can you please see why nothing is populating below?

I don't see any issues with your formula field. Does the formula field show a value in a data grid view?

I'm not sure how the second screen shot relates. In order to use the formula field, you need to include a list of field values for the formula field, not a list of records. You may also need to retest the automation, starting from the trigger, to get values to show up.

[FPX]

Thanks Kuovonne, i wasnt doing the list of field values so is populating now as per below screenshot.

However, the above is no use for me without the link referencing the information against each columns so how would I make the formula work within the grid view please? See below