Capture email domain

[AnastasiaT]

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

[Darshil_Shah1 · Accepted solution]

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. 

[AnastasiaT]

thank you!

[SanfordWhiteman · Accepted solution]

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.