Automation Email - URL link broken

Are there any special characters in the url, such as underscore characters?

When Airtable automations send out emails, they parse markdown text formatting in a strange way that can break links.

Yes, thank you! I just noticed that the break happens at the first underscore…

Does anyone know if this will be fixed?

This is two of the many reasons we avoid using Airtable automation to dispatch emails. Instead, we push all dispatch processes to a webhook in Workspaces where we can conceal the lengthy URLs as embedded HTML.

Lacking that, we have used a URL shortner on the Google URLs applied in Airtable using a simple script automation. This makes it possible to eliminate these massive URLs while making the direct emails (a) cleaner and (b) actually work.

Try this formula to escape the underscores:

SUBSTITUTE({Original Url}, "_", "\_")

SUBSTITUTE({Original Url}, "_", "\_")

I thought about this approach and imagined that it would require an unescape process at some point or the URLs would be broken. Would the email clients all naturally unescape these urls?

I only used the escaped urls when sending the url via an Airtable email automation so that the url is correct when the email arrives at the client. This thread has more info.

@kuovonne Thank you! The formula worked and fixed the email URL issue :grinning_face_with_smiling_eyes:

Is there a script/formula within the “Send an email” / “Message” automation action input box that will resolve this?

Or is the only solution to create a new field with a formula to escape the underscores?

You cannot use formula fields in automations.

You could potentially use a scripting action to do this. However, most people (including some script writers) find it easier to create a new formula field in the table.