broken link for undescore from attachment fileds

[V11]

Dear Experts

Pl guide 

we have shared folderd being made up on gdrive to store scan documents and its link (url)

copy pasted in base in attachment tye filed - however iif link carrires underscores 

email received from airtable automation with attachment filed , removes this underscore

so  user is unable to access g drive folder as url itself is wrong

requeting experts to guide on how to overcome on this issue asap

e.g.

currently link in g drive shows

https://drive.google.com/drive/folders/1EsGxBLBHgBNBA76Y3mu_MMotiPK2yKQC

3mu_M - unsrscore getting removed

in email received it shows

--

DETAILS ARE UPLOADED ON SHARED DRIVE AT

https://drive.google.com/drive/folders/1EsGxBLBHgBNBA76Y3muMMotiPK2yKQC?usp=sharelink

--

kindly advise on rectifications suggested

[Juliana · Accepted solution]

Hey there! Automations will interpret some special characters as markdown (e.g., underscores as italics), which will cause broken urls in cases such as this one. One way to circumvent this behavior is wrapping the url (either a dynamically inserted token or the url itself) in backticks (`) to retain the original formatting.

Another option is to add a "\" before any underscores using the formula below so that Airtable does not attempt to apply formatting. You'd then swap that formula field in the url field's place in the automation.

SUBSTITUTE({field name}, "_", "\_")

[V11]

thanks a lot Juliana and this will be helpful  to me and all here

[Juliana]

Absolutely; glad that this can help! 😊