Use Case: Get Email Domain Using Formula in Flow

Last time we shared a long long list of the commonly used formula, and today we are going to use one of the advanced formula to build a Flow! We will try to extract the email domain from an email address.

* Big thanks to Chad for sending in the case!

Lulu Mobile use a custom object – Email Domain – to store all the domains from their current customer base. This custom object has only one custom field – Domain . They create one record for each recognized domain.

They also use the standard Contact object to store the customer data. Whenever a Contact is created or updated, they want the system to check whether the domain of the email address has already exist in the database. If yes, check a box on the Contact record.

We will use the Return Substring formula to get only the domain from the Contact’s email. Then we can use this domain to search through our custom object. If there is any record returned, we can then update the Contact record.

Return domain with @: RIGHT({!$Record.Email}, LEN({!$Record.Email}) - FIND("@",{!$Record.Email}) + 1)
Return domain without @: RIGHT({!$Record.Email}, LEN({!$Record.Email}) - FIND("@",{!$Record.Email}))

Flow Chart (deactivate last login date)

Steps (deactivate last login date)

Please wait while flipbook is loading. For more related info, FAQs and issues please refer to DearFlip WordPress Flipbook Plugin Help documentation.

Record-TriggeredGet Records
FormulaUpdate Records

Does the solution solve your problem? If not, write us what your problem is and we will build the flow for you!

Official Salesforce Help Article On Flow

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments