Clickable email link to Beast Mode field

Hi,

I want to make a clickable email in a table. The email field is a formula, however, and I can't get the formula to validate.

The email field I want to be clickable is "PrimaryContactEmail".

Formula for PrimaryContactEmail:

Case
When Length(`ProcessorEmail`) = 0
Then `OfficerEmail`
Else `ProcessorEmail`
End

 

I tried to create a new field "PrimaryContact Link" with the following formula:

CONCAT('<a href="mailto:',`PrimaryContactEmail`,'">',`PrimaryContactEmail`,'</a>')

 

But when I select the column name "PrimaryContactEmail", the Case formula is inserted instead. If I type the column name in, the validation check says "A column in this calculation does not exist".

How can I get the email to be clickable?

 

Best Answer

  • AJ2020
    AJ2020 ⚪️
    Accepted Answer

    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 Length(`ProcessorEmail`) = 0
    Then `OfficerEmail` Else `ProcessorEmail` end),
    '</a>')

Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🔵

    AJ, "A column in this calculation does not exist" says it all.  there's a column that doesn't exist.  if i had to guess your CONCAT is not concatting the way you expect it to, probably a mix up between " , ' and `.

     

      build your concat statement without the case, and slowly add pieces of the HTML  / concat statement until you get a hyperlink that works.  THEN lastly sub in the CASE statement.

  • 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 we not use formula fields?

     

    CONCAT('<a href="mailto:',
    (Case When Length(`ProcessorEmail`) = 0
    Then `OfficerEmail`
    Else `ProcessorEmail`end),
    '">',`ExecutiveEmail`,'</a>')

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🔵

    concat(
    '<a href="mailto:'

    , case when rand()> .5 then '[email protected]' else '[email protected]' end

    ,'?Subject=Hello%20again" target="_BLANK">Send Mail</a>'
    )

     

    both of these work fine.  are you certain your fields don't contain blanks?

     

    CONCAT(
    '<a href="mailto:',
    (Case When Length('[email protected]') = 0 Then '[email protected]' Else '[email protected]' end)
    , '" target="_BLANK">', '[email protected]','</a>')

Sign In or Register to comment.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!