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.

Airtable Email Automation - Dynamic Clickable Urls from Records

Topic Labels: Automations
1864 10
cancel
Showing results for 
Search instead for 
Did you mean: 
AFTS-STEVE
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi guys, any help here would be great. I am trying to make a list of records automatically send to me every 24h, this list is based on status, all of this works, but my problem is I can't seem to get the list to be clickable?

Tried both:

[Link Text][List of 'Base record URL']
and
[Link Text](List of 'Base record URL')

Any help to make these clickable would be great

AFTSSTEVE_0-1726654639564.png

AFTSSTEVE_1-1726654713112.png

 

 

10 Replies 10

Hello,

Try the following.

Remove everything within the message input zone

Click on the + sign and select "Find records":

Pascal_Gallais_0-1726655711348.png

My advice is to select the grid option:

Pascal_Gallais_1-1726655760101.png

Select the field values that you want in the grid and click insert:

Pascal_Gallais_3-1726655849935.png

It should look like this:

Pascal_Gallais_4-1726655888429.png

Regards,

Pascal

 

 

Adding on to @Pascal_Gallais- 's solution:

To get the Grid to work you're going to need a long text field with rich text formatting turned on, and then in it you'll need to put the hyperlink to your record.  I'd recommend doing this with an automation:

Screenshot 2024-09-18 at 10.25.54 PM.png

Resulting in this: 

Screenshot 2024-09-18 at 10.28.00 PM.png
And your sent out email would look like this:

Screenshot 2024-09-18 at 10.29.46 PM.png

Link to base

Thanks @TheTimeSavingCo ,

I missed the point with the need for a link to the records.

kuovonne
18 - Pluto
18 - Pluto

The main reason why your link is not working is because you have a LIST of record URLs, and not a single URL in your link.

Adam and Pascal recommended using a grid in the email to break out the links for each individual record. 

Another possible option is to use a formula field to generate the markdown code for the link and then put a list of that formula field in your email. You would have to hardcode parts of the url, but it would not take up any automation runs. 

Interesting!  I was playing with this and couldn't figure out how to get the grid / list to display the hyperlink, could you help me have a look at my setup to see where I'm messing up?

This is how my data looks:

Screenshot 2024-09-19 at 10.17.38 AM.png

And this is how the preview looks:

Screenshot 2024-09-19 at 10.20.36 AM.png

 

AFTS-STEVE
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you @Pascal_Gallais-  and @TheTimeSavingCo  that solution worked. I was curious though, is there anyway to update the order of the fields within this grid view?

Curious @kuovonne to hear a bit more about your solution aswell!

Thanks for the help everyone!

I believe the order is defined by the first non-personal view in the table

kuovonne
18 - Pluto
18 - Pluto

Adam & Steve,

If you create the markdown links in a formula field, you don't show the result in a grid. Show it as a plain text by making a new list of field values.

Here is one example formula:

kuovonne_0-1726764653524.png
Here's the result

kuovonne_1-1726764820626.png

 

 

Ahh, that's by far the most elegant way to handle this, thanks for explaining it!