Replacing underscores in automation emails

[CharlieMullin]

Emails sent via automations replace underscores with nothing, thereby corrupting the URLs, and other values, that contain underscores. I've read the many posts about this and still can't figure out the syntax to use to make this happen.

Here's an example screenshot:

What syntax would I use to ensure the Asset Location (URL) field values will retain any underscores?

I've tried single-quotes with parentheses, and/or brackets but am not having success.

Thoughts?

[ScottWorld]

Can you give more details on the actual URL that you are embedding in your email? I am not experiencing any problems with underscores in my URLs that are sent out via automations.

[CharlieMullin]

Hey ScottWorld, here is a URL value that is stored in a field:

https://corelogic.sharepoint.com/:f:/r/sites/ISSClientTrainingDocuments/Shared%20Documents/General/C...

Note that %20 instances have replaced most underscores except for the one between "Claims/MC" and "VE/MC_AddingCaptions" 

Here's a screenshot of that value as displayed in the automation email I receive:

Notice that the underscore between "Claims/MC" and "VE/MC_AddingCaptions" is missing, instead of being replaced by %20.

As a result, the URL is invalid.

Thoughts?

[ScottWorld]

I would try using markdown syntax and see if it works. This is the markdown syntax:

[your text here](your URL here)

If markdown doesn’t work, I would report this problem to support@airtable.com, and in the meantime, I would recommend using Make's advanced Airtable integrations & automations to send your emails.

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.

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

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

[gregforel]

Hi,

Here's the solution, create a new "Email formatted URL" formula field:

SUBSTITUTE(
   {Your URL},
   "_",
   "\_"
)

Then, only use this Email formatted URL within emails.