Help

Re: broken link for undescore from attachment fileds

Solved
Jump to Solution
840 0
cancel
Showing results for 
Search instead for 
Did you mean: 
V11
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
Juliana
Airtable Employee
Airtable Employee

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}, "_", "\_")

See Solution in Thread

3 Replies 3
Juliana
Airtable Employee
Airtable Employee

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Absolutely; glad that this can help! 😊