Help

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

Underscore getting lost in links

Topic Labels: Automations
Solved
Jump to Solution
3128 7
cancel
Showing results for 
Search instead for 
Did you mean: 
AnnieJanie
5 - Automation Enthusiast
5 - Automation Enthusiast

I have an automation that is sending a Google Doc link via gmail. But when the link sends, an underscore is left out somehow, so the link doesn't work. Any idea why? Or is there some kind of work around?

This is how the link is showing up when it gets emailed:

Screenshot 2023-05-14 at 10-36-20 Please Print Certificate Barkour Rachel Duquette graduating on 6_21_2023 - info@schoolforthedogs.com - School For The Dogs Mail.png

this is what the message looks like in the automation :

Screenshot 2023-05-14 at 10-31-42 ❇️P13 Enrollments - Airtable.png

 

 

This is how the formula looks that is making  the g drive certificate link-- the link shows up fine in the airtable.

 

"https://docs.google.com/document/d/" & {📜Certificate Google Doc ID}"/edit?usp=drivesdk"

The broken link seems to happen only when the google doc ID has an underscore in it.

1 Solution

Accepted Solutions
NitaiLS
6 - Interface Innovator
6 - Interface Innovator

Hi,

The links are sent broken, for some annoying reason when sent by mail.

The fix is easy: wherever there is "_", replace it with "\_"

the link that will be sent by mail will work.

See Solution in Thread

7 Replies 7
Scott_Hoek
6 - Interface Innovator
6 - Interface Innovator

Can you add some screen shots of your automation steps maybe?  I don't think anyone can really help if we can't see the automation with the problem 🙂

NitaiLS
6 - Interface Innovator
6 - Interface Innovator

Hi,

The links are sent broken, for some annoying reason when sent by mail.

The fix is easy: wherever there is "_", replace it with "\_"

the link that will be sent by mail will work.

AnnieJanie
5 - Automation Enthusiast
5 - Automation Enthusiast

but the links are autogenerated. so you're saying i need to make, like, a formula that looks for hyphens and replaces them, and then send that link?

AnnieJanie
5 - Automation Enthusiast
5 - Automation Enthusiast

Did it. I had to make a formula that changes the link after it's created for proper sending. Thanks!

Great! 🙂

I have the same issue. What was the formula you created?

Thanks!

polencb
4 - Data Explorer
4 - Data Explorer

Late to this game but this sucks.  I have to create a new formula field specifically for this.  Does anybody know if this to be expected or something Airtable should fix at some point?