Help

Re: Disable button if there's no email address in record

1337 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Randy_Suarez
4 - Data Explorer
4 - Data Explorer

I need help applying conditional logic to a ‘send email’ button. I’d like for the button to only be active for records that indeed have an email assigned. But right now ALL the buttons are active even if there’s no email address on the record. See this screen shot: Anyhelp is greatly greatly appreciated.

This is the formula I have currently in my button:

https://mail.google.com/mail/u/0/?view=cm&to=
& ENCODE_URL_COMPONENT({Email (Primary)})

Shared with CloudApp

2 Replies 2

Wrap your existing formula in an IF that checks for the existence of the email address.

IF(
    {Email (Primary)},
    "https://mail.google.com/mail/u/0/?view=cm&to="
    & ENCODE_URL_COMPONENT({Email (Primary)})
)

Thank you so much for taking the time on this simple question.