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)})
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)})
)
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.