Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Airtable Email Automation - Dynamic Clickable Urls from Records

Topic Labels: Automations
689 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.

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

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!