Skip to main content
Solved

broken link for undescore from attachment fileds

V
Forum|alt.badge.img+4
  • V11
  • Known Participant
  • 13 replies

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

Best answer by Juliana11

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

View original
Did this topic help you find an answer to your question?

3 replies

J
Forum|alt.badge.img+11
  • Juliana11
  • Participating Frequently
  • 106 replies
  • Answer
  • May 30, 2023

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

V
1 person likes this
V
Forum|alt.badge.img+4
  • V11
  • Author
  • Known Participant
  • 13 replies
  • May 31, 2023
Juliana11 wrote:

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


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

J
Forum|alt.badge.img+11
  • Juliana11
  • Participating Frequently
  • 106 replies
  • May 31, 2023
V11 wrote:

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


Absolutely; glad that this can help! 😊

Reply


Most helpful members this week

Terms & Conditions