Skip to main content
AnastasiaT
Level 2
Dec 13, 2022 10:54 AM UTC
Solved

Capture email domain

Hi all 

I want to create a custom field that will contain a formula that will read the email address of the record and capture the email email domain. Is this possible? Can someone share a formula that works?

Thanks in advance

Anastasia

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Darshil_Shah1
Darshil_Shah1Accepted solution
Adobe Champion, Community Advisor, UG Leader
Dec 13, 2022 12:19 PM UTC

I don't think you can define rules in the Marketo formula fields to extract and store a part of the field's value. Also, formula fields have several limitations, e.g., they aren't supported in smart campaigns, cannot be exported, and emails with formula fields in them cannot be sent via batch campaigns.

 

IMO, If the domain is not set during the lead creation, you'd want to populate the domain by calling a webhook-compatible service from the flow that could extract and return the domain address of a person back. 

 

View in thread

3 replies

Darshil_Shah1
Adobe Champion, Community Advisor, UG Leader
Darshil_Shah1Adobe Champion, Community Advisor, UG LeaderAccepted solution
Adobe Champion, Community Advisor, UG Leader
Dec 13, 2022 12:19 PM UTC

I don't think you can define rules in the Marketo formula fields to extract and store a part of the field's value. Also, formula fields have several limitations, e.g., they aren't supported in smart campaigns, cannot be exported, and emails with formula fields in them cannot be sent via batch campaigns.

 

IMO, If the domain is not set during the lead creation, you'd want to populate the domain by calling a webhook-compatible service from the flow that could extract and return the domain address of a person back. 

 

Translate
    AnastasiaTAuthor
    Level 2
    Dec 19, 2022 2:41 PM UTC

    thank you!

    Translate
    SanfordWhiteman
    User Group Leader
    SanfordWhitemanUser Group Leader
    User Group Leader
    Dec 13, 2022 5:20 PM UTC

    Like Darshil says, formulas are designed for concatenation, nothing more complex. And they're also limited in where they can be used, usually making them the wrong move. 

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...