Email validation for Forms or Workflow conditions

Eric Fuller

Is there a way to do email address validation in Smartsheet forms or in Workflows? Using condtions such as contains '@' or '@domain.com' isn't sufficient and I can't alert form submitters that they did not submit to the form correctly.

Andrée Starå

Hi Eric,

Why wouldn't CONTAINS or similar work?

What do you want to check?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic day & Happy New Year!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

KATY PRUETT

I believe I have the same question. In my case, I am creating a form that requires a field be completed using an email address rather than just a name. How can I make an email address format the required value?

Genevieve P.

Hi @KATY PRUETT

Do you have a column in your sheet that's a Contact List type of column? You can make this a required field.

Here's more information on the Contact List type of column: https://help.smartsheet.com/articles/2480241-column-type-reference#contactlist

Kasel Lesak

@Genevieve P I just tried the suggestion above and it doesn't seem to work as I expected.

I have a form where I want to make sure that people give me an email address that contains at least an "@" symbol and a "." so if the individual on the form enters kasel, it should prevent them from saving or give an error, vs if they say kasel@gmail.com it lets them save.

Genevieve P.

Hi @Kasel Lesak

Could you implement @Andrée Starå 's solution of setting up a workflow to check if there's an @ or .?

If you put it in a workflow as a condition, like this, then you could send an Update Request to the user who submitted the form (this would require that they log in to fill out the form so Smartsheet can capture the email that way).

Otherwise, I would make sure that your helper text is extremely clear:

David Grooms

https://community.smartsheet.com/discussion/comment/258070#Comment_258070

Has anyone at Smartsheet seen how ridiculously easy format validation is on the FREE Google forms app?

I couldn't put my help text in clearer words. NO ONE reads or follows that help text.

There seem to be forum posts going back to 2016 of people asking for this very basic functionality. But I only see responses with goofy workarounds and no indication that Smartsheet understands the value.

Ross George

https://community.smartsheet.com/discussion/comment/284292#Comment_284292

I agree with David - this is pretty basic functionality for many competitors so its seems strange it hasn't been implemented. As always, there is a hack that will get you 70% of a solution...

I'm not sure the proposed hack works either. If I want to add a Contacts list to the form but allow the user to enter a new email then I don't think I can use CONTAINS to do what is suggested. The form field would need to be a text entry.

Daniel Hibbets

Here is a solution: On a Form you want to have Email entry: Name@doman.com: That column on the back end needs to be a text field. Then you have a second column with the formula " =Email@row" That column should be set up as a contact field and for all your automations. This will duplicate the email into two columns- One as a Text, second as a Contact. Now to Validate the information. Set up a Third Column and use the following formula: =IF(CONTAINS("@doman.com", [Email]@row), "True", IF(CONTAINS("@Doman2.com", [Requestor Email]@row), "True", "False"))

This will allow you to have a Domain validation check on entries. If the Email is not from @domain.com or @Domain2.com, it will produce a False in the Validation column and allow you to prevent it from going further into workflows or approvals or even kick an error back out, you could also have it auto cancel or delete a ticket based on that false information. If True it proceeds to other processes.

Also your Email Entry Column now can have Email validation on the text field to ensure it's at least a proper email address, if its from a bad domain like a gmail.com then the above solution handles that so personal emails can't be used in a process.

brianswilson

It would be better if some kind of regular expression matching could be implemented. This would allow users to set up varied types of matching, not just emails. This would be a very powerful feature to implement. Users could set up something like "[:alphanumeric:]_[:alphanumeric:]@domain.com" or "[:alphanumeric:].[:alphanumeric:]@domain.com" to validate emails, but could also use the feature to validate other types of data.

Sylvia

Is there a solution to have validation two fields in the form ?

I'm using a form to capture email address and want to make sure the user types the correct email address.

So, I have created a new field for email but how can we validate two fields?

If the user types second wrong, smartsheet should prompt the user to enter new email address.

Any input will be highly appreciated. Thank you!