Help

Button with MailTo formula to draft email, including a 'clickable' hyperlink

Topic Labels: Base design Data Formulas
1614 5
cancel
Showing results for 
Search instead for 
Did you mean: 
AndyH15
4 - Data Explorer
4 - Data Explorer

Hi all, 

I'm looking at creating a Button on a base which creates a draft email to send to a client. Within the body of the drafted email, I want to include a unique Calendly Link hidden beneath a "click here" button on the drafted email. 

I've got so far with it and the formula is correctly drafting the email, and body, but the link stops at the 'clickable' link part. 


Here's the part of the formula that works;

"mailto:" &

{Email} &

"?subject="&ENCODE_URL_COMPONENT("Book a Meeting")&

"&body=" & ENCODE_URL_COMPONENT("Hi "& {First Name}&",\n\n I hope you're keeping well...")&

 

 

The next part is the bit that stops working;

ENCODE_URL_COMPONENT("<a href="&{Calendly URL}&">click here </a> to book a meeting\n")

 
Any help would be appreciated, thanks in advance!
5 Replies 5

Instead of using <a>, perhaps try using markdown syntax instead?

[Link Text](URL)

 

AndyH15
4 - Data Explorer
4 - Data Explorer

I tried, this, but it didn't work. Could you be a bit more specific in terms of how I should be writing this out, by using my attached formula above?

Hm, here are some pictures of a working set up, does that help?

Screenshot 2023-07-05 at 8.04.13 PM.png

Screenshot 2023-07-05 at 8.04.06 PM.png

Thanks for this, but that doesn't work.

See below screenshots of the formula I have on my 'button' and the output it creates on email. 

I can also see that it's clearly not inputting {Calendly Zoom} which is a URL into the email. However, I've tested this as well with www.google.com as well and this doesn't work either. 

Ah hm, I went and googled this a bit and read something about mailto body's not being able to handle hyperlinks actually, so it might be that this isn't possible I'm afraid.  Apologies!