Skip to main content

Example Of URL/Link in email thats broken, and I need help fixing: Image 2021-02-11 at 10.40.0...


Use Case:

This email gets sent from an air table automation.


The URL is from a field in my table that I’m using CONCATENATE to dynamically add an email to the URL. DT HR: General Phase 1&2 - ...


When I click on the URL in the cell in airtable it works. Example:



The link is just being cut off in the email. See first image example above.


Help?

Hey Joe. Did you ever get a solution for this? It is happening to me as well.


Yes. We found that the “_” in the URL is breaking it. We had to create a new column with a new formula to rewrite the url. This is the formula we used:


SUBSTITUTE({Phase 2 URL}, "_", "\\_")

Yes. We found that the “_” in the URL is breaking it. We had to create a new column with a new formula to rewrite the url. This is the formula we used:


SUBSTITUTE({Phase 2 URL}, "_", "\\_")

obviously, change “{Phase 2 URL}” with whatever column is your use case.


This was so helpful thank you!
Chat GPT thought it was the & in the URL but this is what solved the issue. Thank you!!!


The quickest way of solving this problem is to use markdown formatting in your email like this:

pHuman readable text here](Your Google link here)

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld


@ScottWorld  yes, you’re right. However I had a requirement to create an email in html format including various variables from the table (like dates and links).
So we opted for a formula field with the full html of the email.

The links kept getting broken. So this was really helpful.

It would be great if Airtable had a proper HTML block and then did the parsing on their own.

Ah well…..


@Irit_Levi 

That’s great! Sounds like you’re using some advanced techniques! :)

I’m glad you’ve got your current problem solved. For future automations, it might be easier to do some of these things with Make’s advanced automations, which gives you way more power & control over Airtable.

For example, Make can automatically parse an HTML text block for your emails, and it can even generate HTML tables for you by aggregating data across multiple Airtable records. It also offers thousands of other advanced features that aren’t natively built into Airtable, such as working with arrays or communicating with other apps.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable. And in this video, I show how to work with Airtable arrays in Make.

And here’s a post I wrote up about why I recommend Make vs. Zapier. The summary is that Make is significantly cheaper yet infinitely more powerful than Zapier.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld


@ScottWorld 

I do systems and automations for a living.

I actually prefer Zapier to Make for a huge number of reasons.

But to the point, we created a system in Airtable to create multiple variations of a course for someone who is totally non tech. Each course has multiple sessions and each session has multiple emails and possible links (static and dynamic).

All reminder emails etc are going out through AT (rather than an email tool such as ActiveCampaign or MailerLite) because we needed so much dynamic content that this was the easiest way with minimal future problems for the non techie.

 


Reply