Can you validate an email address in a form by domain?
Hi,
We have a web form with a place for a respondent to enter in an email address. We would like to restrict the field so that only domains from state government agencies can be entered into the form.
Each agency has a distinct domain, and they would all have to be accepted for this to work.
Is this possible?
Best Answer
-
If you restrict the dropdown to only the options listed in the column properties, then they wouldn't be able to select an "unapproved" domain is what I was thinking with that. Make it a required field, and they won't be able to submit without selecting a domain and to select the domain they won't have any options other than approved domains.
Answers
-
Do you know how many different domains there are?
-
-
Hi Jessica,
It might be possible with the Form Logic.
I'm going to check to make sure.
Be safe and have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Yes, it would work with the Form Logic, but we might reach a limitation.
We'd use the Contain criteria and add the different domains. If the domain isn't approved, it won't show the other fields or something similar.
Would that work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå I am interested to see what you come up with with the form logic.
I was thinking using two separate fields. A text field for the first part of the email address and then a single select dropdown with the acceptable domains listed.
Email Prefix:
"paul.newcome"
Email Domain:
DROPDOWN WITH SELECTIONS
Then in the sheet you can use a separate column to pull the two together into a usable email address.
-
Yes, that was my initial thought, but I don't think that @Jessica Hodge want them to be able to submit if the domain isn't approved.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
This is a good idea and it could work! I was also thinking of doing a formula to create a conditional column in the sheet that displays true when it matches one of the domains and false when it doesn't. However, I'm not sure how that formula would work with all 42 domains. I was thinking an IF(CONTAINS, but I can't get it to work with more than one domain.
-
If you restrict the dropdown to only the options listed in the column properties, then they wouldn't be able to select an "unapproved" domain is what I was thinking with that. Make it a required field, and they won't be able to submit without selecting a domain and to select the domain they won't have any options other than approved domains.
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå Ah. That makes sense. And you would select all 42 of the appropriate domains in the logic to be able to show the other fields.
-
Yes, exactly, but I'm not use that that many conditions can be applied. We'll notice another day!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
So I'm trying to do this. I'm running into a problem though. The formula I'm using to concatenate the email parts is not working when a new entry is added to the form. Join([Email local address]1:[Email domain]2]).
The merged cell needs to populate automatically in order to not break an automation that is in place.
-
Sorry typo. it should also be [Email domain]1)
-
What do you mean by "not working"? Is it producing an error or an unexpected result? Do you have two rows above or below the new row that contain the formula?
