Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 13, 2023 09:13 AM - edited May 14, 2023 07:41 AM
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:
this is what the message looks like in the automation :
This is how the formula looks that is making the g drive certificate link-- the link shows up fine in the airtable.
The broken link seems to happen only when the google doc ID has an underscore in it.
Solved! Go to Solution.
May 13, 2023 10:10 PM
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.
May 13, 2023 09:24 AM
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 🙂
May 13, 2023 10:10 PM
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.
May 23, 2023 06:49 AM
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?
May 23, 2023 01:15 PM
Did it. I had to make a formula that changes the link after it's created for proper sending. Thanks!
May 23, 2023 01:21 PM
Jun 27, 2023 05:02 PM
I have the same issue. What was the formula you created?
Thanks!
Jul 16, 2024 12:13 PM
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?