The Community forums are being phased out in favor of a new Slack group.
Add your email address below to get an invitation to join the community slack group
Get Website URL from Email Address - Possible?
Hi All - Longtime Pro user with a unique question.
We use SalesForce to manage leads and instead of adding a separate field on the form for "Website", I'd like to know if anyone uses the email address to extract the domain.
Ex: Lead is entered through Formidable Form, and we have a hidden field with a formula to extract the domain name from the mail address and send it through to SF with the domain in place.
We are also using the Formidable to SalesForce addon.
Obviously, I'll have to exclude emails with gmail, yahoo, aol, etc.
Thanks in advance.
September 21, 2018 at 2:17 pm
What you are asking to do is a logistical nightmare. You won't ever be able to accurately determine if the email address is for the domain in question. You mentioned excluding gmail, yahoo, aol, etc., but what about every other ISP that someone might use as their email address apart from their domain? There could literally be thousands of them.
September 21, 2018 at 2:37 pm
Thanks - and I do understand that much. Currently, 75-80% of the leads we receive use their company email address when requesting further information. It will save time for our sales team during the discovery/qualification process if the domain is populated, versus retyping it, or using copy/paste and saving the record in SalesForce.
I understand the issue with vanity addresses coming in, but we've used this method through Pardot forms for several years, and the Pardot forms automatically did this for us. After switching all our web based leads to Formidable, we'd like to get the functionality back in place as it was a small, time saving measure and required less work on the discovery.
Thanks
September 22, 2018 at 6:56 am
You'll need to do this with custom code then, either jQuery on the front end or PHP on the back end.
On the front end, you have have jQuery monitor the email address field and on blur (when someone exits the field), have the function parse the email address and save everything after the @ sign to a hidden field. It could even build the suggested URL before saving to the hidden field.
If you want to do it in PHP, you would need to write a similar function and hook it into frm_pre_create_entry.
Either way, it requires custom code and perhaps the skills of a Formidable developer.
Discussion closed.