Disable button if there's no email address in record

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

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)})
)
2 Likes

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

1 Like