AJ2020 Member

Comments

  • Thanks! I just needed to add the case statement one more time to get the email address as the verbiage for the clickable link. This is what finally worked: CONCAT('<a href="mailto:',(Case When Length(`ProcessorEmail`) = 0 Then `OfficerEmail` Else `ProcessorEmail` end), '"target="_BLANK">', (Case When…
    in Clickable email link to Beast Mode field Comment by AJ2020 April 2020
  • Thanks jaeW_at_Domo. I tried your suggestion with another (non-formula) email field ("ExecutiveEmail") & got it to work. But when I switch out to the Case statement where the `PrimaryContactEmail` should go, the ExecutiveEmail shows up, but when I click on it, a blank email opens with no address on it. (formula below) Can…
    in Clickable email link to Beast Mode field Comment by AJ2020 April 2020
Default Avatar