Skip to content

    • Magic ETL

    Magic ETL

    Clickable email link to Beast Mode field

    Member
    in Magic ETL

    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?

     

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Member
      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

    • Coach

      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.

      Jae Wilson
      Check out my 🎥 Domo Training YouTube Channel 👨‍💻

      **Say "Thanks" by clicking the ❤️ in the post that helped you.
      **Please mark the post that solves your problem by clicking on "Accept as Solution"
    • Member

      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>')

    • Coach

      concat(
      '<a href="mailto:'

      , case when rand()> .5 then 'someone@example.com' else 'hello@example.com' 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('jae@domo.com') = 0 Then 'susan@domo.com' Else 'jae@domo.com' end)
      , '" target="_BLANK">', 'tina@domo.com','</a>')

      Jae Wilson
      Check out my 🎥 Domo Training YouTube Channel 👨‍💻

      **Say "Thanks" by clicking the ❤️ in the post that helped you.
      **Please mark the post that solves your problem by clicking on "Accept as Solution"
    • Member
      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>')

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories