Hello,

I have a field that is using a formula in order to create a url. the formula is a concatenate to build a url to a form with prefill value.

I then want to use it to send a email with gmail.

And little thing I do not want to print the url but replace the text with “click here”

I tried several things :

in the body of the email aclick here](record(step1…)

I change the formula in the field it self in order to format. the field is ok in the table but when I send it the URL is there and the markdown is not interpretated…

I realize that my URL :

https://airtable.com/xxxxxxxx?prefill_First+name=Alexandre&prefill_Last+name=Husset&prefill_Email=alexandre@husset.fr&prefill_LinkedIn+profile=https://www.linkedin.com/in/alexandre-husset-61181a/

all the _ just disappear in the email

https://airtable.com/xxxxxxxx?prefillFirst+name=Alexandre&prefillLast+name=Husset&prefillEmail=alexandre@husset.fr&prefillLinkedIn+profile=https://www.linkedin.com/in/alexandre-husset-61181a/

Do you have any ideas ?

Thanks

Alex