Form Response Validation

David Grooms · 03/19/21

How can I validate the format of responses?

For example, I want phone numbers entered as 000.000.0000, so when a user enters their phone as 0000000000, or 000-000-0000, they will be shown an error message that directs them to enter it in the appropriate format.

Also, is there any way to validate an email address?

James Keuning · 03/21/21

One method would be to use FIND or CONTAINS, and then alert on a bunch of test results

DOES NOT CONTAIN:

Either @ symbol, or a period, or a period and one to the top-level domains (.com, .edu. etc.)

DOES CONTAIN:

starts or ends with a period

contains any punctuation other than a period (including more than one @ symbol)

other imaginative stuff that does not belong

I agree that it is a bad proxy.

Paul Newcome · 03/22/21

There is no way to accomplish this within the form itself. You would have to evaluate the data after form submission and send out automated update requests. Feel free to Submit a Product Enhancement Request when you are able. In the meantime, you could look into 3rd party forms such as Google forms. I am not 100% sure if they allow this kind of data validation, but it could be worth a look. Google forms also integrates very well with Smartsheet.

David Grooms · 03/22/21

https://community.smartsheet.com/discussion/comment/284413#Comment_284413

I have been researching this for a couple of days now and it seems that folks have been wondering why it's not a built-in feature for as far back as 2016. I do know 100% that Google provides this functionality for free in their form application. But, our company is moving off of Google apps. So, lose/lose. Oh well.

Form Response Validation

Answers

Categories